//正常情况下不允许删除仓位信息
protected void Delete_Click(object sender, EventArgs e)
{
string sql = "";
List <string> sqllist = new List <string>();
foreach (RepeaterItem LabelID in Repeater1.Items)
{
CheckBox chk = (CheckBox)LabelID.FindControl("CheckBox1");
if (chk.Checked)
{
string id = ((Label)LabelID.FindControl("LabelID")).Text;
sql = "DELETE FROM TBWS_LOCATION WHERE WL_ID='" + id + "'";
sqllist.Add(sql);
}
}
if (sqllist.Count > 0)
{
DBCallCommon.ExecuteTrans(sqllist);
GetData();
}
}
} //删除功能建议在使用时隐藏
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> sql = new List <string>();
string sqltext = "";
foreach (RepeaterItem LabelID in rptProNumCost.Items)
{
System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)LabelID.FindControl("CKBOX_SELECT");
if (chk.Checked)
{
string Id = ((System.Web.UI.WebControls.Label)LabelID.FindControl("lblId")).Text;
sqltext = "delete FROM TBDS_KaoHeTotal WHERE Id='" + Id + "'";
sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(sql);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('删除成功！！！');", true);
bindGrid();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> sql = new List <string>();
string sqltext = "";
foreach (RepeaterItem LabelID in Det_Repeater.Items)
{
System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)LabelID.FindControl("CKBOX_SELECT");
if (chk.Checked)
{
string Id = ((HtmlInputHidden)LabelID.FindControl("hidId")).Value;
sqltext = "delete FROM TBDS_KaoHe_JXDetail WHERE Id='" + Id + "'";
sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(sql);
Response.Write("<script>alert('删除成功！')</script>");
ShowData(hidConext.Value);
CaculZongGZ(hidConext.Value);
}
//删除功能建议在使用时隐藏
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> sql = new List <string>();
string sqlifsc = "select * from OM_GZHSB where GZ_YEARMONTH='" + dplYear.SelectedValue.ToString().Trim() + "-" + dplMoth.SelectedValue.ToString().Trim() + "' and OM_GZSCBZ='1'";
System.Data.DataTable dtifsc = DBCallCommon.GetDTUsingSqlText(sqlifsc);
if (dtifsc.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该月已生成工资，不能删除！！！');", true);
return;
}
string sqltext = "";
foreach (RepeaterItem LabelID in rptProNumCost.Items)
{
System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)LabelID.FindControl("CKBOX_SELECT");
if (chk.Checked)
{
string check = ((System.Web.UI.WebControls.Label)LabelID.FindControl("lbLD_STID")).Text;
sqltext = "delete FROM OM_LDBX WHERE LD_STID='" + check + "' and LD_DATE='" + dplYear.SelectedValue.ToString().Trim() + "-" + dplMoth.SelectedValue.ToString().Trim() + "'";
sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(sql);
UCPaging1.CurrentPage = 1;
this.InitVar();
this.bindGrid();
}
protected void btn_Audit_Click(object sender, EventArgs e)
{
//邮件提醒参数
string subject = "";
string body_title = "";
string sendto = "";
if (ViewState["action"].ToString() == "view" || ViewState["action"].ToString() == "Editor") //查看 ，提交到审批
{
List <string> sqlstr = new List <string>();
if (lbl_spzt.Text == "0")
{
if (check_audit_Per()) //检查是否选择了审核人
{
string pa_code = tb_doc.Text.Trim();
string pa_fir_per = firstid.Value;
string pa_sec_per = secondid.Value;
string pa_thi_per = thirdid.Value;
//审核人不能相同
if (((pa_fir_per != pa_sec_per) && (pa_sec_per != pa_thi_per)) || ((pa_sec_per == "") && (pa_thi_per == "")))
{
string sqltext = "insert into View_TBPM_SCWXAUDIT (PM_DocuNum,Fir_Per,Fir_Jg,Sec_Per,Sec_Jg,Thi_Per,Thi_Jg,Rank)" +
" values ('" + pa_code + "','" + pa_fir_per + "','0','" + pa_sec_per + "','0','" + pa_thi_per + "','0','" + rblSHDJ.SelectedIndex.ToString() + "')";
sqlstr.Add(sqltext);
string sqlupdatezt = "update TBPM_SCWXRVW set PM_SPZT='1' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sqlstr.Add(sqlupdatezt);
DBCallCommon.ExecuteTrans(sqlstr);
//制单人提交后向第一个审批人发送邮件
subject = "您有新的生产外协计划需要审批——" + tb_doc.Text.ToString();
sendto = txt_first.Text.Trim();
this.SendMail(subject, body_title, sendto);
Response.Redirect("../PM_Data/PM_Xie_Audit_List.aspx");
// Response.Redirect("../PM_Data/PM_Xie_union.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('审核人不能相同！');", true); return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择审核人！');", true); return;
}
}
else if (lbl_spzt.Text == "4")
{
if (check_audit_Per()) //检查是否选择了审核人
{
string pa_code = tb_doc.Text.Trim();
string pa_fir_per = firstid.Value;
string pa_sec_per = secondid.Value;
string pa_thi_per = thirdid.Value;
//审核人不能相同
if (((pa_fir_per != pa_sec_per) && (pa_sec_per != pa_thi_per)) || ((pa_sec_per == "") && (pa_thi_per == "")))
{
string update1 = "update View_TBPM_SCWXAUDIT set Fir_Per='" + pa_fir_per + "',Fir_Jg='0',Fir_Yj='',Fir_Sj='',Sec_Per='" + pa_sec_per + "',Sec_Jg='0'" +
" ,Sec_Yj='',Sec_Sj='',Thi_Per='" + pa_thi_per + "',Thi_Jg='0',Thi_Yj='',Thi_Sj='',Rank='" + rblSHDJ.SelectedIndex.ToString() + "' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
string update2 = "update TBPM_SCWXRVW set PM_SPZT='1' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sqlstr.Add(update1);
sqlstr.Add(update2);
DBCallCommon.ExecuteTrans(sqlstr);
//制单人提交后向第一个审批人发送邮件
subject = "驳回后的生产外协计划已修改，请重新审批——" + tb_doc.Text.ToString();
sendto = txt_first.Text.Trim();
this.SendMail(subject, body_title, sendto);
Response.Redirect("../PM_Data/PM_Xie_Audit_List.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('审核人不能相同！');", true); return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择审核人！');", true); return;
}
}
}
else if (ViewState["action"].ToString() == "audit") //审批 ，提交审批意见
{
string spyj = ""; // 审批意见
string spsj = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); //审批时间
string spjg = ""; //审批结果，0：未审批，1：同意，2：拒绝
string set_text = ""; //更新内容
//记录审批人是第几级
string submit_type = "";
if (Session["UserID"].ToString() == firstid.Value.ToString())
{
spyj = first_opinion.Text.ToString();
spjg = rbl_first.SelectedValue.ToString();
set_text = "set Fir_Yj='" + spyj + "',Fir_Sj='" + spsj + "',Fir_Jg='" + spjg + "' ";
submit_type = "1";
}
else if (Session["UserID"].ToString() == secondid.Value.ToString())
{
spyj = second_opinion.Text.ToString();
spjg = rbl_second.SelectedValue.ToString();
set_text = "set Sec_Yj='" + spyj + "',Sec_Sj='" + spsj + "',Sec_Jg='" + spjg + "' ";
submit_type = "2";
}
else if (Session["UserID"].ToString() == thirdid.Value.ToString())
{
spyj = third_opinion.Text.ToString();
spjg = rbl_third.SelectedValue.ToString();
set_text = "set Thi_Yj='" + spyj + "',Thi_Sj='" + spsj + "',Thi_Jg='" + spjg + "' ";
submit_type = "3";
}
if (spjg == "" || spjg == null)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择【同意】或【不同意】！');", true); return;
}
List <string> sqlstr = new List <string>();
string sqltext = "update TBPM_SCWXAUDIT " + set_text + " where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sqlstr.Add(sqltext);
//更新审批状态，0：保存；1：提交未审批；2：审批中；3：已通过；4：已驳回；
string spzt = (spjg == "1") ? "2" : "4";
string sqlupdatezt = "update TBPM_SCWXRVW set PM_SPZT='" + spzt + "'where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sqlstr.Add(sqlupdatezt);
DBCallCommon.ExecuteTrans(sqlstr);
//如果同意则向下一级审批人发送邮件通知
if (spjg == "1")
{
switch (submit_type)
{
case "1":
subject = "您有新的生产外协计划需要审批，请即时处理——" + tb_doc.Text.ToString();
sendto = txt_second.Text.Trim();
break;
case "2":
subject = "您有新的生产外协计划需要审批，请即时处理——" + tb_doc.Text.ToString();
sendto = txt_third.Text.Trim();
break;
}
if (sendto != "")
{
this.SendMail(subject, body_title, sendto);
}
}
//如果驳回则向制单人发送邮件通知
else if (spjg == "2")
{
subject = "生产外协计划已驳回——" + tb_doc.Text.ToString();
body_title = "您提交的生产外协计划申请于" + DateTime.Now.ToString() + "被驳回";
sendto = tb_executor.Text.Trim();
this.SendMail(subject, body_title, sendto);
List <string> list = new List <string>();
//驳回状态改变
foreach (RepeaterItem reitem in tbpc_otherpurbill_lookRepeater.Items)
{
string msid = ((Label)reitem.FindControl("lb_zj")).Text.ToString();
int docnum = Convert.ToInt32(tb_doc.Text);
string sqltext01 = "update TBPM_WXDetail set MS_scwaixie='3' where MS_ID='" + msid + "'and MS_WSID='" + docnum + "' ";
list.Add(sqltext01);
//string sqltext02 = " update TBMP_TASKDQO set MS_scwaixie='3' where MS_ID='" + msid + "'";
//list.Add(sqltext02);
}
DBCallCommon.ExecuteTrans(list);
}
//检查是否全部同意，如果全部同意则改为3。根据审核等级判断，只判断最后一个是否同意即可
bool YesOrNo = false;
string sqlJG = "select * from TBPM_SCWXAUDIT where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlJG);
if (dt.Rows.Count > 0)
{
switch (rblSHDJ.SelectedValue.ToString())
{
case "1":
if (dt.Rows[0]["Fir_Jg"].ToString() == "1")
{
YesOrNo = true;
}
break;
case "2":
if (dt.Rows[0]["Sec_Jg"].ToString() == "1")
{
YesOrNo = true;
}
break;
case "3":
if (dt.Rows[0]["Thi_Jg"].ToString() == "1")
{
YesOrNo = true;
}
break;
}
}
if (YesOrNo)
{
string strupdatezp2 = "update TBPM_SCWXRVW set PM_SPZT='3' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sqlstr.Clear();
sqlstr.Add(strupdatezp2);
foreach (RepeaterItem LabelID in tbpc_otherpurbill_lookRepeater.Items)
{
Label lb_zj = ((Label)LabelID.FindControl("lb_zj"));
int docnum = Convert.ToInt32(tb_doc.Text);
//strupdatezp2 = "update TBMP_TASKDQO set MS_scwaixie='4' where MS_ID='" + lb_zj.Text.Trim() + "' and MS_PID='" + tb_pid.Text.ToString() + "' ";
//sqlstr.Add(strupdatezp2);
strupdatezp2 = "update TBPM_WXDetail set MS_scwaixie='4' where MS_ID='" + lb_zj.Text.Trim() + "' and MS_PID='" + tb_pid.Text.ToString() + "'and MS_WSID='" + docnum + "' ";
sqlstr.Add(strupdatezp2);
}
DBCallCommon.ExecuteTrans(sqlstr);
}
Response.Redirect("../PM_Data/PM_Xie_Audit_List.aspx");
//Response.Write("<script>alert('提交成功！！！');window.close();</script>");
}
}
