protected void imgbtnDF_Click(object sender, ImageClickEventArgs e) { ImageButton imgbtn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)imgbtn.Parent.Parent; GridView gv = (GridView)TabContainer1.FindControl("TabPanel1").FindControl("GridView1"); string sqlStr = "select fileload,fileName,showName from " + ((ImageButton)sender).ID + " where fileID='" + gv.DataKeys[gvr.RowIndex].Value.ToString() + "'"; DataSet ds = DBCallCommon.FillDataSet(sqlStr); string strFilePath = ds.Tables[0].Rows[0]["fileload"].ToString() + @"\" + ds.Tables[0].Rows[0]["fileName"].ToString(); if (File.Exists(strFilePath)) { string showName = ds.Tables[0].Rows[0]["showName"].ToString(); System.IO.FileInfo file = new System.IO.FileInfo(strFilePath); Response.Clear(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(showName)); Response.AppendHeader("Content-Length", file.Length.ToString()); Response.WriteFile(file.FullName); Response.Flush(); Response.End(); } else { filesError.Visible = true; filesError.Text = "文件已被删除,请通知相关人员上传文件!"; } }
private void Control_Enable() { string sql = "select * from TBCM_PLAN where ID='" + id + "'"; 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; } break; } else { pal.Enabled = false; } } } }
private void ExeSQL(int j) { #region 评审代码 List <string> strb_sql = new List <string>(); string psyj = ""; string txt_yj = ""; //意见文本框中的文字 string riqi = DateTime.Now.ToString("yyyy-MM-dd"); //评审时间 string username = Session["UserName"].ToString(); //评审人是部门负责人 string sqlText = "select *,b.DEP_NAME from TBDS_PSVIEW as a left join TBDS_DEPINFO as b on a.ST_DEP=b.DEP_CODE where ST_ID='" + id + "'and ST_PIDTYPE ='1' and ST_DEP!='01'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText); for (int i = 0; i < dt.Rows.Count; i++) { Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { TextBox txt_shyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i.ToString()); txt_yj = txt_shyj.Text; } } //评审人是公司领导 sqlText = "select *,b.DEP_NAME from TBDS_PSVIEW as a left join TBDS_DEPINFO as b on a.ST_DEP=b.DEP_CODE where ST_ID='" + id + "'and ST_PIDTYPE ='1' and ST_DEP='01'"; DataTable dt_gsld = DBCallCommon.GetDTUsingSqlText(sqlText); for (int i = 0; i < dt_gsld.Rows.Count; i++) { Label lb = (Label)TabContainer1.FindControl("Pan_Leader").FindControl("lb_shr_ld" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { TextBox txt_shyj = (TextBox)TabContainer1.FindControl("Pan_Leader").FindControl("txt_shyj_ld" + i.ToString()); txt_yj = txt_shyj.Text; } } if (j == 3) { if (txt_yj == "") { if (Session["UserDeptID"].ToString() != "01") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('驳回意见不能为空!');", true); return; } psyj = txt_yj; } else { psyj = txt_yj; } } else { if (txt_yj == "") { psyj = "同意"; } else { psyj = txt_yj; } } #endregion string sql = "update TBDS_PSVIEW set ST_PSYJ='" + j.ToString() + "',ST_NOTE='" + psyj + "' ,ST_SHSJ='" + riqi + "' where ST_ID='" + id + "' and ST_PID='" + Session["UserID"].ToString() + "'"; strb_sql.Add(sql); if (j == 2) { //部门评审完之后,提醒领导需要审批 sql = "select * from TBDS_PSVIEW where ST_DEP!='01' and ST_PSYJ='1'"; int jud = DBCallCommon.GetDTUsingSqlText(sql).Rows.Count; sql = "select * from TBDS_PSVIEW where ST_DEP='01' and ST_PSYJ!='1'";//领导审批之后不需要重复发送邮件 DataTable leader = DBCallCommon.GetDTUsingSqlText(sql); int jud1 = leader.Rows.Count; string item = string.Empty; if (jud != 0 && jud1 == 0) { switch (type) { case "0": item = "人员转正"; break; case "1": item = "合同签订"; break; case "2": item = "人员流动"; break; case "3": item = "人员年假"; break; default: break; } for (int i = 0; i < jud1; i++) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(leader.Rows[i]["ST_PID"].ToString()), new List <string>(), new List <string>(), "部门评审完毕", string.Format("您有{0}审批!", item)); } } } //修改评审状态 评审完成2,已驳回3, //根据类型来修改相应的表 if (j == 3) //不同意 { sql = "update TBDS_PSDETAIL set ST_PSZT='3' where ST_ID='" + id + "'"; strb_sql.Add(sql); //发送邮件通知——审批驳回 //SendMail("no"); } else //同意 如果除此人以外其他人都同意了,则审批状态改为审批完成 { sql = "select * from TBDS_PSVIEW where ST_ID='" + id + "' and ST_PID!='" + Session["UserID"].ToString() + "' and ST_PSYJ!='2'"; DataTable dt_check = DBCallCommon.GetDTUsingSqlText(sql); if (dt_check.Rows.Count == 0) { sql = "update TBDS_PSDETAIL set ST_PSZT='2' where ST_ID='" + id + "'"; strb_sql.Add(sql); if (type == "0") { sql = "update TBDS_STAFFINFO ST_ZHUANZ='1' where ST_ID='" + lb_Id.Text + "'"; strb_sql.Add(sql); } else if (type == "1") { sql = "update TBDS_STAFFINFO set ST_CONTRSTART='" + lb_Start.Text + "',ST_CONTREND='" + lb_End.Text + "' where ST_ID='" + lb_Id.Text + "'"; strb_sql.Add(sql); sql = string.Format("insert into TBDS_HETONG values('{0}','{1}','{2}','{3}')", lb_Id.Text, lb_Start.Text, lb_End.Text, DateTime.Now.ToString()); strb_sql.Add(sql); } else if (type == "2") { sql = "update TBDS_STAFFINFO set ST_DEPID='" + lb_DepId.Text + "'"; } //发送邮件通知——审批通过 //SendMail("yes"); } } DBCallCommon.ExecuteTrans(strb_sql); }
private void Control_Enable() { string username = Session["UserName"].ToString(); //部门负责人 string sqlbmfzr = "select a.*,b.DEP_NAME from TBDS_PSVIEW as a left join TBDS_DEPINFO as b on a.ST_DEP=b.DEP_CODE where a.ST_ID='" + id + "'and ST_PIDTYPE ='1' and ST_DEP!='01'"; DataTable dt_bmfzr = DBCallCommon.GetDTUsingSqlText(sqlbmfzr); for (int i = 0; i < dt_bmfzr.Rows.Count; 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()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { pal.Enabled = true; tbyj.BorderColor = System.Drawing.Color.Orange; tbyj.Focus(); LbtnYes.Visible = true; LbtnNO.Visible = true; } else { pal.Enabled = false; } } //公司领导 string sqlgsld = "select a.*,b.DEP_NAME from TBDS_PSVIEW as a left join TBDS_DEPINFO as b on a.ST_DEP=b.DEP_CODE where a.ST_ID='" + id + "'and ST_PIDTYPE ='1' and ST_DEP='01'"; DataTable dt_gsld = DBCallCommon.GetDTUsingSqlText(sqlgsld); for (int i = 0; i < dt_gsld.Rows.Count; i++) { Panel pal = new Panel(); pal = (Panel)TabContainer1.FindControl("Pan_Leader").FindControl("Panel" + i.ToString()); TextBox tbyj = (TextBox)TabContainer1.FindControl("Pan_Leader").FindControl("txt_shyj_ld" + i.ToString()); Label lb = (Label)TabContainer1.FindControl("Pan_Leader").FindControl("lb_shr_ld" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { //对于公司领导,审计通过后才能审核 string check_sjyj = "select distinct ST_PSYJ FROM TBDS_PSVIEW WHERE ST_ID='" + id + "'and ST_DEP<>'01' AND ST_PSYJ='0'"; DataTable dt_check_sjyj = DBCallCommon.GetDTUsingSqlText(check_sjyj); if ((Session["UserDeptID"].ToString() == "01" && dt_check_sjyj.Rows.Count == 0) || Session["UserDeptID"].ToString() != "01") { pal.Enabled = true; tbyj.BorderColor = System.Drawing.Color.Orange; tbyj.Focus(); LbtnYes.Visible = true; LbtnNO.Visible = true; } else { pal.Enabled = false; } } else { pal.Enabled = false; } } }
private void ExcuteSql(int j) { List <string> str_sql = new List <string>(); string sql = ""; string psyj = ""; string txt_yj = ""; //意见文本框中的文字 string riqi = DateTime.Now.ToString("yyyy-MM-dd"); //评审时间 //评审人意见 sql = "select * from TBCM_CHANLIST where CH_ID='" + chId + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); int psr = 0; int n = 0; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; n = int.Parse(dr["CM_PSJB"].ToString()); for (int i = 0; i < n; i++) { Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i); TextBox txt_shyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i); HiddenField hd = (HiddenField)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shrid" + i.ToString()); if (UserID.Value == hd.Value) { txt_yj = txt_shyj.Text; psr = i + 1; } } //修改评审状态 评审完成2,已驳回3, //根据类型来修改相应的表 if (j == 2) { if (txt_yj == "") { psyj = "同意"; } else { psyj = txt_yj; } //评审完之后,邮件提示下一个人有计划单需要审批 if (psr < 3 && psr < n) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_PS" + (psr + 1)].ToString()), new List <string>(), new List <string>(), "经营计划单评审", "您有经营计划单需要评审!"); } if (psr == n && dt.Rows[0]["CM_STATE"].ToString() == "1") { sql = "update TBCM_CHANLIST set CM_STATE='2' where CH_ID='" + chId + "'"; str_sql.Add(sql); //计划单增补 List <string> tsaId = new List <string>(); Dictionary <string, string> dic = new Dictionary <string, string>(); string strsql = "select * from TBCM_CHANGE where CH_ID='" + chId + "'"; DataTable newId = DBCallCommon.GetDTUsingSqlText(strsql); foreach (DataRow drow in newId.Rows) { tsaId.Add(drow["TSA_ID"].ToString()); sql = string.Format("insert into TBCM_BASIC(ID,TSA_ID,TSA_ENGNAME,TSA_MAP,TSA_NUMBER,TSA_UNIT,TSA_MATERIAL,TSA_IDNOTE,TSA_TYPE) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", id, drow["TSA_ID"].ToString(), drow["TSA_ENGNAME"].ToString(), drow["TSA_MAP"].ToString(), drow["TSA_NUMBER"].ToString(), drow["TSA_UNIT"].ToString(), drow["TSA_MATERIAL"].ToString(), drow["TSA_IDNOTE"].ToString(), drow["TSA_TYPE"].ToString()); str_sql.Add(sql); } //附件添加 strsql = "select * from tb_files where BC_CONTEXT='" + chId + "'"; DataTable tbfile = DBCallCommon.GetDTUsingSqlText(strsql); strsql = "select * from TBCM_PLAN where ID='" + id + "'"; DataTable context = DBCallCommon.GetDTUsingSqlText(strsql); for (int i = 0; i < tbfile.Rows.Count; i++) { if (context.Rows.Count > 0) { DataRow tbrow = tbfile.Rows[i]; sql = string.Format("insert into tb_files values('{0}','{1}','{2}','{3}','{4}')", context.Rows[0]["CM_CONTEXT"].ToString(), tbrow["fileload"].ToString(), tbrow["fileUpDate"].ToString(), tbrow["fileName"].ToString(), tbrow["ShowName"].ToString()); str_sql.Add(sql); } } tsaId.Distinct().ToList(); foreach (string item in tsaId) { strsql = "select * from TBCM_BASIC where TSA_ID='" + item + "'"; DataTable dt1 = DBCallCommon.GetDTUsingSqlText(strsql); strsql = "select * from TBCM_CHANGE where CH_ID='" + chId + "' and TSA_ID='" + item + "'"; DataTable dt2 = DBCallCommon.GetDTUsingSqlText(strsql); string engName = ""; if (dt1.Rows.Count > 0) { for (int i = 0; i < dt1.Rows.Count; i++) { engName += "," + dt1.Rows[i]["TSA_ENGNAME"].ToString(); } for (int i = 0; i < dt2.Rows.Count; i++) { engName += "," + dt2.Rows[i]["TSA_ENGNAME"].ToString(); } engName = engName.Substring(1); } } //计划单增补审核通过插入销售合同 string tsa_id = ""; string sqltext = ""; string jhdtype = ""; foreach (GridViewRow gr in GridView1.Rows) { string TSA_ID = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_ID")).Text.ToString(); if (TSA_ID == "" || TSA_ID == null) { TSA_ID = tsa_id; } else { tsa_id = TSA_ID; } string CM_ENGNAME = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_ENGNAME")).Text.ToString(); string CM_MAP = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_MAP")).Text.ToString(); string CM_NUMBER = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_NUMBER")).Text.ToString(); string CM_UNIT = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_UNIT")).Text.ToString(); string CM_MATERIAL = ((System.Web.UI.WebControls.Label)gr.FindControl("TSA_MATERIAL")).Text.ToString(); string sqlstid = "select TSA_ID from TBPM_DETAIL where CM_CONTR='" + CM_CONTR.Text.Trim() + "'and TSA_ID='" + tsa_id.Trim() + "' and CM_JHDTYPE='0'"; DataTable stiddata = DBCallCommon.GetDTUsingSqlText(sqlstid); if (stiddata.Rows.Count > 0) { jhdtype = "1"; } else { jhdtype = "3"; } sqltext = "insert into TBPM_DETAIL(CM_CONTR,TSA_ID,CM_PROJ,CM_YZHTH,CM_ENGNAME,CM_MATERIAL,CM_MAP,CM_NUMBER,CM_UNIT,CM_JHDTYPE) values('" + CM_CONTR.Text.Trim() + "','" + tsa_id.Trim() + "','" + CM_PROJ.Text.Trim() + "','" + CM_DFCONTR.Text.Trim() + "','" + CM_ENGNAME.Trim() + "','" + CM_MATERIAL.Trim() + "','" + CM_MAP.Trim() + "','" + CM_NUMBER.Trim() + "','" + CM_UNIT.Trim() + "','" + jhdtype + "')"; str_sql.Add(sqltext); } //2017.1.5修改,添加合同号和项目名称 string cs = "select CM_PID,CM_CONTR,CM_PROJ from TBCM_PSVIEW left join TBCM_CHANGE on TBCM_PSVIEW.CM_ID=TBCM_CHANGE.CH_ID left join TBCM_PLAN on TBCM_CHANGE.ID=TBCM_PLAN.ID where TBCM_PSVIEW.CM_ID='" + chId + "' and CM_PIDTYPE<>''and CM_PIDTYPE is not null"; //string cs = "select CM_PID from TBCM_PSVIEW where CM_ID='" + chId + "' and CM_PIDTYPE<>''and CM_PIDTYPE is not null"; DataTable cs_dt = DBCallCommon.GetDTUsingSqlText(cs); List <string> cs_list = new List <string>(); for (int i = 0; i < cs_dt.Rows.Count; i++) { cs_list.Add(DBCallCommon.GetEmailAddressByUserID(cs_dt.Rows[i][0].ToString())); } if (!cs_list.Contains(DBCallCommon.GetEmailAddressByUserID("202"))) { cs_list.Add(DBCallCommon.GetEmailAddressByUserID("202")); } if (cs_list.Count != 0) { cs_list = cs_list.Distinct().ToList(); for (int k = 0; k < cs_list.Count; k++) { string fa_all_mail = cs_list[k]; //2017.1.5修改,添加合同号和项目名称 DBCallCommon.SendEmail(fa_all_mail, new List <string>(), new List <string>(), "经营计划单增补", "您有合同号为" + cs_dt.Rows[0]["CM_CONTR"].ToString() + ",项目名称为" + cs_dt.Rows[0]["CM_PROJ"].ToString() + "的经营计划单增补需要查看!"); //DBCallCommon.SendEmail(fa_all_mail, new List<string>(), new List<string>(), "经营计划单增补", "您有经营计划单增补需要查看!"); } } // DBCallCommon.SendEmail("", cs_list, new List<string>(), "经营计划单增补", "您有经营计划单增补需要查看!"); } } else //不同意 { if (txt_yj == "") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('驳回意见不能为空!');", true); return; } else { psyj = txt_yj; } sql = "update TBCM_CHANLIST set CM_STATE='3' where CH_ID='" + chId + "'"; str_sql.Add(sql); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_MANCLERK"].ToString()), new List <string>(), new List <string>(), "经营计划单被驳回", "您提交的经营计划单被驳回!请修改后再次提交"); } sql = string.Format("update TBCM_CHANLIST set CM_PSYJ{0}='{1}',CM_PSSJ{0}='{2}',CM_NOTE{0}='{3}' where CH_ID='{4}'", psr, j, riqi, psyj, chId); str_sql.Add(sql); DBCallCommon.ExecuteTrans(str_sql); Response.Redirect("CM_ZengBuPs.aspx"); } }
private void ExcuteSql(int j) { List <string> str_sql = new List <string>(); string sql = ""; string psyj = ""; string txt_yj = ""; //意见文本框中的文字 string riqi = DateTime.Now.ToString("yyyy-MM-dd"); //评审时间 //评审人意见 sql = "select * from TBCM_CHANLIST where CH_ID='" + chId + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); int psr = 0; int n = 0; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; n = int.Parse(dr["CM_PSJB"].ToString()); for (int i = 0; i < n; i++) { Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i); TextBox txt_shyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i); HiddenField hd = (HiddenField)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shrid" + i.ToString()); if (UserID.Value == hd.Value) { txt_yj = txt_shyj.Text; psr = i + 1; } } //修改评审状态 评审完成2,已驳回3, //根据类型来修改相应的表 if (j == 2) { if (txt_yj == "") { psyj = "同意"; } else { psyj = txt_yj; } //评审完之后,邮件提示下一个人有计划单需要审批 if (psr < 3 && psr < n) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_PS" + (psr + 1)].ToString()), new List <string>(), new List <string>(), "经营计划单评审", "您有经营计划单需要评审!"); } if (psr == n && dt.Rows[0]["CM_STATE"].ToString() == "1") { sql = "update TBCM_CHANLIST set CM_STATE='2' where CH_ID='" + chId + "'"; str_sql.Add(sql); //制作内容变更 string sql00 = ""; sql = "select * from TBCM_CHANGE where CH_ID='" + chId + "' and CM_CHANITEM='1'"; DataTable dtchange = DBCallCommon.GetDTUsingSqlText(sql); for (int i = 0; i < dtchange.Rows.Count; i++) { DataRow drch = dtchange.Rows[i]; sql = string.Format("update TBCM_BASIC set TSA_ENGNAME='{0}',TSA_MAP='{1}',TSA_NUMBER='{2}',TSA_UNIT='{3}',TSA_MATERIAL='{4}',TSA_TYPE='{5}',TSA_IDNOTE='{6}' where ID='{7}' and CM_ID='{8}'", drch["TSA_ENGNAME"].ToString(), drch["TSA_MAP"].ToString(), drch["TSA_NUMBER"].ToString(), drch["TSA_UNIT"].ToString(), drch["TSA_MATERIAL"].ToString(), drch["TSA_TYPE"].ToString(), drch["TSA_IDNOTE"].ToString(), drch["ID"].ToString(), drch["CM_ID"].ToString()); str_sql.Add(sql); //计划单变更通过更新销售合同明细 sql00 = "select * from TBCM_CHANGE where CH_ID='" + chId + "' and CM_CHANITEM='0'"; DataTable dtchange00 = DBCallCommon.GetDTUsingSqlText(sql00); DataRow drch00 = dtchange00.Rows[i]; sql = string.Format("update TBPM_DETAIL set CM_ENGNAME='{0}',CM_MAP='{1}',CM_NUMBER='{2}',CM_UNIT='{3}',CM_MATERIAL='{4}' where CM_CONTR='{5}' and TSA_ID='{6}' and CM_PROJ='{7}'and CM_ENGNAME='{8}'and CM_MAP='{9}'and CM_MATERIAL='{10}'and CM_NUMBER='{11}'and CM_UNIT='{12}'", drch["TSA_ENGNAME"].ToString(), drch["TSA_MAP"].ToString(), drch["TSA_NUMBER"].ToString(), drch["TSA_UNIT"].ToString(), drch["TSA_MATERIAL"].ToString(), CM_CONTR.Text.ToString(), drch00["TSA_ID"].ToString(), CM_PROJ.Text.ToString(), drch00["TSA_ENGNAME"].ToString(), drch00["TSA_MAP"].ToString(), drch00["TSA_MATERIAL"].ToString(), drch00["TSA_NUMBER"].ToString(), drch00["TSA_UNIT"].ToString()); str_sql.Add(sql); DataTable dt2 = DBCallCommon.GetDTUsingSqlText("select * from TBCM_CHANGE where CH_ID='" + chId + "' and CM_CHANITEM='0' and CM_ID='" + drch["CM_ID"].ToString() + "'"); if (dt2.Rows.Count > 0) { if (dt2.Rows[0]["TSA_TYPE"].ToString() != drch["TSA_TYPE"].ToString()) { sql = string.Format("update TBCM_BASIC set TSA_TYPE='{0}' where ID='{1}' and TSA_ID='{2}'", drch["TSA_TYPE"].ToString(), drch["ID"].ToString(), drch["TSA_ID"].ToString()); str_sql.Add(sql); } } } //其他变更 Dictionary <string, string> dic = new Dictionary <string, string>() { { "交货日期", "CM_FHDATE" }, { "质量标准", "CM_LEVEL" }, { "质量校验与验收", "CM_TEST" }, { "交货地点及运输方式", "CM_JHADDRESS" }, { "包装要求", "CM_BZ" }, { "交货要求", "CM_JH" }, { "油漆要求", "CM_YQ" }, { "买方责任人", "CM_DUTY" }, { "备注", "CM_NOTE" }, { "对方合同号", "CM_DFCONTR" } }; sql = "select a.*,b.ID from TBCM_ChangePart as a left join TBCM_CHANLIST as b on a.CH_ID=b.CH_ID where a.CH_ID='" + chId + "' and CM_CHANITEM='1'"; dtchange = DBCallCommon.GetDTUsingSqlText(sql); for (int i = 0; i < dtchange.Rows.Count; i++) { DataRow drch = dtchange.Rows[i]; sql = string.Format("update TBCM_PLAN set {0}='{1}' where ID='{2}'", dic[drch["CM_BGXM"].ToString()], drch["CM_CONTENT"].ToString(), drch["ID"].ToString()); str_sql.Add(sql); } //2017.1.5修改,添加合同号和项目名称 string cs = "select CM_PID,CM_CONTR,CM_PROJ from TBCM_PSVIEW left join TBCM_CHANGE on TBCM_PSVIEW.CM_ID=TBCM_CHANGE.CH_ID left join TBCM_PLAN on TBCM_CHANGE.ID=TBCM_PLAN.ID where TBCM_PSVIEW.CM_ID='" + chId + "' and CM_PIDTYPE='1'"; //string cs = "select CM_PID from TBCM_PSVIEW where CM_ID='" + chId + "' and CM_PIDTYPE='1'"; DataTable cs_dt = DBCallCommon.GetDTUsingSqlText(cs); List <string> cs_list = new List <string>(); for (int i = 0; i < cs_dt.Rows.Count; i++) { cs_list.Add(DBCallCommon.GetEmailAddressByUserID(cs_dt.Rows[i][0].ToString())); } //2017.1.13修改,直接添加王艳辉 if (!cs_list.Contains(DBCallCommon.GetEmailAddressByUserID("202"))) { cs_list.Add(DBCallCommon.GetEmailAddressByUserID("202")); } //2017.1.5修改,添加合同号和项目名称 if (cs_list.Count != 0) { cs_list = cs_list.Distinct().ToList(); for (int k = 0; k < cs_list.Count; k++) { string fa_all_mail = cs_list[k]; DBCallCommon.SendEmail(fa_all_mail, new List <string>(), new List <string>(), "经营计划单变更", "您有合同号为" + cs_dt.Rows[0]["CM_CONTR"].ToString() + ",项目名称为" + cs_dt.Rows[0]["CM_PROJ"].ToString() + "的经营计划单变更需要查看!"); } } // DBCallCommon.SendEmail("", cs_list, new List<string>(), "经营计划单变更", "您有经营计划单变更需要查看!"); // 给王艳辉发邮件 //string str1 = "select a.*,b.ST_NAME from TBCM_PLAN as a left join TBDS_STAFFINFO as b on b.ST_ID=a.CM_MANCLERK where ID='" + id + "'"; //DataTable dt1 = DBCallCommon.GetDTUsingSqlText(str1); //DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID("202"), new List<string>(), new List<string>(), "经营计划单变更", "合同号为“" + dt1.Rows[0]["CM_CONTR"].ToString() + "的经营计划单已经变更,请您上系统查看"); // 发送邮件 string sql1 = "select ID,TSA_ID,TSA_ENGNAME,MTA_DUY,TSA_TCCLERKNM,QSA_QCCLERKNM from TBCM_BASIC as a left join View_TBMP_TASKASSIGN as b on a.TSA_ID=b.MTA_ID where ID=" + id; DataTable dt3 = DBCallCommon.GetDTUsingSqlText(sql1); if (dt.Rows.Count > 0) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(GetUesrID(dt3.Rows[0]["MTA_DUY"].ToString())), new List <string>(), new List <string>(), "经营计划单变更", "任务号“" + dt3.Rows[0]["TSA_ID"].ToString() + "“产品名称为" + dt3.Rows[0]["TSA_ENGNAME"].ToString() + "的经营计划单已经变更,请您上系统查看"); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(GetUesrID(dt3.Rows[0]["TSA_TCCLERKNM"].ToString())), new List <string>(), new List <string>(), "经营计划单变更", "任务号“" + dt3.Rows[0]["TSA_ID"].ToString() + "“产品名称为" + dt3.Rows[0]["TSA_ENGNAME"].ToString() + "的经营计划单已经变更,请您上系统查看"); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(GetUesrID(dt3.Rows[0]["QSA_QCCLERKNM"].ToString())), new List <string>(), new List <string>(), "经营计划单变更", "任务号“" + dt3.Rows[0]["TSA_ID"].ToString() + "“产品名称为" + dt3.Rows[0]["TSA_ENGNAME"].ToString() + "的经营计划单已经变更,请您上系统查看"); } string resultvalid = ""; for (int k = 0; k < GridView1.Rows.Count; k++) { Label TSA_ID = (Label)GridView1.Rows[k].FindControl("TSA_ID"); if (!string.IsNullOrEmpty(TSA_ID.Text.ToString().Trim())) { resultvalid += TSA_ID.Text.ToString().Trim() + ","; } } string sqlquality = "select QSA_ENGID,QSA_TCCHGER,QSA_TCCHGERNM,QSA_QCCLERK,QSA_QCCLERKNM from View_TCTSASSGN_QTSASSGN where QSA_ENGID in ('" + resultvalid.Substring(0, resultvalid.Length - 1) + "') and QSA_QCCLERK is not null and QSA_QCCLERK<>''"; DataTable dtquality = DBCallCommon.GetDTUsingSqlText(sqlquality); for (int m = 0; m < dtquality.Rows.Count; m++) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dtquality.Rows[m]["QSA_TCCHGER"].ToString()), new List <string>(), new List <string>(), "经营计划单变更", "任务号为“" + resultvalid.Substring(0, resultvalid.Length - 1) + "”的经营计划单已经变更,请您查看相关质检任务分工!"); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dtquality.Rows[m]["QSA_QCCLERK"].ToString()), new List <string>(), new List <string>(), "经营计划单变更", "任务号为“" + resultvalid.Substring(0, resultvalid.Length - 1) + "”的经营计划单已经变更,请您查看相关质检任务!"); } } } else //不同意 { if (txt_yj == "") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('驳回意见不能为空!');", true); return; } else { psyj = txt_yj; } sql = "update TBCM_CHANLIST set CM_STATE='3' where CH_ID='" + chId + "'"; str_sql.Add(sql); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_MANCLERK"].ToString()), new List <string>(), new List <string>(), "经营计划单被驳回", "您提交的经营计划单被驳回!请修改后再次提交"); } sql = string.Format("update TBCM_CHANLIST set CM_PSYJ{0}='{1}',CM_PSSJ{0}='{2}',CM_NOTE{0}='{3}' where CH_ID='{4}'", psr, j, riqi, psyj, chId); str_sql.Add(sql); DBCallCommon.ExecuteTrans(str_sql); Response.Redirect("CM_ChangePS.aspx"); } }
private void Control_All_Pal_Enable() { string username = Session["UserName"].ToString(); //部门负责人 string sqlbmfzr = "select DISTINCT ST_NAME,DEP_NAME,CRD_ID,CRD_PID,CRD_PSYJ,CRD_NOTE,CRD_SHSJ" + " ,CRD_DEP from VIEW_TBCR_CONTRACTVIEW_AUDIT where CRD_ID='" + id + "'and CRD_PIDTYPE ='1' and CRD_DEP!='01'"; DataTable dt_bmfzr = DBCallCommon.GetDTUsingSqlText(sqlbmfzr); for (int i = 0; i < dt_bmfzr.Rows.Count; i++) { Panel pal = new Panel(); pal = (Panel)TabContainer1.FindControl("TabPanel2").FindControl("Panel" + i.ToString()); TextBox tbyj = (TextBox)TabContainer1.FindControl("TabPanel2").FindControl("txt_shyj" + i.ToString()); Label lb = (Label)TabContainer1.FindControl("TabPanel2").FindControl("lb_shr" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1] && action == "audit") { //对于审计部的人,其他部门都通过后审计才能审核 string check_bmyj = "select distinct CRD_PSYJ FROM VIEW_TBCR_CONTRACTVIEW_AUDIT WHERE CRD_ID='" + id + "'and CRD_DEP not in ('01','14') AND CRD_PSYJ='0'"; DataTable dt_check_bmyj = DBCallCommon.GetDTUsingSqlText(check_bmyj); if ((Session["UserDeptID"].ToString() == "14" && dt_check_bmyj.Rows.Count == 0) || Session["UserDeptID"].ToString() != "14") { pal.Enabled = true; tbyj.BorderColor = System.Drawing.Color.Orange; tbyj.Focus(); LbtnYes.Visible = true; LbtnNO.Visible = true; } else { pal.Enabled = false; } } else { pal.Enabled = false; } } //公司领导 string sqlgsld = "select DISTINCT ST_NAME,DEP_NAME,CRD_ID,CRD_PID,CRD_PSYJ,CRD_NOTE,CRD_SHSJ" + " ,CRD_DEP from VIEW_TBCR_CONTRACTVIEW_AUDIT where CRD_ID='" + id + "'and CRD_PIDTYPE ='1' and CRD_DEP='01'"; DataTable dt_gsld = DBCallCommon.GetDTUsingSqlText(sqlgsld); for (int i = 0; i < dt_gsld.Rows.Count; i++) { Panel pal = new Panel(); pal = (Panel)TabContainer1.FindControl("TabPanel3").FindControl("Panel" + i.ToString()); TextBox tbyj = (TextBox)TabContainer1.FindControl("TabPanel3").FindControl("txt_shyj_ld" + i.ToString()); Label lb = (Label)TabContainer1.FindControl("TabPanel3").FindControl("lb_shr_ld" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1] && action == "audit") { //对于公司领导,审计通过后才能审核 string check_sjyj = "select distinct CRD_PSYJ FROM VIEW_TBCR_CONTRACTVIEW_AUDIT WHERE CRD_ID='" + id + "'and CRD_DEP<>'01' AND CRD_PSYJ='0'"; DataTable dt_check_sjyj = DBCallCommon.GetDTUsingSqlText(check_sjyj); if ((Session["UserDeptID"].ToString() == "01" && dt_check_sjyj.Rows.Count == 0) || Session["UserDeptID"].ToString() != "01") { pal.Enabled = true; tbyj.BorderColor = System.Drawing.Color.Orange; tbyj.Focus(); LbtnYes.Visible = true; LbtnNO.Visible = true; } else { pal.Enabled = false; } } else { pal.Enabled = false; } } }
private void ExeSQL(int j) { List <string> strb_sql = new List <string>(); string psyj = ""; string txt_yj = ""; //意见文本框中的文字 string riqi = DateTime.Now.ToString("yyyy-MM-dd"); //评审时间 string username = Session["UserName"].ToString(); //评审人是部门负责人 string sqlbmfzr = "select DISTINCT ST_NAME,DEP_NAME,CRD_ID,CRD_PID,CRD_PSYJ,CRD_NOTE,CRD_SHSJ" + " ,CRD_DEP from VIEW_TBCR_CONTRACTVIEW_AUDIT where CRD_ID='" + id + "'and CRD_PIDTYPE ='1' and CRD_DEP!='01'"; DataTable dt_bmfzr = DBCallCommon.GetDTUsingSqlText(sqlbmfzr); for (int i = 0; i < dt_bmfzr.Rows.Count; i++) { Label lb = (Label)TabContainer1.FindControl("TabPanel2").FindControl("lb_shr" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { TextBox txt_shyj = (TextBox)TabContainer1.FindControl("TabPanel2").FindControl("txt_shyj" + i.ToString()); txt_yj = txt_shyj.Text; } } //评审人是公司领导 string sqlgsld = "select DISTINCT ST_NAME,DEP_NAME,CRD_ID,CRD_PID,CRD_PSYJ,CRD_NOTE,CRD_SHSJ" + " ,CRD_DEP from VIEW_TBCR_CONTRACTVIEW_AUDIT where CRD_ID='" + id + "'and CRD_PIDTYPE ='1' and CRD_DEP='01'"; DataTable dt_gsld = DBCallCommon.GetDTUsingSqlText(sqlgsld); for (int i = 0; i < dt_gsld.Rows.Count; i++) { Label lb = (Label)TabContainer1.FindControl("TabPanel3").FindControl("lb_shr_ld" + i.ToString()); string[] lb_text = lb.Text.Trim().Split(':'); if (username == lb_text[1]) { TextBox txt_shyj = (TextBox)TabContainer1.FindControl("TabPanel3").FindControl("txt_shyj_ld" + i.ToString()); txt_yj = txt_shyj.Text; } } if (j == 1) { if (txt_yj == "") { if (Session["UserDeptID"].ToString() != "01") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('驳回意见不能为空!');", true); return; } psyj = txt_yj; } else { psyj = txt_yj; } } else { if (txt_yj == "") { psyj = "同意"; } else { psyj = txt_yj; } } string sql = "update TBCR_CONTRACTREVIEW_DETAIL set CRD_PSYJ='" + j.ToString() + "',CRD_NOTE='" + psyj + "'" + " ,CRD_SHSJ='" + riqi + "' where CRD_ID='" + id + "' and CRD_PID='" + Session["UserID"].ToString() + "'"; strb_sql.Add(sql); //修改合同评审状态 评审完成2,已驳回3, //根据合同类型来修改相应的表 string tbname = type == "8" ? "" : "TBCR_CONTRACTREVIEW"; if (j == 1) //不同意 { string str_back = ""; if (type == "8") { str_back = "update TBCM_ADDCON set CON_PSZT='3' where CR_ID='" + id + "'"; } else { str_back = "update TBCR_CONTRACTREVIEW set CR_PSZT='3' where CR_ID='" + id + "'"; } strb_sql.Add(str_back); //发送邮件通知——审批驳回 SendMail("no"); } else //同意 如果除此人以外其他人都同意了,则审批状态改为审批完成 { string str_check_over = "select * from TBCR_CONTRACTREVIEW_DETAIL where CRD_ID='" + id + "'" + " and CRD_PID!='" + Session["UserID"].ToString() + "' and CRD_PSYJ!='2'"; DataTable dt_check = DBCallCommon.GetDTUsingSqlText(str_check_over); if (dt_check.Rows.Count == 0) { string str_over = ""; if (type == "8") { str_over = "update TBCM_ADDCON set CON_PSZT='2' where CR_ID='" + id + "'"; } else { str_over = "update TBCR_CONTRACTREVIEW set CR_PSZT='2' where CR_ID='" + id + "'"; } strb_sql.Add(str_over); //审批完成后将对应的合同签订日期改为评审通过日期 if (type != "8") { string str_updatevalidate = "update TBPM_CONPCHSINFO set PCON_FILLDATE ='" + riqi + "' where PCON_REVID='" + id + "'"; strb_sql.Add(str_updatevalidate); } //发送邮件通知——审批通过 SendMail("yes"); } } DBCallCommon.ExecuteTrans(strb_sql); string sqlcomcount = "select distinct(CRD_PID) from View_TBCR_View_Detail_ALL where CRD_PID in ('1','2') and CR_PSZT in ('1','2') and CRD_PIDTYPE='1'and CR_ID='" + id + "'"; DataTable dtcomcount = DBCallCommon.GetDTUsingSqlText(sqlcomcount); string sqlcom = "select CR_ID from View_TBCR_View_Detail_ALL where CRD_PSYJ='0' and CRD_PID in ('1','2') and CR_PSZT in ('1','2') and CRD_PIDTYPE='1'and CR_ID='" + id + "'"; DataTable dtcom = DBCallCommon.GetDTUsingSqlText(sqlcom); if (dtcom.Rows.Count > 0) { if (dtcomcount.Rows.Count == dtcom.Rows.Count) { string sqldep = "select distinct(CR_ID) from View_TBCR_View_Detail_ALL where CRD_PSYJ='0' and CRD_PID not in ('1','2') and CR_PSZT in ('1','2') and CRD_PIDTYPE='1'and CR_ID='" + id + "'"; DataTable dtdep = DBCallCommon.GetDTUsingSqlText(sqldep); if (dtdep.Rows.Count == 0) { string _body = "合同审批任务:" + "\r\n合同号:" + lb_HTBH.Text.Trim() + "\r\n项目名称:" + lb_XMMC.Text.Trim(); string _subject = "您有新的【合同】需要审批,请及时处理"; string _emailto = ""; for (int k = 0; k < dtcom.Rows.Count; k++) { _emailto = DBCallCommon.GetEmailAddressByUserID(dtcomcount.Rows[k][0].ToString()); DBCallCommon.SendEmail(_emailto, null, null, _subject, _body); } } } } }
private void ExeSQL(int j) { List <string> str_sql = new List <string>(); string sql = ""; string psyj = ""; string txt_yj = ""; //意见文本框中的文字 string riqi = DateTime.Now.ToString("yyyy-MM-dd"); //评审时间 //评审人意见 sql = "select * from TBCM_PLAN where ID='" + id + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); int psr = 0; int n = 0; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; n = int.Parse(dr["CM_PSJB"].ToString()); for (int i = 0; i < n; i++) { Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i); TextBox txt_shyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i); HiddenField hd = (HiddenField)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shrid" + i.ToString()); if (UserID.Value == hd.Value) { txt_yj = txt_shyj.Text; psr = i + 1; break; } } //修改评审状态 评审完成2,已驳回3, //根据类型来修改相应的表 if (j == 2) { if (txt_yj == "") { psyj = "同意"; } else { psyj = txt_yj; } //2016.9.20 //评审完之后,邮件提示下一个人有计划单需要审批 //if (psr < 3 && psr < n) //{ // DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_PS" + (psr + 1)].ToString()), new List<string>(), new List<string>(), "经营计划单评审", "您有经营计划单需要评审!"); //} if (psr == n && dt.Rows[0]["CM_SPSTATUS"].ToString() == "1") { sql = "update TBCM_PLAN set CM_SPSTATUS='2' where ID='" + id + "'"; DBCallCommon.ExeSqlText(sql); // str_sql.Add(sql); #region 存入各表 //计划单审核通过插入销售合同 string jhdtype = ""; string sqlstid = "select TSA_ID from TBPM_DETAIL where CM_CONTR='" + CM_CONTR.Text.Trim() + "'"; DataTable stiddata = DBCallCommon.GetDTUsingSqlText(sqlstid); if (stiddata.Rows.Count > 0) { jhdtype = "2"; } else { jhdtype = "-1"; } string sqlshdata = "select a.*,b.CM_REFER as TSA_TYPENAME from TBCM_BASIC as a left join TBCM_TYPE as b on a.TSA_TYPE=b.CM_TYPE where ID='" + id + "' order by a.TSA_ID,a.CM_ID asc"; DataTable shdata = DBCallCommon.GetDTUsingSqlText(sqlshdata); for (int i = 0; i < shdata.Rows.Count; i++) { string TSA_ID = shdata.Rows[i]["TSA_ID"].ToString(); string TSA_ENGNAME = shdata.Rows[i]["TSA_ENGNAME"].ToString(); string TSA_MAP = shdata.Rows[i]["TSA_MAP"].ToString(); string TSA_NUMBER = shdata.Rows[i]["TSA_NUMBER"].ToString(); string TSA_UNIT = shdata.Rows[i]["TSA_UNIT"].ToString(); string TSA_MATERIAL = shdata.Rows[i]["TSA_MATERIAL"].ToString(); string sqltext = "insert into TBPM_DETAIL(CM_CONTR,TSA_ID,CM_PROJ,CM_YZHTH,CM_ENGNAME,CM_MATERIAL,CM_MAP,CM_NUMBER,CM_UNIT,CM_JHDTYPE) values('" + CM_CONTR.Text.Trim() + "','" + TSA_ID.Trim() + "','" + CM_PROJ.Text.Trim() + "','" + CM_DFCONTR.Text.Trim() + "','" + TSA_ENGNAME.Trim() + "','" + TSA_MATERIAL.Trim() + "','" + TSA_MAP.Trim() + "','" + TSA_NUMBER.Trim() + "','" + TSA_UNIT.Trim() + "','" + jhdtype + "')"; str_sql.Add(sqltext); } //string cs = "select CM_PID from TBCM_PSVIEW where CM_ID='" + id + "' and CM_PIDTYPE='1'"; //DataTable cs_dt = DBCallCommon.GetDTUsingSqlText(cs); //List<string> cs_list = new List<string>(); //for (int i = 0; i < cs_dt.Rows.Count; i++) //{ // cs_list.Add(DBCallCommon.GetEmailAddressByUserID(cs_dt.Rows[i][0].ToString())); //} //for (int i = 0; i < cs_list.Count; i++) //{ // DBCallCommon.SendEmail(cs_list[i], new List<string>(), new List<string>(), "经营计划单查看", "您有经营计划单需要查看!,合同号为" + CM_CONTR.Text); //} string engname = string.Empty; sql = "select TSA_ID,TSA_ENGNAME,TSA_TYPE from TBCM_BASIC where ID='" + id + "' order by TSA_ID"; DataTable task = DBCallCommon.GetDTUsingSqlText(sql); List <string> liststr = new List <string>(); string fhdate = dt.Rows[0]["CM_FHDATE"].ToString(); string dhpart = dt.Rows[0]["CM_COMP"].ToString(); if (task.Rows.Count > 0) { //for (int i = 0; i < task.Rows.Count; i++) //{ // liststr.Contains(task.Rows[i][0].ToString()); //} //liststr = liststr.Distinct<string>().ToList(); liststr.Add(task.Rows[0][0].ToString()); string[] engs; for (int i = 0; i < task.Rows.Count; i++) { if (liststr.Contains(task.Rows[i][0].ToString())) { engname += "/" + task.Rows[i]["TSA_ENGNAME"].ToString(); } else { liststr.Add(task.Rows[i][0].ToString()); engs = engname.Substring(1).Split('/'); if (engs.Length > 3) { engname = "/" + engs[0] + "/" + engs[1] + "/" + engs[2] + "/..."; } str_sql.Add(string.Format("insert into TBCB_BMCONFIRM(TASK_ID,PRJ,ENG,HT_ID) values('{0}','{1}','{2}','{3}')", task.Rows[i - 1][0], CM_PROJ.Text, engname.Substring(1), CM_CONTR.Text)); str_sql.Add(string.Format("insert into TBPM_TCTSASSGN(ID,TSA_ID,TSA_PJID,TSA_ENGNAME,TSA_BUYER,TSA_CONTYPE,TSA_DELIVERYTIME,TSA_DESIGNCOM) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", id, task.Rows[i - 1][0], CM_CONTR.Text, engname.Substring(1), CM_COMP.Text, task.Rows[i - 1]["TSA_TYPE"].ToString(), fhdate, dhpart)); str_sql.Add(string.Format("insert into TBMP_MANUTSASSGN(MTA_ID,MTA_PJID,MTA_ENGNAME) values('{0}','{1}','{2}')", task.Rows[i - 1][0], CM_CONTR.Text, engname.Substring(1))); str_sql.Add(string.Format("insert into TBQM_QTSASSGN(QSA_ENGID) values('{0}')", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANTOTAL(MP_CODE,MP_PJID,MP_PJNAME,MP_ENGNAME,MP_STARTDATE,MP_DELIVERYDATE) values('{0}','{1}','{2}','{3}','{4}','{5}')", task.Rows[i - 1][0], CM_CONTR.Text, CM_PROJ.Text, engname.Substring(1), DateTime.Now.ToString("yyyy-MM-dd"), fhdate)); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','材料计划','技术准备',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','制作明细','技术准备',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','成品入库','生产周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','非定尺板','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','定尺板','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','耐磨板','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','型材','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','圆钢','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','标准件','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','铸件','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','锻件','采购周期',0)", task.Rows[i - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','采购成品','采购周期',0)", task.Rows[i - 1][0])); engname = "/" + task.Rows[i]["TSA_ENGNAME"].ToString(); } } engs = engname.Substring(1).Split('/'); if (engs.Length > 3) { engname = "/" + engs[0] + "/" + engs[1] + "/" + engs[2] + "/..."; } str_sql.Add(string.Format("insert into TBCB_BMCONFIRM(TASK_ID,PRJ,ENG,HT_ID) values('{0}','{1}','{2}','{3}')", task.Rows[task.Rows.Count - 1][0], CM_PROJ.Text, engname.Substring(1), CM_CONTR.Text)); str_sql.Add(string.Format("insert into TBPM_TCTSASSGN(ID,TSA_ID,TSA_PJID,TSA_ENGNAME,TSA_BUYER,TSA_CONTYPE,TSA_DELIVERYTIME,TSA_DESIGNCOM) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", id, task.Rows[task.Rows.Count - 1][0], CM_CONTR.Text, engname.Substring(1), CM_COMP.Text, task.Rows[task.Rows.Count - 1]["TSA_TYPE"].ToString(), fhdate, dhpart)); str_sql.Add(string.Format("insert into TBMP_MANUTSASSGN(MTA_ID,MTA_PJID,MTA_ENGNAME) values('{0}','{1}','{2}')", task.Rows[task.Rows.Count - 1][0], CM_CONTR.Text, engname.Substring(1))); str_sql.Add(string.Format("insert into TBQM_QTSASSGN(QSA_ENGID) values('{0}')", task.Rows[task.Rows.Count - 1][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANTOTAL(MP_CODE,MP_PJID,MP_PJNAME,MP_ENGNAME,MP_STARTDATE,MP_DELIVERYDATE) values('{0}','{1}','{2}','{3}','{4}','{5}')", task.Rows[task.Rows.Count - 1][0], CM_CONTR.Text, CM_PROJ.Text, engname.Substring(1), DateTime.Now.ToString("yyyy-MM-dd"), fhdate));// str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','材料计划','技术准备',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','制作明细','技术准备',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','成品入库','生产周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','非定尺板','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','定尺板','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','耐磨板','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','型材','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','圆钢','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','标准件','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','铸件','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','锻件','采购周期',0)", task.Rows[0][0])); str_sql.Add(string.Format("insert into TBMP_MAINPLANDETAIL(MP_ENGID,MP_PLNAME,MP_TYPE,MP_STATE) values('{0}','采购成品','采购周期',0)", task.Rows[0][0])); } #endregion } //评审完之后,邮件提示下一个人有计划单需要审批,全部结束,发送抄送人 if (psr < 3 && psr < n) { DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_PS" + (psr + 1)].ToString()), new List <string>(), new List <string>(), "经营计划单评审", "您有经营计划单需要评审!"); } if (psr == n && dt.Rows[0]["CM_SPSTATUS"].ToString() == "1") { string cs = "select CM_PID from TBCM_PSVIEW where CM_ID='" + id + "' and CM_PIDTYPE='1'"; DataTable cs_dt = DBCallCommon.GetDTUsingSqlText(cs); List <string> cs_list = new List <string>(); for (int i = 0; i < cs_dt.Rows.Count; i++) { cs_list.Add(DBCallCommon.GetEmailAddressByUserID(cs_dt.Rows[i][0].ToString())); } for (int i = 0; i < cs_list.Count; i++) { DBCallCommon.SendEmail(cs_list[i], new List <string>(), new List <string>(), "经营计划单查看", "您有经营计划单需要查看!,合同号为" + CM_CONTR.Text); } } } else //不同意 { if (txt_yj == "") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('驳回意见不能为空!');", true); return; } else { psyj = txt_yj; } sql = "update TBCM_PLAN set CM_SPSTATUS='3' where ID='" + id + "'"; //sql = "update TBCM_PLAN set CM_SPSTATUS='3' where ID='"+id+"'"; str_sql.Add(sql); DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(dt.Rows[0]["CM_MANCLERK"].ToString()), new List <string>(), new List <string>(), "经营计划单被驳回", "您提交的经营计划单被驳回!请修改后再次提交"); } sql = string.Format("update TBCM_PLAN set CM_PSYJ{0}='{1}',CM_PSSJ{0}='{2}',CM_NOTE{0}='{3}' where ID='{4}'", psr, j, riqi, psyj, id); str_sql.Add(sql); DBCallCommon.ExecuteTrans(str_sql); } }