您好,登录后才能下订单哦!
#region动态生成gridview
///<summary>
///动态生成gridview
///</summary>
///<paramname="strName">表名</param>
privatevoid BindGridView(stringstrName)
{
if(!string.IsNullOrEmpty(strName))
{
string strSql= string.Format(@"selecta.COLUMN_NAME, t.comments as filed
fromuser_col_comments t, user_tab_columns a
wheret.table_name = upper('{0}') and t.table_name = a.TABLE_NAME and t.column_name =a.COLUMN_NAME
order by filed", strName);
DataTabledt = OracleHelperImm.getDataTable(strSql);
if(dt != null && dt.Rows.Count > 0)
{
gridList.Columns.Clear();
BindFixed();
foreach (DataRow dr in dt.Rows)
{
if (strName == "OWT_blocnew")
{
if (dr[0].ToString() == "BLOC_NAME")
{
BoundField bfColumn = newBoundField();
bfColumn.DataField = dr[0].ToString();
bfColumn.HeaderText = dr[1].ToString();
gridList.Columns.Add(bfColumn);
}
}
else
{
if (dr[0].ToString() != "ID"&& dr[0].ToString() != "WORKORDER_ID")
{
BoundField bfColumn = newBoundField();
bfColumn.DataField = dr[0].ToString();
bfColumn.HeaderText = dr[1].ToString();
gridList.Columns.Add(bfColumn);
}
}
}
}
}
else
{
gridList.Columns.Clear();
BindFixed();
}
}
///<summary>
///工单固定列表
///</summary>
privatevoid BindFixed()
{
TemplateFieldtemplateField0 = new TemplateField();
templateField0.ItemTemplate = new chkItem1();
gridList.Columns.Add(templateField0);
BoundFieldbfColumn10 = new BoundField();
bfColumn10.DataField = "batch_no";
bfColumn10.HeaderText = "批次号";
gridList.Columns.Add(bfColumn10);
BoundFieldbfColumn11 = new BoundField();
bfColumn11.DataField = "order_id";
bfColumn11.HeaderText = "工单号";
gridList.Columns.Add(bfColumn11);
BoundFieldbfColumn1 = new BoundField();
bfColumn1.DataField = "ORDER_STATE";
bfColumn1.HeaderText = "工单状态";
gridList.Columns.Add(bfColumn1);
BoundFieldbfColumn2 = new BoundField();
bfColumn2.DataField = "type_name";
bfColumn2.HeaderText = "工单类型";
gridList.Columns.Add(bfColumn2);
BoundFieldbfColumn3 = new BoundField();
bfColumn3.DataField = "CUSTOM_NO";
bfColumn3.HeaderText = "受理号码";
bfColumn3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
gridList.Columns.Add(bfColumn3);
BoundFieldbfColumn4 = new BoundField();
bfColumn4.DataField = "DEAL_NAME";
bfColumn4.HeaderText = "处理人";
gridList.Columns.Add(bfColumn4);
BoundFieldbfColumn5 = new BoundField();
bfColumn5.DataField = "CREATE_NAME";
bfColumn5.HeaderText = "创建人";
gridList.Columns.Add(bfColumn5);
BoundFieldbfColumn6 = new BoundField();
bfColumn6.DataField = "COM_NAME";
bfColumn6.HeaderText = "所属县市";
gridList.Columns.Add(bfColumn6);
BoundFieldbfColumn7 = new BoundField();
bfColumn7.DataField = "CREATE_DATE";
bfColumn7.HeaderText = "开始时间";
bfColumn7.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn7);
BoundFieldbfColumn8 = new BoundField();
bfColumn8.DataField = "LIMITED_TIME";
bfColumn8.HeaderText = "最后期限";
bfColumn8.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn8);
BoundFieldbfColumn9 = new BoundField();
bfColumn9.DataField = "DEAL_DATE";
bfColumn9.HeaderText = "分公司处理时间";
bfColumn9.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn9);
BoundFieldbfColumn13 = new BoundField();
bfColumn13.DataField = "no_answer";
bfColumn13.HeaderText = "无人接听次数";
bfColumn13.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn13);
BoundFieldbfColumn14 = new BoundField();
bfColumn14.DataField = "user_reject";
bfColumn14.HeaderText = "用户拒接次数";
bfColumn14.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn14);
BoundFieldbfColumn12 = new BoundField();
bfColumn12.DataField = "FINISH_DATE";
bfColumn12.HeaderText = "完成时间";
bfColumn12.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gridList.Columns.Add(bfColumn12);
TemplateFieldtemplateField = new TemplateField();
templateField.HeaderText = "操作";
templateField.ItemTemplate =new chkItem();
gridList.Columns.Add(templateField);
}
publicclass chkItem :Control, ITemplate
{
publicvoid InstantiateIn(Controlcontainer)
{
HyperLinkchk = new HyperLink();
chk.ID = "chkItem";
chk.Text = "下载";
chk.ForeColor =System.Drawing.Color.Blue;
container.Controls.Add(chk);
}
}
publicclass chkItem1: Control, ITemplate
{
publicvoid InstantiateIn(Controlcontainer)
{
HtmlInputCheckBoxcb = new HtmlInputCheckBox();
cb.ID = "recid";
container.Controls.Add(cb);
}
}
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。