Code

来源:互联网 发布:淘宝买东西从来不评价 编辑:程序博客网 时间:2024/04/29 14:48

if(!Page.IsPostBack)
{
DataTable dt = new DataTable();
DataRow myDataRow;
dt.Columns.Add("Id");
dt.Columns.Add("MemberId");
dt.Columns.Add("MemberName");
dt.Columns.Add("YwName");
dt.Columns.Add("SaleId");
dt.Columns.Add("ServId");
dt.Columns.Add("TechClFlag");
dt.Columns.Add("IsJD");
string strSql="select Count(Id) from t_FormInfo "
string strCount=dal.RunSql(strSql);
for (int i = 0; i < int.Parse(strCount);i++ )
{
myDataRow = dt.NewRow();
string strTechId = dal.RunSql("select TecId from t_FormInfo");
string values = strTechId;
string[] sites = values.Split(',');
foreach (string txt in sites)
{
if (txt == this.UId.ToString())
{
SqlDataReader dr=dal.RunSqlNameDataReader("select Id,MemberId,MemberName,YwName,SaleId,ServId,TechClFlag,IsJD from t_FormInfo");
if(dr.Read())
{
strId = dr["Id"].ToString();
strMemberId = dr["MemberId"].ToString();
strMemberName = dr["MemberName"].ToString();
strYwName = dr["YwName"].ToString();
strSaleId = dr["SaleId"].ToString();
strServId = dr["ServId"].ToString();
strTechFlag = dr["TechCLFlag"].ToString();
strIsJD = dr["IsJD"].ToString();
}
dr.Close();
}
}
myDataRow["Id"] = strId;
myDataRow["MemberId"] = strMemberId;
myDataRow["MemberName"] = strMemberName;
myDataRow["YwName"] = strYwName;
myDataRow["SaleId"] = strSaleId;
myDataRow["ServId"] = strServId;
myDataRow["TechClFlag"] = strTechFlag;
myDataRow["IsJD"] = strIsJD;
//dt.Rows.i(new object[] { strId, strMemberId, strMemberName, strYwName, strSaleId, strServId, strTechFlag, strIsJD });
dt.Rows.Add(myDataRow);

}
this.GridView1.DataSource = dt;
this.GridView1.DataBind();

//sql = "select * from t_FormInfo where IsJD=0 and TecId=" + base.UId + " order by CreateTime Desc" //未结
//gridViewBind();
}

原创粉丝点击