//获取制作明细数据 public void GetMSdata() { string msId = Request.Form["msId"].ToString(); InitList(msId); int page = Convert.ToInt32(Request["page"]); int rows = Convert.ToInt32(Request["rows"]); InitPager(rows, page, tablename); DataTable dt1 = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); sqlText = "select count(1) from " + tablename + " where" + strWhere(); DataTable dt2 = DBCallCommon.GetDTUsingSqlText(sqlText); int num = 0; if (dt2.Rows.Count > 0) { num = Convert.ToInt16(dt2.Rows[0][0]); } string json = JsonHelper.CreateJsonParameters(dt1, true, num); Response.Write(json); }
protected void getStaffInfo(string st_id, string DEP_NAME, int i) { string sql = string.Format("select ST_NAME,ST_ID,ST_DEPID from TBDS_STAFFINFO as a inner join TBCM_HT_SETTING as b on a.ST_ID=b.per_id where a.ST_PD='0'and b.dep_id='{0}' and per_sfjy='0' and per_type='0'", st_id); //bindInfo(sql, i, DEP_NAME, st_id); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (st_id == "01") { for (int j = 0; j < dt.Rows.Count; j++) { DataTable ld = new DataTable(); ld.Columns.Add("ST_NAME"); ld.Columns.Add("ST_ID"); ld.Columns.Add("ST_DEPID"); ld.Rows.Add(dt.Rows[j][0].ToString(), dt.Rows[j][1].ToString(), dt.Rows[j][2].ToString()); bindInfo(ld, st_id + j.ToString(), DEP_NAME, i); i++; } } else { bindInfo(dt, st_id, DEP_NAME, i); } }
protected void btn_daochu_Click(object sender, EventArgs e) { int temp = isselected(); List <string> list = new List <string>(); if (temp == 1) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('您没有选择数据,本次操作无效!');", true); } else if (temp == 2) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('您选择的数据包含多条订单,本次操作无效!');", true); } else { string sqltext = ""; string sqltext2 = ""; string sqltext3 = ""; string docnum = ""; string money = ""; foreach (RepeaterItem Reitem in Purordertotal_list_Repeater.Items) { System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)Reitem.FindControl("CKBOX_SELECT"); if (cb.Checked) { docnum = ((System.Web.UI.WebControls.Label)Reitem.FindControl("TA_DOCNUM")).Text; //sqltext = "select TA_DOCNUM, TA_ZDRNAME,CONVERT(varchar, TA_ZDTIME ,23) as TA_ZDTIME,TA_SUPPLYNAME,TA_AMOUNT,TA_TOTALWGHT,TA_TOTALNOTE,TA_PTC,TA_NUM,TA_WXTYPE,TA_PROCESS,TA_UWGHT,TA_WGHT,TA_PRICE,TA_MONEY,TA_JHQ,TA_SJJHQ,TA_NOTE from VIEW_TBMP_ACCOUNTS where TA_DOCNUM='" + docnum + "'"; sqltext = " select TA_ENGID,TA_TUHAO,TA_ZONGXU,TA_MNAME,TA_CAIZHI,TA_UNUM,TA_NUM,TA_UWGHT,TA_WGHT,TA_PROCESS,TA_PRICE,TA_MONEY,PIC_JGNUM ,TA_TOTALNOTE,TA_ZDRNAME,TA_SUPPLYNAME,TA_TOTALWGHT,TA_AMOUNT from VIEW_TBMP_ACCOUNTS where TA_DOCNUM='" + docnum + "' order by TA_ENGID "; sqltext2 = "select TA_ENGID,TA_WXTYPE,'',TO_ENGNAME, SUM(TA_NUM),SUM(TA_WGHT),SUM(TA_MONEY),TA_JHQ,BJSJ,PIC_JGNUM from VIEW_TBMP_ACCOUNTS AS a left join (select PTC,BJSJ ,ISAGAIN,rn from (select *,row_number() over(partition by PTC order by ISAGAIN ) as rn from View_TBQM_APLYFORITEM) as a where rn<=1 ) as B ON A.TA_PTC=B.PTC WHERE TA_DOCNUM='" + docnum + "' group by TA_ENGID,TA_WXTYPE,TO_ENGNAME,TA_JHQ,BJSJ,PIC_JGNUM"; sqltext3 = "select dbo.MP_Transfor(TA_AMOUNT) as money FROM VIEW_TBMP_ACCOUNTS WHERE TA_DOCNUM='" + docnum + "'"; money = DBCallCommon.GetDTUsingSqlText(sqltext3).Rows[0]["money"].ToString(); } } ExportDataItem1(sqltext, sqltext2, docnum, money); } }
protected void GetYZZT() { string sql = ""; if (DropDownListproject.SelectedValue != "-请选择-") { if (DropDownListengeering.SelectedValue.Trim() != "") { sql = "SELECT KHZT_ID,KHZT_PJNAME,KHZT_ENGNAME,KHZT_ZW,KHZT_ZV,KHZT_RZB,KHZT_DJTIME,KHZT_ZL1,KHZT_TJ1,KHZT_ZL2,KHZT_TJ2,KHZT_BZ FROM TBTM_KHZT " + "WHERE KHZT_YEAR='" + DropDownListYear.SelectedValue.ToString() + "' and KHZT_PJNAME='" + DropDownListproject.SelectedValue + "' and KHZT_ENGNAME='" + DropDownListengeering.SelectedValue + "'"; } else { sql = "SELECT KHZT_ID,KHZT_PJNAME,KHZT_ENGNAME,KHZT_ZW,KHZT_ZV,KHZT_RZB,KHZT_DJTIME,KHZT_ZL1,KHZT_TJ1,KHZT_ZL2,KHZT_TJ2,KHZT_BZ FROM TBTM_KHZT " + "WHERE KHZT_YEAR='" + DropDownListYear.SelectedValue.ToString() + "' and KHZT_PJNAME='" + DropDownListproject.SelectedValue + "' "; } } else { sql = "SELECT KHZT_ID,KHZT_PJNAME,KHZT_ENGNAME,KHZT_ZW,KHZT_ZV,KHZT_RZB,KHZT_DJTIME,KHZT_ZL1,KHZT_TJ1,KHZT_ZL2,KHZT_TJ2,KHZT_BZ FROM TBTM_KHZT " + "WHERE KHZT_YEAR='" + DropDownListYear.SelectedValue.ToString() + "'"; } System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); RepeaterYZZT.DataSource = dt; RepeaterYZZT.DataBind(); if (dt.Rows.Count == 0) { Panel5.Visible = true; } else { Panel5.Visible = false; } }
private void Bind_Audit_Info() { string sqltext = "select * from View_TBMP_FINISHED_OUT_Audit where TFO_DOCNUM='" + txt_docnum.Text.ToString() + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { firstid.Value = dt.Rows[0]["Fir_Per"].ToString(); txt_first.Text = dt.Rows[0]["name1"].ToString(); if (dt.Rows[0]["Fir_Jg"].ToString() != "0") { rbl_first.SelectedValue = dt.Rows[0]["Fir_Jg"].ToString(); } first_time.Text = dt.Rows[0]["Fir_Sj"].ToString(); first_opinion.Text = dt.Rows[0]["Fir_Yj"].ToString(); secondid.Value = dt.Rows[0]["Sec_Per"].ToString(); txt_second.Text = dt.Rows[0]["name2"].ToString(); if (dt.Rows[0]["Sec_Jg"].ToString() != "0") { rbl_second.SelectedValue = dt.Rows[0]["Sec_Jg"].ToString(); } second_time.Text = dt.Rows[0]["Sec_Sj"].ToString(); second_opinion.Text = dt.Rows[0]["Sec_Yj"].ToString(); thirdid.Value = dt.Rows[0]["Thi_Per"].ToString(); txt_third.Text = dt.Rows[0]["name3"].ToString(); if (dt.Rows[0]["Thi_Jg"].ToString() != "0") { rbl_third.SelectedValue = dt.Rows[0]["Thi_Jg"].ToString(); } third_time.Text = dt.Rows[0]["Thi_Sj"].ToString(); third_opinion.Text = dt.Rows[0]["Thi_Yj"].ToString(); Control_SHLC(); } }
//导出 protected void btnexport_Click(object sender, EventArgs e) { string sqlgjj = "select GJ_DATE,ST_WORKNO,ST_NAME,ST_CONTR,DEP_NAME,ST_IDCARD,GJ_JCJS,(GJ_DW+GJ_GR) as GJ_HJ,GJ_DW,GJ_GR,(GJ_DWB+GJ_GRB)as GJ_HJB,GJ_DWB,GJ_GRB,GJ_BZ from View_OM_GJJ where " + Creatconstr(); System.Data.DataTable dtgjj = DBCallCommon.GetDTUsingSqlText(sqlgjj); string filename = "公积金导出.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("公积金导出模板.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dtgjj.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 1); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dtgjj.Columns.Count; j++) { string str = dtgjj.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dtgjj.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
protected void savedate() { List <string> sqltextlist = new List <string>(); string sqltext = ""; string ptc = ""; string note = ""; foreach (RepeaterItem retim in PurorderdetailRepeater.Items) { ptc = ((Label)retim.FindControl("TA_PTC")).Text; note = ((TextBox)retim.FindControl("TA_NOTE")).Text; sqltext = "update TBMP_ACCOUNTS set TA_NOTE='" + note + "' WHERE TA_PTC='" + ptc + "'"; sqltextlist.Add(sqltext); } sqltext = "select sum(TA_MONEY) as amount,sum(TA_WGHT) as weight from TBMP_ACCOUNTS where TA_DOCNUM='" + gloabsheetno + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); double f_money = Convert.ToDouble(dt.Rows[0]["amount"].ToString()); double f_weight = Convert.ToDouble(dt.Rows[0]["weight"].ToString()); sqltext = "update TBMP_ACCOUNTS set TA_AMOUNT=" + f_money + " ,TA_TOTALWGHT=" + f_weight + ", TA_TOTALNOTE='" + Tb_note.Text.ToString() + "' where TA_DOCNUM='" + gloabsheetno + "'"; sqltextlist.Add(sqltext); DBCallCommon.ExecuteTrans(sqltextlist); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('保存成功!');window.opener.location.reload();self.close()", true); }
protected void checked_list_Repeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { string sql = "select JS_FATHERID from PM_CPFYJSD"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); List <string> list = new List <string>(); for (int i = 0, length = dt.Rows.Count; i < length; i++) { list.Add(dt.Rows[i]["JS_FATHERID"].ToString()); } if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { string ICL_SHEETNO = ((Label)e.Item.FindControl("lbdh")).Text; if (list.Contains(ICL_SHEETNO)) { ((Label)e.Item.FindControl("lbJT")).Text = "已分配"; ((Label)e.Item.FindControl("lbJT")).ForeColor = Color.Red; } else { ((Label)e.Item.FindControl("lbJT")).Text = "未分配"; } } }
protected int maxID(string pid) { int tempmax = 0; string sql = ""; DataTable tb = new DataTable(); DataColumn tc = new DataColumn("mid", System.Type.GetType("System.String")); tb.Columns.Add(tc); if (DDLname.SelectedItem.Text == "标准件") { sql = "SELECT DISTINCT BZJ_ID AS mid FROM TBMA_BZJINFO WHERE BZJ_ID LIKE '" + pid + "_______'"; } if ((DDLclass.SelectedItem.Text == "原材料") && (DDLname.SelectedItem.Text != "标准件")) { sql = "SELECT DISTINCT RM_ID AS mid FROM TBMA_RAWMAINFO WHERE RM_ID LIKE '" + pid + "_______'"; } if (DDLclass.SelectedItem.Text == "低值易耗品") { sql = "SELECT DISTINCT LVCG_ID AS mid FROM TBMA_LVCGMAINFO WHERE LVCG_ID LIKE '" + pid + "_______'"; } tb = DBCallCommon.GetDTUsingSqlText(sql); if (tb.Rows.Count == 0) { return(tempmax); } for (int i = 0; i < tb.Rows.Count; i++) { int temp = Convert.ToInt32((tb.Rows[i]["mid"].ToString()).Substring(6, 6)); if (temp > tempmax) { tempmax = temp; } } tb.Clear(); return(tempmax); }
//导出 protected void btnexport_Click(object sender, EventArgs e) { string sqlshbx = "select SH_DATE,ST_WORKNO,ST_NAME,ST_CONTR,DEP_NAME,SH_JS,ST_REGIST,SH_QYYLDW,SH_SYBXDW,SH_JBYLDW,SH_GSDW,SH_SYDW,SH_QYYLDWB,SH_SYBXDWB,SH_JBYLDWB,SH_GSDWB,SH_SYDWB,(isnull(SH_QYYLDW,0)+isnull(SH_SYBXDW,0)+isnull(SH_JBYLDW,0)+isnull(SH_GSDW,0)+isnull(SH_SYDW,0)+isnull(SH_QYYLDWB,0)+isnull(SH_SYBXDWB,0)+isnull(SH_JBYLDWB,0)+isnull(SH_GSDWB,0)+isnull(SH_SYDWB,0)) as SH_DWBXHJ,SH_QYYLGR,SH_SYBXGR,SH_JBYLGR,SH_QYYLGRB,SH_SYBXGRB,SH_JBYLGRB,SH_DEYLGR,(isnull(SH_QYYLGR,0)+isnull(SH_SYBXGR,0)+isnull(SH_JBYLGR,0)+isnull(SH_QYYLGRB,0)+isnull(SH_SYBXGRB,0)+isnull(SH_JBYLGRB,0)+isnull(SH_DEYLGR,0)) as SH_GRBXHJ,SH_QT,(isnull(SH_QYYLDW,0)+isnull(SH_SYBXDW,0)+isnull(SH_JBYLDW,0)+isnull(SH_GSDW,0)+isnull(SH_SYDW,0)+isnull(SH_QYYLDWB,0)+isnull(SH_SYBXDWB,0)+isnull(SH_JBYLDWB,0)+isnull(SH_GSDWB,0)+isnull(SH_SYDWB,0)+isnull(SH_QYYLGR,0)+isnull(SH_SYBXGR,0)+isnull(SH_JBYLGR,0)+isnull(SH_QYYLGRB,0)+isnull(SH_SYBXGRB,0)+isnull(SH_JBYLGRB,0)+isnull(SH_DEYLGR,0)+isnull(SH_QT,0)) as SH_GRXJ,SH_NOTE from View_OM_SHBX where " + Creatconstr(); System.Data.DataTable dtshbx = DBCallCommon.GetDTUsingSqlText(sqlshbx); string filename = "社会保险导出.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("社会保险导出模板.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dtshbx.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 1); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dtshbx.Columns.Count; j++) { string str = dtshbx.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dtshbx.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
//导出汇总 protected void btnexport_Click(object sender, EventArgs e) { string sqlkqtj = "select ST_WORKNO,ST_NAME,DEP_NAME,ST_DEPID1,KQ_CHUQIN,KQ_GNCC,KQ_GWCC,KQ_BINGJ,KQ_SHIJ,KQ_KUANGG,KQ_DAOXIU,KQ_CHANJIA,KQ_PEICHAN,KQ_HUNJIA,KQ_SANGJIA,KQ_GONGS,KQ_NIANX,KQ_BEIYONG1,KQ_BEIYONG2,KQ_BEIYONG3,KQ_BEIYONG4,KQ_BEIYONG5,KQ_BEIYONG6,KQ_QTJIA,KQ_JIEDIAO,KQ_ZMJBAN,KQ_JRJIAB,KQ_ZHIBAN,KQ_YEBAN,KQ_ZHONGB,KQ_CBTS,KQ_YSGZ from (select KQ_ST_ID,ST_WORKNO,ST_NAME,DEP_NAME,ST_DEPID1,ST_DEPID,sum(KQ_GNCC) as KQ_GNCC,sum(KQ_GWCC) as KQ_GWCC,sum(KQ_BINGJ) as KQ_BINGJ,sum(KQ_SHIJ) as KQ_SHIJ,sum(KQ_KUANGG) as KQ_KUANGG,sum(KQ_DAOXIU) as KQ_DAOXIU,sum(KQ_CHANJIA) as KQ_CHANJIA,sum(KQ_PEICHAN) as KQ_PEICHAN,sum(KQ_HUNJIA) as KQ_HUNJIA,sum(KQ_SANGJIA) as KQ_SANGJIA,sum(KQ_GONGS) as KQ_GONGS,sum(KQ_NIANX) as KQ_NIANX,sum(KQ_BEIYONG1) as KQ_BEIYONG1,sum(KQ_BEIYONG2) as KQ_BEIYONG2,sum(KQ_BEIYONG3) as KQ_BEIYONG3,sum(KQ_BEIYONG4) as KQ_BEIYONG4,sum(KQ_BEIYONG5) as KQ_BEIYONG5,sum(KQ_BEIYONG6) as KQ_BEIYONG6,sum(KQ_QTJIA) as KQ_QTJIA,sum(KQ_JIEDIAO) as KQ_JIEDIAO,sum(KQ_ZMJBAN) as KQ_ZMJBAN,sum(KQ_JRJIAB) as KQ_JRJIAB,sum(KQ_ZHIBAN) as KQ_ZHIBAN,sum(KQ_YEBAN) as KQ_YEBAN,sum(KQ_ZHONGB) as KQ_ZHONGB,sum(KQ_CBTS) as KQ_CBTS,sum(KQ_YSGZ) as KQ_YSGZ,sum(KQ_CHUQIN) as KQ_CHUQIN from View_OM_KQTJ where " + StrWhere() + " group by ST_DEPID,KQ_ST_ID,ST_WORKNO,ST_NAME,DEP_NAME,ST_DEPID1)t where " + Creatconstr(); System.Data.DataTable dtkqtj = DBCallCommon.GetDTUsingSqlText(sqlkqtj); string filename = "考勤统计导出.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("考勤统计导出模板.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dtkqtj.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 2); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dtkqtj.Columns.Count; j++) { string str = dtkqtj.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dtkqtj.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
//删除合同评审(补充协议)附件 public static void Del_RevAttachment(string psdh) { //删除对应的文件,用唯一编号关联 //一个合同可能对应多个附件,要循环删除 string sql_atfilepath = "select AT_FILEPATH from TBPM_ATTACHMENTS where AT_HTBH='" + psdh + "'"; System.Data.DataTable dt_atfilepath = DBCallCommon.GetDTUsingSqlText(sql_atfilepath); for (int i = 0; i < dt_atfilepath.Rows.Count; i++) { string fileName = dt_atfilepath.Rows[i]["AT_FILEPATH"].ToString(); //string fileName = DBCallCommon.GetFieldValue(dt_atfilepath.Rows[i]["AT_FILEPATH"].ToString()); string attachPath = @"E:/合同管理附件";//附件上传位置 string proj_type = "评审合同文档"; string filepath = CommonFun.CreateDirName(attachPath, proj_type) + fileName; //判断文件是否存在,如果不存在提示重新上传 if (System.IO.File.Exists(filepath)) { DBCallCommon.DeleteFile(filepath); //重新读出附件信息 } } DBCallCommon.ExeSqlText("delete from TBPM_ATTACHMENTS where AT_HTBH='" + psdh + "'"); }
//导出 protected void btnexport_OnClick(object sender, EventArgs e) { string sql = "select SupplierName,sum(WG_AMOUNT) as WG_AMOUNT,sum(WG_CTAMTMNY) as WG_CTAMTMNY from (select WG_CODE,left(CONVERT(CHAR(10),WG_VERIFYDATE,23),10) as WG_VERIFYDATE,case when SupplierName is null then WG_COMPANY else SupplierName end as SupplierName,WG_MARID,MNAME,GUIGE,CAIZHI,WG_RSNUM,WG_UPRICE,WG_AMOUNT,WG_CTAMTMNY,WG_GJSTATE,WG_GJFLAG from View_SM_IN)t where " + strstring() + " group by SupplierName"; System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); string filename = "未勾稽物料按供应商汇总.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("未勾稽物料按供应商汇总.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dt.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 1); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dt.Columns.Count; j++) { string str = dt.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dt.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
//工装任务 public void AddgongzTask() { List <string> list = new List <string>(); string taskidgz = Request.Form["taskIdgz"].ToString(); string shebeigz = Request.Form["shebeigz"].ToString(); if (taskidgz.Contains('.')) { Response.Write("errtaskid"); } else { sql = "select count(1) from TBPM_TCTSASSGN where TSA_ID='" + taskidgz + "'"; DataTable dtgz = DBCallCommon.GetDTUsingSqlText(sql); if (!dtgz.Rows[0][0].ToString().Contains('0')) { Response.Write("false"); } else { sql = "insert into TBPM_TCTSASSGN(TSA_ID,TSA_PJID,TSA_ENGNAME) values ('" + taskidgz + "','GONGZHUANG','" + shebeigz + "')"; list.Add(sql); string sqlText = "insert into TBMP_MANUTSASSGN(MTA_ID,MTA_PJID,MTA_ENGNAME) values ('" + taskidgz + "','GONGZHUANG','" + shebeigz + "')"; list.Add(sqlText); try { DBCallCommon.ExecuteTrans(list); Response.Write("true"); } catch (Exception) { Response.Write("false"); } } } }
//导出 protected void bt_daochu_click(object sender, EventArgs e) { string sqlgys = "select CS_NAME,CS_ADDRESS,CS_PHONO,CS_FAX,CS_CONNAME,CS_COREBS,CS_MCODE,CS_Bank,CS_Account,CS_TAX, + case when CS_TYPE=1 then '客户' when CS_TYPE=2 then '采购供应商' when CS_TYPE=3 then '运输公司' when CS_TYPE=4 then '技术外协分包商' when CS_TYPE=5 then '生产外协分包商' when CS_TYPE=6 then '原材料销售供应商' when CS_TYPE=7 then '其它' end AS CS_TYPE,CS_FILLDATE,CS_MANCLERK,CS_NOTE from TBCS_CUSUPINFO where " + Strwhere(); System.Data.DataTable dtgys = DBCallCommon.GetDTUsingSqlText(sqlgys); string filename = "供应商列表.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("供应商列表.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dtgys.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 2); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dtgys.Columns.Count; j++) { string str = dtgys.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dtgys.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
//明细数据 private void bindmxdata() { spbh = Request.QueryString["spid"].ToString().Trim(); string sqltext = "select * from OM_JXGZYESP where bh='" + spbh.ToString().Trim() + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { tb_yearmonth.Text = dt.Rows[0]["yearmonth"].ToString().Trim(); txt_contents.Text = dt.Rows[0]["things"].ToString().Trim(); lbfqrname.Text = dt.Rows[0]["creatstname"].ToString().Trim(); lbfqrid.Text = dt.Rows[0]["creatstid"].ToString().Trim(); lbfqtime.Text = dt.Rows[0]["creattime"].ToString().Trim(); txtJXYE.Text = dt.Rows[0]["MonthYuE"].ToString().Trim(); drpdepartment.SelectedItem.Text = dt.Rows[0]["jxadddepartment"].ToString().Trim(); string sql = "SELECT DISTINCT DEP_CODE FROM TBDS_DEPINFO where DEP_NAME ='" + dt.Rows[0]["jxadddepartment"].ToString().Trim() + "'"; DataTable dtw = DBCallCommon.GetDTUsingSqlText(sql); if (dtw.Rows.Count > 0) { drpdepartment.SelectedValue = dtw.Rows[0]["DEP_CODE"].ToString().Trim(); } } }
private DataTable GetTotalData() { string time = ""; string bankname = ""; //开户行 string bankaccount = ""; //银行帐号 sql = " select * from TBCM_JSDDETAIL where conid='" + htbh + "' "; DataTable dt5 = DBCallCommon.GetDTUsingSqlText(sql); if (dt5.Rows.Count > 0) { time = dt5.Rows[0]["JSDDATE"].ToString(); bankname = dt5.Rows[0]["DEPOSITBANK"].ToString(); bankaccount = dt5.Rows[0]["BANKACUNUM"].ToString(); } sql = "select '" + time + "' as PCON_RIQI,PCON_NAME,"; sql += " PCON_BCODE,PCON_CUSTMNAME,'" + bankname + "' as PCON_DEPOSITBANK,'" + bankaccount + "' as PCON_BANKACUNUM,PCON_BALANCEACNT"; sql += " from TBPM_CONPCHSINFO where PCON_BCODE='" + htbh + "' "; DataTable dt3 = DBCallCommon.GetDTUsingSqlText(sql); return(dt3); }
protected void Textname_TextChanged(object sender, EventArgs e) { int num = (sender as TextBox).Text.Trim().IndexOf("|", 0); if (num > 0) { string stid = (sender as TextBox).Text.Trim().Substring(0, num); string sqlText = "select * from View_TBDS_STAFFINFO where ST_ID='" + stid + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText); if (dt.Rows.Count > 0) { lbstid.Text = stid; txtname.Text = dt.Rows[0]["ST_NAME"].ToString().Trim(); txtdepartment.Text = dt.Rows[0]["DEP_NAME"].ToString().Trim(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('人员不存在,请重新输入!');", true); } } }
//导出 protected void btnexport_Click(object sender, EventArgs e) { string sqlldbx = "select DEP_NAME,ST_WORKNO,ST_NAME,LD_DATE,LD_JFJS,LD_GJJS,LD_YLBXD,LD_SYBXD,LD_GSBXD,LD_SYD,LD_YLD,LD_GJJD,LD_DWB,(isnull(LD_YLBXD,0)+isnull(LD_SYBXD,0)+isnull(LD_GSBXD,0)+isnull(LD_SYD,0)+isnull(LD_YLD,0)+isnull(LD_GJJD,0)+isnull(LD_DWB,0)) as LD_DWH,LD_YLGR,LD_SYGR,LD_JBYLGR,LD_YLDE,(isnull(LD_YLGR,0)+isnull(LD_SYGR,0)+isnull(LD_JBYLGR,0)+isnull(LD_YLDE,0)) as LD_BXGRH,LD_GJJGR,LD_GRBJ,(isnull(LD_YLGR,0)+isnull(LD_SYGR,0)+isnull(LD_JBYLGR,0)+isnull(LD_YLDE,0)+isnull(LD_GJJGR,0)+isnull(LD_GRBJ,0)) as LD_HJGR,LD_ZGFY,LD_BJLX,(isnull(LD_YLBXD,0)+isnull(LD_SYBXD,0)+isnull(LD_GSBXD,0)+isnull(LD_SYD,0)+isnull(LD_YLD,0)+isnull(LD_GJJD,0)+isnull(LD_DWB,0)+isnull(LD_YLGR,0)+isnull(LD_SYGR,0)+isnull(LD_JBYLGR,0)+isnull(LD_YLDE,0)+isnull(LD_GJJGR,0)+isnull(LD_GRBJ,0)+isnull(LD_ZGFY,0)) as LD_ZJGR from View_OM_LDBX where " + Creatconstr(); System.Data.DataTable dtldbx = DBCallCommon.GetDTUsingSqlText(sqlldbx); string filename = "派遣人员保险公积金导出.xls"; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename))); HttpContext.Current.Response.Clear(); using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("派遣人员保险公积金导出模板.xls"))) { IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象 ISheet sheet1 = wk.GetSheetAt(0); for (int i = 0; i < dtldbx.Rows.Count; i++) { IRow row = sheet1.CreateRow(i + 1); ICell cell0 = row.CreateCell(0); cell0.SetCellValue(i + 1); for (int j = 0; j < dtldbx.Columns.Count; j++) { string str = dtldbx.Rows[i][j].ToString(); row.CreateCell(j + 1).SetCellValue(str); } } for (int r = 0; r <= dtldbx.Columns.Count; r++) { sheet1.AutoSizeColumn(r); } sheet1.ForceFormulaRecalculation = true; MemoryStream file = new MemoryStream(); wk.Write(file); HttpContext.Current.Response.BinaryWrite(file.GetBuffer()); HttpContext.Current.Response.End(); } }
//执行存储过程,绑定数据 private void BindData() { this.PagerQueryParam(stc);//存储过程执行后直接将数据写入表TBFM_PRIDSTATISTICS string sqltext = "select ROW_NUMBER() OVER (ORDER BY PS_SCZH ASC) AS Row_Num, * from VIEW_TBFM_PRIDSTATISTICS order by PS_SCZH "; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { rptProductNumStc.DataSource = dt; rptProductNumStc.DataBind(); NoDataPanel.Visible = false; div_statistcs.Visible = true; btn_export.Visible = true; } else { rptProductNumStc.DataSource = null; rptProductNumStc.DataBind(); NoDataPanel.Visible = true; div_statistcs.Visible = false; btn_export.Visible = false; } //CheckUser(ControlFinder); }
/// <summary> /// 设置Label标签的值:如:数据源XXX条,可导入XXX条,不可导入XXX条 /// </summary> protected void SetLabelTip() { //数据源条数 string sql_find_sc = "select count(*) as Num from View_TM_DQO where BM_ENGID='" + ViewState["Sc_TaskID"] + "' AND (BM_ZONGXU='" + ViewState["Sc_XuHao"] + "' OR BM_ZONGXU LIKE '" + ViewState["Sc_XuHao"] + ".%')"; int src_numbers = Convert.ToInt32(DBCallCommon.GetDTUsingSqlText(sql_find_sc).Rows[0]["Num"].ToString()); lblSourceNumber.Text = src_numbers.ToString(); string sql_find_ok; if (ViewState["array"].ToString().Trim() != "") { sql_find_ok = "select count(*) as Num from View_TM_DQO as A where BM_ENGID='" + ViewState["Sc_TaskID"] + "' AND (BM_ZONGXU='" + ViewState["Sc_XuHao"] + "' OR BM_ZONGXU LIKE '" + ViewState["Sc_XuHao"] + ".%') and not exists(select A1.BM_ZONGXU from View_TM_DQO as A1 where A1.BM_ENGID = '" + ViewState["Tg_TaskID"].ToString() + "' AND (A1.BM_ZONGXU=STUFF(A.BM_ZONGXU,1,len('" + ViewState["Sc_XuHao"] + "'),'" + ViewState["Tg_XuHao"] + "'))) AND A.BM_XUHAO NOT IN(" + ViewState["array"].ToString() + ")"; } else { sql_find_ok = "select count(*) as Num from View_TM_DQO as A where BM_ENGID='" + ViewState["Sc_TaskID"] + "' AND (BM_ZONGXU='" + ViewState["Sc_XuHao"] + "' OR BM_ZONGXU LIKE '" + ViewState["Sc_XuHao"] + ".%') and not exists(select A1.BM_ZONGXU from View_TM_DQO as A1 where A1.BM_ENGID ='" + ViewState["Tg_TaskID"].ToString() + "' AND (A1.BM_ZONGXU=STUFF(A.BM_ZONGXU,1,len('" + ViewState["Sc_XuHao"] + "'),'" + ViewState["Tg_XuHao"] + "'))) "; } int src_canimpt_numbers = Convert.ToInt32(DBCallCommon.GetDTUsingSqlText(sql_find_ok).Rows[0]["Num"].ToString()); lblEnableImport.Text = src_canimpt_numbers.ToString(); //不导入项 int notimportin = 0; if (ViewState["array"].ToString().Trim() != "") { notimportin = ViewState["array"].ToString().Trim().Split(',').Length; } lblNotImport.Text = notimportin.ToString(); //不可导入条数 int tg_unable_numbers = src_numbers - src_canimpt_numbers - notimportin; lblUnableImport.Text = tg_unable_numbers.ToString(); }
Dictionary <string, string> reviewer = new Dictionary <string, string>();//用于存储审核部门负责人的名单 private void BindReviewer() { int count = 0; string sql = string.Format("select ST_NAME,ST_ID,ST_DEPID from TBDS_STAFFINFO as a inner join TBCM_HT_SETTING as b on a.ST_ID=b.per_id where a.ST_PD='0'and b.dep_id='{0}' and per_sfjy='0' and b.per_type='0'", "01"); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); int num = dt.Rows.Count; for (int i = 0; i < 5 + num; i++) { CheckBoxList ck = (CheckBoxList)Panel1.FindControl("cki" + i.ToString()); Label lb = (Label)Panel1.FindControl("dep" + i.ToString()); if (ck != null) { for (int j = 0; j < ck.Items.Count; j++) { if (ck.Items[j].Selected == true) { reviewer.Add(lb.Text, ck.Items[j].Value.ToString());//字典,绑定部门领导的编号 count++; } } } } }
//工程下拉框初始化 private void Initdropdownlist_project() { if (DropDownList_PJ.Items.Count != 0)//有项目 { string sqltext = "SELECT DISTINCT d.MP_ENGID AS PUR_ENGID,d.MP_ENGNAME AS PUR_ENGNAME " + "FROM (SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORBLJ " + "UNION ALL SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORDQJ " + "UNION ALL SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORDQO " + "UNION ALL SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORGFB " + "UNION ALL SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORHZY " + "UNION ALL SELECT MP_PID,MP_PJID,MP_ENGID,MP_ENGNAME FROM TBPM_MPFORQLM) AS d " + "WHERE (MP_PID IN (SELECT MP_ID AS MP_PID FROM TBPM_MPFORALLRVW WHERE (MP_STATE = '8')) AND MP_PJID='" + DropDownList_PJ.SelectedValue.ToString() + "') "; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0)//有工程数据需要汇总 { downlist_eng.DataSource = dt; downlist_eng.DataTextField = "PUR_ENGNAME"; downlist_eng.DataValueField = "PUR_ENGID"; downlist_eng.DataBind(); downlist_eng.Items[0].Selected = true; } } }
//对绑定已经勾选的评审人 private void BindSelectReviewer() { string st_id = psId;// 评审单号 string check_select = "select ST_PID from TBDS_PSVIEW where ST_ID='" + st_id + "' and ST_PIDTYPE!='0'"; DataTable sele = DBCallCommon.GetDTUsingSqlText(check_select); string sql = string.Format("select ST_NAME,ST_ID,ST_DEPID from TBDS_STAFFINFO as a inner join TBCM_HT_SETTING as b on a.ST_ID=b.per_id where a.ST_PD='0'and b.dep_id='{0}' and per_sfjy='0' and b.per_type='0'", "01"); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); int num = dt.Rows.Count; for (int i = 0; i < 5 + num; i++) { CheckBoxList ck = (CheckBoxList)Panel1.FindControl("cki" + i.ToString()); for (int j = 0; j < sele.Rows.Count; j++) { for (int k = 0; k < ck.Items.Count; k++) { if (ck.Items[k].Value == sele.Rows[j][0].ToString()) { ck.Items[k].Selected = true; } } } } }
protected void btnCreat_Click(object sender, EventArgs e) { if (ddl_Depart.SelectedValue == "00") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择部门!!!');", true); return; } if (dplYear.SelectedIndex == 0 || dplMoth.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择年月!!!');", true); return; } string year = dplYear.SelectedValue; string month = dplMoth.SelectedValue; string sql = "select * from View_TBDS_KaoheDepartMonth where DepMonth_Year='" + year + "' and DepMonth_Month='" + month + "' and State='2'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('未找到当月部门绩效考核数据!!!');", true); return; } CaculateBzAverage(); List <string> list = new List <string>(); sql = "delete a from TBDS_KaoHe_JXGZ as a left join TBDS_STAFFINFO as b on a.StId=b.ST_ID where b.ST_DEPID='" + ddl_Depart.SelectedValue + "' and Year='" + year + "' and Month='" + month + "'"; list.Add(sql); sql = "insert into TBDS_KaoHe_JXGZ select '0','',DepMonth_Year,DepMonth_Month,ST_ID from dbo.TBDS_KaoHeTotal as a left join TBDS_STAFFINFO as b on a.Kh_ID=b.ST_ID inner join View_TBDS_KaoheDepartMonth as c on b.ST_DEPID=c.DepartId and a.Kh_Year=c.DepMonth_Year and a.Kh_Month=c.DepMonth_Month where b.ST_DEPID='" + ddl_Depart.SelectedValue + "'"; list.Add(sql); DBCallCommon.ExecuteTrans(list); CalculateSalary(); bindGrid(); }
private void ChangeTextAndBackColor(GridViewRowEventArgs e, string sqlText, int i) { DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText); string techPrepare = CheckState(dt); if (techPrepare.Contains("6")) { e.Row.Cells[i].Text = "已超期"; e.Row.Cells[i].BackColor = Color.OrangeRed; } else if (techPrepare.Contains("5")) { e.Row.Cells[i].Text = "预警中"; e.Row.Cells[i].BackColor = Color.Yellow; } else if (techPrepare.Contains("4")) { e.Row.Cells[i].Text = "进行中"; e.Row.Cells[i].BackColor = Color.LawnGreen; } else if (techPrepare.Contains("3")) { e.Row.Cells[i].Text = "未开始"; e.Row.Cells[i].BackColor = Color.LawnGreen; } else if (techPrepare.Contains("2")) { e.Row.Cells[i].Text = "超期完成"; e.Row.Cells[i].BackColor = Color.OrangeRed; } else if (techPrepare.Contains("1")) { e.Row.Cells[i].Text = "顺利完成"; e.Row.Cells[i].BackColor = Color.LawnGreen; } }
/****************************对绑定已经勾选的评审人*************************************/ private void bindSelectReviewer() { string cr_id = LBpsdh.Text;// 评审单号 string sql_psbm = "select distinct dep_id,b.dep_name from TBCM_HT_SETTING as a left join TBDS_DEPINFO as b on a.dep_id=b.DEP_CODE"; DataTable dt_psbm = DBCallCommon.GetDTUsingSqlText(sql_psbm); for (int i = 0; i < dt_psbm.Rows.Count; i++) { CheckBoxList ck = (CheckBoxList)Panel1.FindControl("cki" + i.ToString()); if (ck != null) { for (int j = 0; j < ck.Items.Count; j++) { string check_select = "select * from TBCR_CONTRACTREVIEW_DETAIL where" + " CRD_ID='" + cr_id + "' and CRD_PID='" + ck.Items[j].Value + "' and CRD_DEP!='01'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(check_select); if (dt.Rows.Count > 0) { ck.Items[j].Selected = true; } } } } }
protected void fhclose()//行反关闭 { int i = 0; string sqltext = ""; foreach (RepeaterItem Reitem in PurorderdetailRepeater.Items) { CheckBox cbx = Reitem.FindControl("CKBOX_SELECT") as CheckBox; //定义checkbox if (cbx != null) //存在行 { if (cbx.Checked) { i++; sqltext = "update TBPC_PURORDERDETAIL set PO_CSTATE='0' WHERE PO_SHEETNO='" + gloabsheetno + "' " + "and PO_PCODE='" + ((Label)Reitem.FindControl("PO_PCODE")).Text.ToString() + "'"; DBCallCommon.ExeSqlText(sqltext); } } } if (i > 0) { sqltext = "SELECT PO_ID FROM TBPC_PURORDERDETAIL WHERE PO_SHEETNO='" + gloabsheetno + "' and PO_CSTATE='0'";//是否还存在未关闭的,如果都存则整单未关闭 DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { sqltext = "update TBPC_PURORDERTOTAL set PO_CSTATE='0' WHERE PO_CODE='" + gloabsheetno + "'";//单号反关闭 DBCallCommon.ExeSqlText(sqltext); } PurorderdetailRepeaterbind(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('操作成功!');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('未选择数据!');", true); } }
private void Control_Enable() { string sql = "select * from TBCM_ChANLIST where CH_ID='" + chId + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; int n = int.Parse(dr["CM_PSJB"].ToString()); for (int i = 0; i < n; i++) { Panel pal = new Panel(); pal = (Panel)TabContainer1.FindControl("Pan_ShenHe").FindControl("Panel" + i.ToString()); TextBox tbyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i.ToString()); Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i.ToString()); HiddenField hd = (HiddenField)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shrid" + i.ToString()); if (UserID.Value == hd.Value && tbyj.Text == "") { pal.Enabled = true; tbyj.BorderColor = System.Drawing.Color.Orange; tbyj.Focus(); LbtnYes.Visible = true; LbtnNO.Visible = true; if (action == "look") { pal.Enabled = false; } } else { pal.Enabled = false; } } } }
/// 合同发票记录绑定 private void BindBillData(string contractid) { string sqlstr = "select * from TBPM_GATHINVDOC where GIV_HTBH='" + contractid + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlstr); if (dt.Rows.Count > 0) { grvFP.DataSource = dt; grvFP.DataBind(); NoDataPanelFPJL.Visible = false; } else { grvFP.DataSource = null; grvFP.DataBind(); NoDataPanelFPJL.Visible = true; } if (action != "Edit") { grvFP.Columns[grvFP.Columns.Count - 3].Visible = false; grvFP.Columns[grvFP.Columns.Count - 1].Visible = false; } }