protected void Showdata()
{
string st_id = Request.QueryString["ST_ID"].ToString();//得到修改人员编码
string sqlText = "select distinct a.*,b.DEP_NAME,d.DEP_NAME as DEP_POSITION,e.ST_NAME as MANCLERK from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on a.ST_POSITION = d.DEP_CODE left join TBDS_STAFFINFO as e on a.ST_MANCLERK=e.ST_ID where a.ST_ID='" + st_id + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
DataRow dr = dt.Rows[0];
foreach (Control lable in Panel1.Controls)
{
if (lable is Label)
{
((Label)lable).Text = dr[((Label)lable).ID.ToString()].ToString();
}
}
sqlText = "select * from TBDS_WORKHIS where ST_ID='" + st_id + "'";
Det_Repeater.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater.DataBind();
sqlText = "select * from TBDS_EDUCA where ST_ID='" + st_id + "'";
Det_Repeater1.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater1.DataBind();
sqlText = "select * from TBDS_RELATION where ST_ID='" + st_id + "'";
Det_Repeater2.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater2.DataBind();
InitVar();
InitVar1();
InitVar2();
}
//绑定数据
private void binddata()
{
context = Request.QueryString["context"].ToString().Trim();
string sqltext0 = "select * from TBTM_GONGSBASE where context='" + context + "'";
DataTable dt0 = DBCallCommon.GetDTUsingSqlText(sqltext0);
if (dt0.Rows.Count > 0)
{
lbzdper.Text = dt0.Rows[0]["zdrname"].ToString().Trim();
lbzdperid.Text = dt0.Rows[0]["zdrid"].ToString().Trim();
lbzdtime.Text = dt0.Rows[0]["zdtime"].ToString().Trim();
rad_state.SelectedValue = dt0.Rows[0]["state"].ToString().Trim();
txtcpname.Text = dt0.Rows[0]["cpname"].ToString().Trim();
txtcpguige.Text = dt0.Rows[0]["cpguige"].ToString().Trim();
txtzongmap.Text = dt0.Rows[0]["zongmap"].ToString().Trim();
txtbjname.Text = dt0.Rows[0]["bjname"].ToString().Trim();
txtbjmap.Text = dt0.Rows[0]["bjmap"].ToString().Trim();
txtbjpergs.Text = dt0.Rows[0]["bjpergs"].ToString().Trim();
txtcontext.Text = dt0.Rows[0]["context"].ToString().Trim();
txtnote.Text = dt0.Rows[0]["notetotal"].ToString().Trim();
}
string sqltext1 = "select * from TBTM_GONGSBASEDETAIL where detailcontext='" + context + "' order by ljmap,mxid";
DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sqltext1);
if (dt1.Rows.Count > 0)
{
Det_Repeater.DataSource = dt1;
Det_Repeater.DataBind();
}
}
private void BindData()
{
string sql = "select a.*,b.ST_NAME as name1,d.ST_NAME as name2,e.ST_NAME as name3 from TBCM_FHNOTICE as a left join TBDS_STAFFINFO as b on a.CM_MANCLERK=b.ST_ID left join TBDS_STAFFINFO as d on a.CM_BMZG=d.ST_ID left join TBDS_STAFFINFO as e on a.CM_GSLD=e.ST_ID where CM_FID='" + id + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
CM_BIANHAO.Text = dr["CM_BIANHAO"].ToString();
hid_BianHao.Value = dr["CM_BIANHAO"].ToString();
CM_CUSNAME.Text = dr["CM_CUSNAME"].ToString();
CM_SH.Text = dr["CM_SH"].ToString();
CM_JH.Text = dr["CM_JH"].ToString();
CM_LXR.Text = dr["CM_LXR"].ToString();
CM_LXFS.Text = dr["CM_LXFS"].ToString();
CM_JHTIME.Text = dr["CM_JHTIME"].ToString();
CM_BEIZHU.Text = dr["CM_BEIZHU"].ToString();
CM_MANCLERK.Text = dr["name1"].ToString();
CM_ZDTIME.Text = dr["CM_ZDTIME"].ToString();
//Hidden.Value = dr["CM_ATTACH"].ToString();
//HidCSR.Value = dr["CM_CSR"].ToString();
ZG.Text = "李立恒";
}
string sql1 = "select a.*,(case when b.CM_YFSM is null then '0' else CM_YFSM end) as TSA_YFSM from View_CM_FaHuo as a left join (select sum(CM_FHNUM) as CM_YFSM,CM_ID from VIEW_CM_FaHuo where CM_CONFIRM!=3 group by CM_ID) as b on a.CM_ID=b.CM_ID where CM_FID='" + id + "'";
dt = DBCallCommon.GetDTUsingSqlText(sql1);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (!FileUpload.HasFile)
{
Response.Write("<script>alert('尚未上传Excel表格')</script>");
return;
}
if (System.IO.Path.GetExtension(FileUpload.FileName).ToString().ToLower() != ".xls")
{
Response.Write("<script>alert('只可以选择Excel（.xls）文件')</script>");
return;
}
try
{
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + FileUpload.FileName;
string savePath = @"E:/薪酬异动" + filename;//TOCHANGE
FileUpload.SaveAs(savePath);
ExcelHelper EH = new ExcelHelper(savePath);
DataTable ImportDate = EH.ExportExcelToDataTable();
if (EH.IsError(ImportDate, "补发加班费") || EH.IsError(ImportDate, "补发中夜班费") || EH.IsError(ImportDate, "调整补发") || EH.IsError(ImportDate, "调整补扣"))
{
Response.Write("<script>alert('Excel数据有误！请检查标记为ERROR的单元格。')</script>");
}
Det_Repeater.DataSource = GetImportDate(ImportDate);
Det_Repeater.DataBind();
}
catch (Exception ex)
{
Response.Write("<script>alert('导入出错！请检查导入文件格式！" + ex.Message + "')</script>");
return;
}
}
protected void btnImprot_Click(object sender, EventArgs e)
{
if (!FileUpload.HasFile)
{
Response.Write("<script>alert('尚未上传Excel表格')</script>");
return;
}
//System.IO.Path.GetExtension获得文件的扩展名
if (System.IO.Path.GetExtension(FileUpload.FileName).ToString().ToLower() != ".xls")
{
Response.Write("<script>alert('只可以选择Excel文件')</script>");
return;//当选择的不是Excel文件时,返回
}
try
{
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + FileUpload.FileName; //获取Execle文件名 DateTime日期函数
string savePath = @"E:/餐补异动" + filename; //Server.MapPath 获得虚拟服务器相对路径
FileUpload.SaveAs(savePath);
ExcelHelper EH = new ExcelHelper(savePath);
DataTable ImportDate = EH.ExportExcelToDataTable();
if (EH.IsError(ImportDate, "调整天数") || EH.IsError(ImportDate, "餐补标准") || EH.IsError(ImportDate, "补发"))
{
Response.Write("<script>alert('Excel数据有误！请检查标记为ERROR的单元格。')</script>");
}
Det_Repeater.DataSource = GetImprotData(ImportDate);
Det_Repeater.DataBind();
}
catch (System.Exception ex)
{
Response.Write("<script>alert('导入出错！请检查导入文件格式！" + ex.Message + "')</script>");
return;
}
}
private void ShowData()
{
string sql = "select * from TBDS_KaoheDeaprtMonth_Detail where Context='" + key + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
private void ShowData()
{
string sql = "select * from OM_COMPUTERDETAIL where Context='" + key + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
private void ShowData(string showContext)
{
string sql = " select * from TBDS_KaoHe_JXDetail as a left join dbo.TBDS_KaoHeTotal as b on a.ST_ID=b.kh_Id and a.JxYear=b.kh_year and a.JxMonth=b.kh_month where Context='" + showContext + "' order by GangWeiXiShu desc ";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
private void Showdata() //将数据绑定到textbox
{
string sqlText = "select * from TBOM_DriverInfo where Context='" + hidContext.Value + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
private void Showdata() //将数据绑定到textbox
{
string st_id = Request.QueryString["ST_ID"].ToString(); //得到修改人员编码
string data = Request.QueryString["ST_DATATIME"].ToString(); //得到修改人员编码
string sqlText = "select * from View_TBDS_STAFFINFO_record where ST_ID='" + st_id + "' and ST_DATATIME='" + data + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
DataRow dr = dt.Rows[0];
foreach (Control control in Panel1.Controls)
{
if (control is TextBox)
{
((TextBox)control).Text = dr[((TextBox)control).ID.ToString()].ToString();
}
else if (control is DropDownList)
{
DEP_NAME.ID = "ST_DEPID";
((DropDownList)control).SelectedValue = dr[((DropDownList)control).ID.ToString()].ToString();
DEP_NAME.ID = "DEP_NAME";
}
}
string role = dr["R_NAME"].ToString();
if (!string.IsNullOrEmpty(role))
{
string[] roles = role.Split(',');
string uRole = "";
for (int i = 0; i < roles.Length; i++)
{
uRole = roles[i].Substring(1, roles[i].Length - 2);
for (int j = 0; j < chk_Role.Items.Count; j++)
{
if (uRole == chk_Role.Items[j].Text)
{
chk_Role.Items[j].Selected = true;
}
}
}
}
Ddl_Post();
DEP_POSITION.SelectedValue = dr["ST_POSITION"].ToString();
showImage.ImageUrl = "~/staff_images/" + dr["JPGURL"].ToString();
sqlText = "select * from TBDS_WORKHIS where ST_ID='" + st_id + "'";
Det_Repeater.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater.DataBind();
sqlText = "select * from TBDS_EDUCA where ST_ID='" + st_id + "'";
Det_Repeater1.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater1.DataBind();
sqlText = "select * from TBDS_RELATION where ST_ID='" + st_id + "'";
Det_Repeater2.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater2.DataBind();
InitVar();
InitVar1();
InitVar2();
}
private void ShowData()
{
string sql = "select a.kh_Dep,a.kh_Type,b.DEP_NAME as Dep,c.DEP_NAME as Position,a.kh_Name,a.kh_BL from TBDS_KaoHeMBList as a left join TBDS_DEPINFO as b on a.kh_Dep=b.DEP_CODE left join TBDS_DEPINFO as c on a.kh_Type=c.DEP_CODE where kh_Fkey='" + key + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
DataRow dr = dt.Rows[0];
//ddl_Depart.Items.Add(new ListItem(dr["Dep"].ToString(), dr["kh_Dep"].ToString()));
//ddl_Depart.Enabled = false;
ddl_Depart.SelectedValue = dr["kh_Dep"].ToString().Trim();
delete.Visible = true;
sql = "select a.kh_Dep,a.kh_Type,a.kh_Type1,b.DEP_NAME as Dep,c.DEP_NAME as Position,a.kh_Name,a.kh_BL,a.kh_Note from TBDS_KaoHeMBList as a left join TBDS_DEPINFO as b on a.kh_Dep=b.DEP_CODE left join TBDS_DEPINFO as c on a.kh_Type=c.DEP_CODE where kh_Fkey='" + key + "'";
dt = DBCallCommon.GetDTUsingSqlText(sql);
dr = dt.Rows[0];
txtName.Text = dr["kh_Name"].ToString();
string[] bl = dr["kh_BL"].ToString().Split('|');
txtBl1.Text = bl[0];
txtBl2.Text = bl[1];
txtBl3.Text = bl[2];
txtBl4.Text = bl[3];
ddlType.SelectedValue = dr["kh_Type1"].ToString();
txtPFBZ.Text = dr["kh_Note"].ToString();
// btnedit.Visible = true;
//btnadd.Visible = false;
//delete.Visible = false;
sql = "select * from TBDS_KaoHeMuB where kh_Fkey='" + key + "'";
dt = DBCallCommon.GetDTUsingSqlText(sql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
for (int i = 0; i < Det_Repeater.Items.Count; i++)
{
for (int j = 1; j < 6; j++)
{
ITextControl ctrl = ((ITextControl)Det_Repeater.Items[i].FindControl("txt" + j));
ctrl.Text = ctrl.Text.Replace("<br />", "");
}
}
NoDataPanel.Visible = false;
sql = "select * from TBDS_KaoHeCol where kh_Fkey='" + key + "'";
dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
for (int i = 1; i < 6; i++)
{
((ITextControl)Det_Repeater.Controls[0].FindControl("kh_Col" + i)).Text = dt.Rows[0]["kh_Col" + i].ToString();
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('数据有误，请联系管理员！');", true);
}
}
private void Showdata() //将数据绑定到textbox
{
string carnum1 = "";
string sqltext = "select * from TBOM_CARINFO where ID = '" + id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
if (dr.Read())
{
carnum1 = dr["CARNUM"].ToString();
}
dr.Close();
string sqlText = "select CARNUM,BXNAME,STARTDATE,ENDDATE,NOTE,BXJE from TBOM_CARBX where CARNUM='" + carnum1 + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
}
private void binddata()
{
bh = Request.QueryString["gs_bh"].ToString().Trim();
string sql0 = "select * from TBTM_GSMANAGEMENT where gs_bh='" + bh + "'";
DataTable dt0 = DBCallCommon.GetDTUsingSqlText(sql0);
if (dt0.Rows.Count > 0)
{
lbzdrname.Text = dt0.Rows[0]["gs_zdrname"].ToString().Trim();
lbzdrid.Text = dt0.Rows[0]["gs_zdrid"].ToString().Trim();
lbzdtime.Text = dt0.Rows[0]["gs_zdtime"].ToString().Trim();
rad_state.SelectedValue = dt0.Rows[0]["gs_state"].ToString().Trim();
lbdjbh.Text = dt0.Rows[0]["gs_bh"].ToString().Trim();
txtjcbh.Text = dt0.Rows[0]["gs_jcbh"].ToString().Trim();
txtjctype.Text = dt0.Rows[0]["gs_jctype"].ToString().Trim();
yearmonth.Value = dt0.Rows[0]["gs_yearmonth"].ToString().Trim();
txtcpname.Text = dt0.Rows[0]["gs_cpname"].ToString().Trim();
txtcpguige.Text = dt0.Rows[0]["gs_cpguige"].ToString().Trim();
txtzongmap.Text = dt0.Rows[0]["gs_zongmap"].ToString().Trim();
txtbjname.Text = dt0.Rows[0]["gs_bjname"].ToString().Trim();
txtbjmap.Text = dt0.Rows[0]["gs_bjth"].ToString().Trim();
txtbjpergs.Text = dt0.Rows[0]["gs_bjpergs"].ToString().Trim();
txtbjnum.Text = dt0.Rows[0]["gs_bjnum"].ToString().Trim();
txtbjtolgs.Text = dt0.Rows[0]["gs_bjtotalgs"].ToString().Trim();
txtrealbjpergs.Text = dt0.Rows[0]["gs_realbjpergs"].ToString().Trim();
txtrealbjnum.Text = dt0.Rows[0]["gs_realbjnum"].ToString().Trim();
txtrealbjtotalgs.Text = dt0.Rows[0]["gs_realbjtotalgs"].ToString().Trim();
jsrname.Text = dt0.Rows[0]["gs_jsrname"].ToString().Trim();
jsrid.Text = dt0.Rows[0]["gs_jsrid"].ToString().Trim();
lbjstime.Text = dt0.Rows[0]["gs_jstime"].ToString().Trim();
txtperinfo.Text = dt0.Rows[0]["gs_perinfo"].ToString().Trim();
txtnote.Text = dt0.Rows[0]["gs_note"].ToString().Trim();
}
string sql1 = "select * from TBTM_GSDETAIL where gs_detailbh='" + bh + "'";
DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql1);
if (dt1.Rows.Count > 0)
{
Det_Repeater.DataSource = dt1;
Det_Repeater.DataBind();
}
}
private void downloadMB()
{
string sql = "";
if (action == "add")
{
sql = "select *,'' as kh_Note,'' as kh_Score1,'' as kh_Score2,'' as kh_Score3,'' as kh_Score4,'' as kh_ScoreOwn,'' as Id from View_KaoHe where kh_Fkey='" + ddlKaohMB.SelectedValue + "' and kh_State='0' order by kh_Id asc";
}
else
{
sql = "select *,'' as kh_Note,'' as kh_Score1,'' as kh_Score2,'' as kh_Score3,'' as kh_Score4,'' as kh_ScoreOwn,'' as Id from View_KaoHe where kh_Fkey='" + ddlKaohMB.SelectedValue + "' order by kh_Id asc";
}
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
sql = "select * from TBDS_KaoHeCol where kh_Fkey='" + dt.Rows[0]["kh_Fkey"] + "'";
DataTable col = DBCallCommon.GetDTUsingSqlText(sql);
if (col.Rows.Count > 0)
{
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
//绑定列名
List <int> cols = new List <int>();
for (int i = 1; i < 13; i++)
{
Label lb = (Label)Det_Repeater.Controls[0].FindControl("kh_Col" + i);
string str = col.Rows[0]["kh_Col" + i].ToString();
lb.Text = str;
if (str == "")
{
cols.Add(i);
Control head = Det_Repeater.Controls[0];
HtmlTableCell htc = (HtmlTableCell)head.FindControl("col" + i);
htc.Visible = false;
}
}
foreach (RepeaterItem item in Det_Repeater.Items)
{
for (int i = 0; i < cols.Count; i++)
{
HtmlTableCell cont = (HtmlTableCell)item.FindControl("td" + cols[i]);
cont.Visible = false;
}
//for (int i = 1; i < 13 - cols.Count; i++)
//{
// HtmlTableCell hcont = (HtmlTableCell)item.FindControl("td" + i);
// hcont.InnerText.Replace("\r\n", "<br />");
// hcont.InnerText.Replace("\n", "<br />");
// if (!hcont.InnerText.Contains("<br />"))
// {
// hcont.Style.Add("text-align", "center");
// }
//}
}
sql = "select * from TBDS_KaoHeMBList where kh_Fkey='" + ddlKaohMB.SelectedValue + "'";
DataTable bl = DBCallCommon.GetDTUsingSqlText(sql);
if (bl.Rows.Count > 0)
{
string txtbl = bl.Rows[0]["Kh_BL"].ToString();
txtPFBZ.Text = bl.Rows[0]["Kh_Note"].ToString();
lblBL.Text = txtbl;
foreach (RepeaterItem item in Det_Repeater.Items)
{
for (int i = 0; i < txtbl.Split('|').Count(); i++)
{
if (txtbl.Split('|')[i] == "0")
{
TextBox box = (TextBox)item.FindControl("kh_Score" + i);
box.Visible = false;
}
}
}
Panel1.Visible = true;
Panel2.Visible = true;
Panel3.Visible = true;
if (txtbl.Split('|')[0] == "0")
{
txtResult1.Visible = false;
Panel1.Visible = false;
}
if (txtbl.Split('|')[1] == "0")
{
txtResult2.Visible = false;
Panel2.Visible = false;
}
if (txtbl.Split('|')[2] == "0")
{
txtResult3.Visible = false;
Panel3.Visible = false;
}
if (txtbl.Split('|')[3] == "0")
{
txtResult4.Visible = false;
Panel5.Visible = false;
}
if (ddlFankui.SelectedValue == "1")
{
Panel4.Visible = false;
}
}
foot.ColSpan = 13 - cols.Count;
sql = "select sum(kh_Weight) from TBDS_KaoHeDetail where kh_Context='" + ddlKaohMB.SelectedValue + "'";
lb_Result.Text = DBCallCommon.GetDTUsingSqlText(sql).Rows[0][0].ToString();
tr_foot.Visible = true;
Det_Repeater.Visible = true;
NoDataPanel.Visible = false;
}
else
{
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('考核模板列名出错！请重新添加模板或者联系管理员');", true);
Response.Write("<script>alert('考核模板列名出错！请重新添加模板或者联系管理员！');</script>");
Det_Repeater.Visible = false;
NoDataPanel.Visible = true;
}
}
else
{
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('未成功加载考核模板！请添加模板或者联系管理员');", true);
Response.Write("<script>alert('未成功加载考核模板！请添加模板或者联系管理员！');</script>");
Det_Repeater.Visible = false;
NoDataPanel.Visible = true;
}
}
private void BindKh()
{
string sql = "select * from TBDS_KaoHeDetail where kh_Context='" + hidConext.Value + "' order by kh_Id asc";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
sql = "select * from TBDS_KaoHeColReal where kh_context='" + dt.Rows[0]["kh_Context"] + "'";
DataTable col = DBCallCommon.GetDTUsingSqlText(sql);
if (col.Rows.Count > 0)
{
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
//绑定列名
List <int> cols = new List <int>();
for (int i = 1; i < 13; i++)
{
Label lb = (Label)Det_Repeater.Controls[0].FindControl("kh_Col" + i);
string str = col.Rows[0]["kh_Col" + i].ToString();
lb.Text = str;
if (str == "")
{
cols.Add(i);
Control head = Det_Repeater.Controls[0];
HtmlTableCell htc = (HtmlTableCell)head.FindControl("col" + i);
htc.Visible = false;
}
}
foreach (RepeaterItem item in Det_Repeater.Items)
{
for (int i = 0; i < cols.Count; i++)
{
HtmlTableCell cont = (HtmlTableCell)item.FindControl("td" + cols[i]);
cont.Visible = false;
}
for (int i = 1; i < 13 - cols.Count; i++)
{
HtmlTableCell hcont = (HtmlTableCell)item.FindControl("td" + i);
if (!hcont.InnerText.Contains("<br />"))
{
hcont.Style.Add("text-align", "center");
}
}
}
sql = "select * from TBDS_KaoHeList where kh_context='" + hidConext.Value + "'";
DataTable bl = DBCallCommon.GetDTUsingSqlText(sql);
if (bl.Rows.Count > 0)
{
string txtbl = bl.Rows[0]["Kh_BL"].ToString();
lblBL.Text = txtbl;
ddl_zipstate.SelectedValue = bl.Rows[0]["Kh_zipingif"].ToString().Trim();
foreach (RepeaterItem item in Det_Repeater.Items)
{
for (int i = 0; i < txtbl.Split('|').Count(); i++)
{
if (txtbl.Split('|')[i] == "0")
{
TextBox box = (TextBox)item.FindControl("kh_Score" + i);
box.Visible = false;
}
}
}
if (txtbl.Split('|')[0] == "0")
{
Panel1.Visible = false;
txtResult1.Visible = false;
}
if (txtbl.Split('|')[1] == "0")
{
txtResult2.Visible = false;
Panel2.Visible = false;
}
if (txtbl.Split('|')[2] == "0")
{
txtResult3.Visible = false;
Panel3.Visible = false;
}
if (txtbl.Split('|')[3] == "0")
{
txtResult4.Visible = false;
Panel5.Visible = false;
}
}
foot.ColSpan = 13 - cols.Count;
sql = "select sum(kh_Weight) from TBDS_KaoHeDetail where kh_context='" + hidConext.Value + "'";
lb_Result.Text = DBCallCommon.GetDTUsingSqlText(sql).Rows[0][0].ToString();
tr_foot.Visible = true;
Det_Repeater.Visible = true;
NoDataPanel.Visible = false;
}
else
{
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('考核模板列名出错！请重新添加模板或者联系管理员');", true);
Response.Write("<script>alert('考核模板列名出错！请重新添加模板或者联系管理员！');</script>");
Det_Repeater.Visible = false;
NoDataPanel.Visible = true;
}
}
else
{
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('未成功加载考核模板！请添加模板或者联系管理员');", true);
Response.Write("<script>alert('未成功加载考核模板！请添加模板或者联系管理员！');</script>");
Det_Repeater.Visible = false;
NoDataPanel.Visible = true;
}
}
protected void btn_Click(object sender, EventArgs e)
{
Det_Repeater.DataSource = null;
Det_Repeater.DataBind();
downloadMB();
}
/// <summary>
/// 新建请款单时，根据合同编号绑定某些数据
/// </summary>
/// <param name="htbh"></param>
private void BindDataUseHTBH(string htbh)
{
string strsql = "select A.* ,B.CS_Bank,B.CS_Account from TBPM_CONPCHSINFO AS A LEFT OUTER JOIN TBCS_CUSUPINFO AS B" +
" ON A.PCON_CUSTMID=B.CS_CODE WHERE A.PCON_BCODE='" + htbh + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(strsql);
if (dr.HasRows)
{
dr.Read();
//合同编号
//txtHTBH.Text = dr["PCON_BCODE"].ToString();
//txtHTBH.Enabled = false;
//合同名称
//txtHTMC.Text = dr["PCON_NAME"].ToString();
//txtHTMC.Enabled = false;
//合同总价:结算金额为空或者0时以合同金额为准，有结算金额时用结算金额
string jsje = dr["PCON_BALANCEACNT"].ToString();
if (jsje == "" || Convert.ToDecimal(jsje) == 0)
{
//txtHTZJ.Text = dr["PCON_JINE"].ToString();
}
else
{
//txtHTZJ.Text = dr["PCON_BALANCEACNT"].ToString();
}
//承包供应商
txtCBGYS.Text = dr["PCON_CUSTMNAME"].ToString();
//开户银行
txtKFYH.Text = dr["CS_Bank"].ToString();
//账号
txtZH.Text = dr["CS_Account"].ToString();
dr.Close();
}
string id = string.Empty;
if (Request.QueryString["val"] != null)
{
string[] strs = Request.QueryString["val"].Split('/');
for (int i = 0; i < strs.Length; i++)
{
id += "'" + strs[i] + "',";
}
id = id.Substring(0, id.Length - 1);
}
DataTable dt = new DataTable();
if (contactform == "3")
{
strsql = "select b.ID,b.CM_CONTR,a.PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,b.CG_CONTR as CONTR,b.CM_MATERIAL,b.CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,NULL as CM_NOW,0.00 as CM_APPLI from TBPM_CONPCHSINFO as a right join TBPM_CGDETAIL as b on a.PCON_BCODE=b.CG_CONTR left join (select ID, sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID like '" + condetail_id + "%' group by ID) as c on convert(nvarchar(20),b.ID)=C.ID where b.ID in(" + id + ")";
}
else if (contactform == "1")
{
strsql = "select b.ID,b.CM_CONTR,d.CM_PROJ as PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,b.SC_CONTR as CONTR,b.CM_CONTENT as CM_MATERIAL,b.CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,NULL as CM_NOW,0.00 as CM_APPLI from TBPM_CONPCHSINFO as a right join TBPM_SCDETAIL as b on a.PCON_BCODE=b.SC_CONTR left join (select ID, sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID like '" + condetail_id + "%' group by ID) as c on convert(nvarchar(20),b.ID)=C.ID left join TBCM_PLAN as d on b.CM_CONTR=d.CM_CONTR where b.ID in(" + id + ")";
}
else
{
strsql = "select b.ID,a.PCON_BCODE as CM_CONTR,a.PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,NULL as CONTR,NULL as CM_MATERIAL,a.PCON_JINE as CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,NULL as CM_NOW,0.00 as CM_APPLI from TBPM_CONPCHSINFO as a left join (select ID, sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID like '" + condetail_id + "%' group by ID) as b on a.PCON_BCODE=b.ID where a.PCON_BCODE='" + condetail_id + "'";
}
dt = DBCallCommon.GetDTUsingSqlText(strsql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
//strsql = "select sum(CR_BQYFK) as hjsum from TBPM_CHECKREQUEST where cr_id like '" + txtHTBH.Text.ToString() + "%' ";
//dt = DBCallCommon.GetDTUsingSqlText(strsql);
//if (dt.Rows.Count > 0)
//{
// //已付款=合同请款金额
// //txtYFK.Text = dt.Rows[0]["hjsum"].ToString();
//}
}
/// <summary>
/// 根据请款单号绑定数据
/// </summary>
private void BindDataEdit(string crid)
{
string sqlstr = "select * from TBPM_CHECKREQUEST as a inner join TBPM_CONPCHSINFO as b on a.CR_HTBH=b.PCON_BCODE AND A.CR_ID='" + crid + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlstr);
if (dr.HasRows)
{
dr.Read();
//合同编号
//txtHTBH.Text = dr["PCON_BCODE"].ToString();
//合同名称
//txtHTMC.Text = dr["PCON_NAME"].ToString();
//合同总价
string jsje = dr["PCON_BALANCEACNT"].ToString();
if (jsje == "" || Convert.ToDecimal(jsje) == 0)
{
//txtHTZJ.Text = dr["PCON_JINE"].ToString();
}
else
{
//txtHTZJ.Text = dr["PCON_BALANCEACNT"].ToString();
}
//承包供应商
txtCBGYS.Text = dr["PCON_CUSTMNAME"].ToString();
//开户银行
txtKFYH.Text = dr["CR_DEPOSITBANK"].ToString();
//账号
txtZH.Text = dr["CR_BANKACUNUM"].ToString();
//已付款
//txtYFK.Text = dr["CR_YFK"].ToString();
//请款单号0
lblCR_ID.Text = dr["CR_ID"].ToString();
//请款部门1
dplQKBM.ClearSelection();
foreach (ListItem li in dplQKBM.Items)
{
if (li.Value.ToString() == dr["CR_QKBM"].ToString())
{
li.Selected = true; break;
}
}
//请款用途2
//txtQKYT.Text = dr["CR_USE"].ToString();
//请款日期4
txtQKRQ.Text = Convert.ToDateTime(dr["CR_DATE"].ToString()).ToShortDateString();
//支付方式5
foreach (ListItem li in rblZFFS.Items)
{
if (dr["CR_ZFFS"].ToString() == li.Text)
{
li.Selected = true; break;
}
}
//票证号6
txtPZH.Text = dr["CR_PZH"].ToString();
//主管领导17
txtZGLG.Text = dr["CR_ZGLD"].ToString();
//部门负责人18
txtBMFZR.Text = dr["CR_BMFZR"].ToString();
//验收人19
txtYSR.Text = dr["CR_YSR"].ToString();
//领导20
txtLD.Text = dr["CR_LD"].ToString();
//财务审核21
txtCWSH.Text = dr["CR_CWSH"].ToString();
//经办人22
txtJBR.Text = dr["CR_JBR"].ToString();
//请款状态23
if (action == "View")
{
rblState.Items.Clear();
rblState.Items.Add(new ListItem("保存", "0"));
rblState.Items.Add(new ListItem("正在签字", "1"));
rblState.Items.Add(new ListItem("提交财务-未付款", "2"));
rblState.Items.Add(new ListItem("提交财务-部分支付", "3"));
rblState.Items.Add(new ListItem("提交财务-已付款", "4"));
}
if (action == "EditCW")
{
rblState.Items.Clear();
rblState.Items.Add(new ListItem("正在签字", "1"));
rblState.Items.Add(new ListItem("提交财务-未付款", "2"));
}
//在Edit状态下，如果状态为正在签字，无法修改状态
if (action == "Edit" && dr["CR_STATE"].ToString() == "1")
{
rblState.Enabled = false;
}
foreach (ListItem li in rblState.Items)
{
if (dr["CR_STATE"].ToString() == li.Value.ToString())
{
li.Selected = true; break;
}
}
CR_BQSFK.Text = dr["CR_BQSFK"].ToString();
bqsfk.Value = dr["CR_BQSFK"].ToString();
CR_BQSFKDX.Text = dr["CR_BQSFKDX"].ToString();
bqsfkdx.Value = dr["CR_BQSFKDX"].ToString();
//请款合同类别24
dr.Close();
//************************************
//double yfk = Convert.ToDouble(txtYFK.Text);//已付款
//double bqyfk = Convert.ToDouble(txtBQYFK.Text);//本期应付款
//double bqsfk = Convert.ToDouble(txtBQSFK.Text.Trim());//本期实付款
//double yfklj = yfk + bqyfk;//应付款累计
//double sfklj = yfklj;//实付款累计
//txtYFKLJ.Text = yfklj.ToString();
//txtSFKLJ.Text = sfklj.ToString();
//txtBQYFK2.Text = txtBQYFK.Text.Trim();
//txtBQSFK2.Text = txtBQSFK.Text.Trim();
//txtBQSFK3.Text = txtBQSFK.Text.Trim();
//***************************************
}
if (contactform == "3")
{
sqlstr = "select b.ID,b.CM_CONTR,a.PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,b.CG_CONTR as CONTR,b.CM_MATERIAL,b.CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,d.CM_APPLI,d.CM_NOW from TBPM_CONPCHSINFO as a right join TBPM_CGDETAIL as b on a.PCON_BCODE=b.CG_CONTR left join (select ID,sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID<>'" + crid + "' and CR_ID like '" + crid.Substring(0, 12) + "%' and substring(CR_ID,17, 1)<" + crid.Substring(16) + " group by ID) as c on b.ID=C.ID left join TBPM_FUKUAN as d on b.ID=d.ID where d.CR_ID='" + crid + "'";
}
else if (contactform == "1")
{
sqlstr = "select b.ID,b.CM_CONTR,d.CM_PROJ as PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,b.SC_CONTR as CONTR,b.CM_CONTENT as CM_MATERIAL,b.CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,e.CM_APPLI,e.CM_NOW from TBPM_CONPCHSINFO as a right join TBPM_SCDETAIL as b on a.PCON_BCODE=b.SC_CONTR left join (select ID,sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID<>'" + crid + "' and CR_ID like '" + crid.Substring(0, 12) + "%' and substring(CR_ID,17, 1)<" + crid.Substring(16) + " group by ID) as c on b.ID=c.ID left join TBCM_PLAN as d on b.CM_CONTR=d.CM_CONTR left join TBPM_FUKUAN as e on b.ID=e.ID where e.CR_ID='" + crid + "'";
}
else
{
sqlstr = "select b.ID,a.PCON_BCODE as CM_CONTR,a.PCON_PJNAME,a.PCON_ENGNAME,CASE WHEN PCON_BALANCEACNT=0 THEN PCON_JINE ELSE PCON_BALANCEACNT END AS PCON_HTZJ,PCON_YFK,NULL as CONTR,NULL as CM_MATERIAL,a.PCON_JINE as CM_COUNT,CASE WHEN CM_YIFU is NULL THEN '0' ELSE CM_YIFU END AS CM_YIFU,CM_NOW,CM_APPLI from TBPM_CONPCHSINFO as a left join (select ID,sum(CM_NOW) as CM_YIFU from TBPM_FUKUAN where CR_ID<>'" + crid + "' and CR_ID like '" + crid.Substring(0, 12) + "%' and substring(CR_ID,17, 1)<" + crid.Substring(16) + " group by ID) as b on a.PCON_BCODE=b.ID left join TBPM_CHECKREQUEST as c on c.CR_HTBH=a.PCON_BCODE left join TBPM_FUKUAN as d on c.CR_ID=d.CR_ID where c.CR_ID='" + crid + "'";
}
Det_Repeater.DataSource = DBCallCommon.GetDTUsingSqlText(sqlstr);
Det_Repeater.DataBind();
}
private void Showdata() //将数据绑定到textbox
{
string st_id = Request.QueryString["ST_ID"].ToString(); //得到修改人员编码
string sqlText = "select distinct a.*,b.DEP_NAME,d.DEP_NAME as DEP_POSITION from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on a.ST_POSITION = d.DEP_CODE where ST_ID='" + st_id + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
DataRow dr = dt.Rows[0];
//绑定文件
if (dt.Rows[0]["ST_WENJIAN"].ToString() != "")
{
Hidden.Value = dt.Rows[0]["ST_WENJIAN"].ToString();
}
foreach (Control control in Panel1.Controls)
{
if (control is TextBox)
{
((TextBox)control).Text = dr[((TextBox)control).ID.ToString()].ToString();
}
else if (control is DropDownList)
{
DEP_NAME.ID = "ST_DEPID";
((DropDownList)control).SelectedValue = dr[((DropDownList)control).ID.ToString()].ToString();
DEP_NAME.ID = "DEP_NAME";
}
}
string role = dr["R_NAME"].ToString();
if (!string.IsNullOrEmpty(role))
{
string[] roles = role.Split(',');
string uRole = "";
for (int i = 0; i < roles.Length; i++)
{
uRole = roles[i].Substring(1, roles[i].Length - 2);
for (int j = 0; j < chk_Role.Items.Count; j++)
{
if (uRole == chk_Role.Items[j].Text)
{
chk_Role.Items[j].Selected = true;
}
}
}
}
Ddl_Post();
DEP_POSITION.SelectedValue = dr["ST_POSITION"].ToString();
showImage.ImageUrl = "~/staff_images/" + dr["JPGURL"].ToString();
sqlText = "select * from TBDS_WORKHIS where ST_ID='" + st_id + "'";
Det_Repeater.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater.DataBind();
sqlText = "select * from TBDS_EDUCA where ST_ID='" + st_id + "'";
Det_Repeater1.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater1.DataBind();
sqlText = "select * from TBDS_RELATION where ST_ID='" + st_id + "'";
Det_Repeater2.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater2.DataBind();
sqlText = "select * from OM_RenYuanDiaoDong where MOVE_PERNAME='" + ST_NAME.Text + "' and MOVE_STATE=MOVE_AUTH_RATING";
Det_Repeater3.DataSource = DBCallCommon.GetDTUsingSqlText(sqlText);
Det_Repeater3.DataBind();
InitVar();
InitVar1();
InitVar2();
InitVar3();
}
private void ShowData()
{
Panel1.Visible = false;
string sql = "select a.*,b.ST_NAME as name1,d.ST_NAME as name2,e.ST_NAME as name3 from TBCM_FHNOTICE as a left join TBDS_STAFFINFO as b on a.CM_MANCLERK=b.ST_ID left join TBDS_STAFFINFO as d on a.CM_BMZG=d.ST_ID left join TBDS_STAFFINFO as e on a.CM_GSLD=e.ST_ID where CM_FID='" + id + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
CM_BIANHAO.Text = dr["CM_BIANHAO"].ToString();
hid_BianHao.Value = dr["CM_BIANHAO"].ToString();
CM_CUSNAME.Text = dr["CM_CUSNAME"].ToString();
CM_SH.Text = dr["CM_SH"].ToString();
CM_JH.Text = dr["CM_JH"].ToString();
CM_LXR.Text = dr["CM_LXR"].ToString();
CM_LXFS.Text = dr["CM_LXFS"].ToString();
CM_JHTIME.Text = dr["CM_JHTIME"].ToString();
CM_YQDHSJ.Text = dr["CM_YQDHSJ"].ToString();
CM_BEIZHU.Text = dr["CM_BEIZHU"].ToString();
CM_MANCLERK.Text = dr["name1"].ToString();
CM_ZDTIME.Text = dr["CM_ZDTIME"].ToString();
Hidden.Value = dr["CM_ATTACH"].ToString();
HidCSR.Value = dr["CM_CSR"].ToString();
if (CM_ZDTIME.Text == "")
{
CM_ZDTIME.Text = "未填写";
}
manclerk = dr["CM_MANCLERK"].ToString();
rblShdj.SelectedValue = dr["CM_PSJB"].ToString();
if (dr["CM_PSJB"].ToString() == "1")
{
tb2.Visible = false;
}
firstid.Value = dr["CM_BMZG"].ToString();
txt_first.Text = dr["name2"].ToString();
rbl_first.Text = dt.Rows[0]["CM_YJ1"].ToString();
first_time.Text = dt.Rows[0]["CM_SJ1"].ToString();
first_opinion.Text = dt.Rows[0]["CM_NOTE1"].ToString();
first_opinion.ReadOnly = true;
secondid.Value = dt.Rows[0]["CM_GSLD"].ToString();
txt_second.Text = dt.Rows[0]["name3"].ToString();
rbl_second.Text = dt.Rows[0]["CM_YJ2"].ToString();
second_time.Text = dt.Rows[0]["CM_SJ2"].ToString();
second_opinion.Text = dt.Rows[0]["CM_NOTE2"].ToString();
second_opinion.ReadOnly = true;
if (firstid.Value == Session["UserID"].ToString())
{
tb2.Enabled = false;
}
if (secondid.Value == Session["UserID"].ToString())
{
tb1.Enabled = false;
}
sql = "select a.*,(case when b.CM_YFSM is null then '0' else CM_YFSM end) as TSA_YFSM from View_CM_FaHuo as a left join (select sum(convert(float,CM_FHNUM)) as CM_YFSM,CM_ID from VIEW_CM_FaHuo where CM_CONFIRM!=3 group by CM_ID) as b on a.CM_ID=b.CM_ID where CM_FID='" + id + "'";
dt = DBCallCommon.GetDTUsingSqlText(sql);
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
InitVar();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('请刷新原页面！');window.opener=null;window.open('','_self');window.close();", true);
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
if (CONTR.Text.Trim() != "")
{
//string sql = "";
StringBuilder sqlBuilder = new StringBuilder();
if (action == "add")
{
sqlBuilder.Append(@" SELECT a.BM_XUHAO AS ID ,
a.BM_ID AS CM_ID ,
BM_PJID AS CM_CONTR ,
b.CM_PROJ ,
a.BM_ENGID AS TSA_ID ,
a.BM_CHANAME AS TSA_ENGNAME ,
a.BM_TUHAO AS TSA_MAP ,
a.BM_PNUMBER AS TSA_NUMBER ,
a.BM_TECHUNIT AS TSA_UNIT ,
b.TSA_ENGNAME AS TSA_IDNOTE ,
( CAST(a.BM_PNUMBER AS INT)
- CAST(( CASE WHEN c.CM_YFSM IS NULL THEN '0'
ELSE c.CM_YFSM
END ) AS INT) ) AS CM_FHNUM ,
( CASE WHEN c.CM_YFSM IS NULL THEN '0'
ELSE c.CM_YFSM
END ) AS TSA_YFSM ");
sqlBuilder.Append(@" FROM dbo.TBPM_STRINFODQO AS a
LEFT JOIN View_CM_TSAJOINPROJ AS b ON a.BM_ENGID = b.TSA_ID
LEFT JOIN ( SELECT SUM(CM_FHNUM) AS CM_YFSM ,
CM_ID
FROM View_CM_FaHuo
WHERE CM_CONFIRM != 3
GROUP BY CM_ID
) AS c ON CONVERT(VARCHAR(20), a.BM_ID) = c.CM_ID ");
sqlBuilder.Append(@" WHERE ( ( a.BM_MARID IS NULL
OR a.BM_MARID = ''
)
OR ( a.BM_MARID IS NOT NULL
AND a.BM_MARID <> ''
AND a.BM_KU IS NOT NULL
AND ( a.BM_KU <> ''
OR ( ( a.BM_KU = ''
OR a.BM_KU IS NULL
)
AND a.BM_MARID LIKE '%.%'
)
)
)
)
AND BM_PJID NOT LIKE '%JSB.BOM%'
AND BM_MSSTATUS <> '1'
AND dbo.Splitnum(BM_ZONGXU, '.') < 3 ");
if (!string.IsNullOrEmpty(CONTR.Text))
{
sqlBuilder.Append(" and a.BM_PJID like '%" + CONTR.Text.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(txtENGNAME.Text))
{
sqlBuilder.Append(" and a.BM_CHANAME like '%" + txtENGNAME.Text.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(txtMap.Text))
{
sqlBuilder.Append(" and a.BM_TUHAO like '%" + txtMap.Text.Trim() + "%' ");
}
sqlBuilder.Append(" order by TSA_ID,ID asc ");
}
else if (action == "edit")
{
//sql = "select a.BM_XUHAO as ID,a.BM_ID as CM_ID,BM_PJID as CM_CONTR,b.CM_PROJ,a.BM_ENGID as TSA_ID,a.BM_CHANAME as TSA_ENGNAME,a.BM_TUHAO as TSA_MAP,a.BM_PNUMBER as TSA_NUMBER,a.BM_TECHUNIT as TSA_UNIT,b.TSA_ENGNAME as TSA_IDNOTE,(CAST(a.BM_PNUMBER as int)-CAST((case when c.CM_YFSM is null then '0' else c.CM_YFSM end) as int)) as CM_FHNUM,(case when c.CM_YFSM is null then '0' else c.CM_YFSM end) as TSA_YFSM from dbo.TBPM_STRINFODQO as a left join View_CM_TSAJOINPROJ as b on a.BM_ENGID=b.TSA_ID left join (select sum(CM_FHNUM) as CM_YFSM,CM_ID from VIEW_CM_FaHuo where CM_CONFIRM!=3 group by CM_ID) as c on convert(varchar(20),a.BM_ID)=c.CM_ID where ((a.BM_MARID is null or a.BM_MARID='') or (a.BM_MARID is not null and a.BM_MARID<>'' and a.BM_KU like '%S%' )) and a.BM_PJID like '%" + CONTR.Text.Trim() + "%' and BM_PJID not like '%JSB.BOM%' and BM_MSSTATUS<>'1' and dbo.Splitnum(BM_ZONGXU,'.')<3 order by TSA_ID,ID asc";
sqlBuilder.Append(@" SELECT a.BM_XUHAO AS ID ,
a.BM_ID AS CM_ID ,
BM_PJID AS CM_CONTR ,
b.CM_PROJ ,
a.BM_ENGID AS TSA_ID ,
a.BM_CHANAME AS TSA_ENGNAME ,
a.BM_TUHAO AS TSA_MAP ,
a.BM_PNUMBER AS TSA_NUMBER ,
a.BM_TECHUNIT AS TSA_UNIT ,
b.TSA_ENGNAME AS TSA_IDNOTE ,
( CAST(a.BM_PNUMBER AS INT)
- CAST(( CASE WHEN c.CM_YFSM IS NULL THEN '0'
ELSE c.CM_YFSM
END ) AS INT) ) AS CM_FHNUM ,
( CASE WHEN c.CM_YFSM IS NULL THEN '0'
ELSE c.CM_YFSM
END ) AS TSA_YFSM ");
sqlBuilder.Append(@" FROM dbo.TBPM_STRINFODQO AS a
LEFT JOIN View_CM_TSAJOINPROJ AS b ON a.BM_ENGID = b.TSA_ID
LEFT JOIN ( SELECT SUM(CM_FHNUM) AS CM_YFSM ,
CM_ID
FROM View_CM_FaHuo
WHERE CM_CONFIRM != 3
GROUP BY CM_ID
) AS c ON CONVERT(VARCHAR(20), a.BM_ID) = c.CM_ID ");
sqlBuilder.Append(@" WHERE ( ( a.BM_MARID IS NULL
OR a.BM_MARID = ''
)
OR ( a.BM_MARID IS NOT NULL
AND a.BM_MARID <> ''
AND a.BM_KU LIKE '%S%'
)
)
AND BM_PJID NOT LIKE '%JSB.BOM%'
AND BM_MSSTATUS <> '1'
AND dbo.Splitnum(BM_ZONGXU, '.') < 3 ");
if (!string.IsNullOrEmpty(CONTR.Text))
{
sqlBuilder.Append(" AND a.BM_PJID LIKE '%" + CONTR.Text.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(txtENGNAME.Text))
{
sqlBuilder.Append(" AND a.BM_CHANAME LIKE '%" + txtENGNAME.Text.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(txtMap.Text))
{
sqlBuilder.Append(" AND a.BM_TUHAO LIKE '%" + txtMap.Text.Trim() + "%' ");
}
sqlBuilder.Append(" ORDER BY TSA_ID,ID ASC ");
}
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlBuilder.ToString());
Det_Repeater.DataSource = dt;
Det_Repeater.DataBind();
InitVar();
}
}
