//获取制作明细数据
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;
}
}
