/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_OnClick(object sender, EventArgs e)
{
if (ddlYear.SelectedIndex == 0 || ddlMoth.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择年月！');", true);
return;
}
string sqlifsc = "select * from OM_GZHSB where GZ_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.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;
}
if (action == "update")
{
List <string> sqllist = new List <string>();
sqllist.Clear();
sqllist.Add("update OM_GZQD set QD_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "',QD_QFBS='" + txtQD_QuFen.Text.Trim() + "', QD_JCGZ=" + CommonFun.ComTryDecimal(txtQD_JCGZ.Text.Trim()) + ", QD_GZGL=" + CommonFun.ComTryDecimal(txtQD_GZGL.Text.Trim()) + ", QD_GDGZ=" + CommonFun.ComTryDecimal(txtQD_GDGZ.Text.Trim()) + ", QD_JXGZ=" + CommonFun.ComTryDecimal(txtQD_JXGZ.Text.Trim()) + ", QD_JiangLi=" + CommonFun.ComTryDecimal(txtQD_JiangLi.Text.Trim()) + ", QD_BingJiaGZ=" + CommonFun.ComTryDecimal(txtQD_BingJiaGZ.Text.Trim()) + ", QD_JiaBanGZ=" + CommonFun.ComTryDecimal(txtQD_JiaBanGZ.Text.Trim()) + ",QD_BFJB=" + CommonFun.ComTryDecimal(txtQD_BFJB.Text.Trim()) + ",QD_ZYBF=" + CommonFun.ComTryDecimal(txtQD_ZYBF.Text.Trim()) + ",QD_BFZYB=" + CommonFun.ComTryDecimal(txtQD_BFZYB.Text.Trim()) + ",QD_NianJiaGZ=" + CommonFun.ComTryDecimal(txtQD_NianJiaGZ.Text.Trim()) + ",QD_YKGW=" + CommonFun.ComTryDecimal(txtQD_YKGW.Text.Trim()) + ",QD_TZBF=" + CommonFun.ComTryDecimal(txtQD_TZBF.Text.Trim()) + ",QD_TZBK=" + CommonFun.ComTryDecimal(txtQD_TZBK.Text.Trim()) + ",QD_QTFY=" + CommonFun.ComTryDecimal(txtQD_QTFY.Text.Trim()) + ",QD_JTBT=" + CommonFun.ComTryDecimal(txtQD_JTBT.Text.Trim()) + ",QD_FSJW=" + CommonFun.ComTryDecimal(txtQD_FSJW.Text.Trim()) + ",QD_CLBT=" + CommonFun.ComTryDecimal(txtQD_CLBT.Text.Trim()) + ",QD_YLBX=" + CommonFun.ComTryDecimal(txtQD_YLBX.Text.Trim()) + ",QD_SYBX=" + CommonFun.ComTryDecimal(txtQD_SYBX.Text.Trim()) + ",QD_YiLiaoBX=" + CommonFun.ComTryDecimal(txtQD_YiLiaoBX.Text.Trim()) + ",QD_DEJZ=" + CommonFun.ComTryDecimal(txtQD_DEJZ.Text.Trim()) + ",QD_BuBX=" + CommonFun.ComTryDecimal(txtQD_BuBX.Text.Trim()) + ",QD_GJJ=" + CommonFun.ComTryDecimal(txtQD_GJJ.Text.Trim()) + ",QD_BGJJ=" + CommonFun.ComTryDecimal(txtQD_BGJJ.Text.Trim()) + ",QD_KOUXIANG=" + CommonFun.ComTryDecimal(txtQD_KOUXIANG.Text.Trim()) + ",QD_ShuiDian=" + CommonFun.ComTryDecimal(txtQD_ShuiDian.Text.Trim()) + ",QD_GeShui=" + CommonFun.ComTryDecimal(txtQD_GeShui.Text.Trim()) + ",QD_NOTE='" + tbnote.Text.Trim() + "' where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + "");
DBCallCommon.ExecuteTrans(sqllist);
updategeshui();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('修改成功！');", true);
Response.Redirect("OM_GZQDJS.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <string> sql_list = new List <string>();
for (int i = 0; i < rptProNumCost.Items.Count; i++)
{
string Id = ((System.Web.UI.WebControls.Label)rptProNumCost.Items[i].FindControl("lblId")).Text.Trim();
string scoreHp = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtScoreHP")).Text.Trim();
string txtlScoreLD = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtlScoreLD")).Text.Trim();
string lblScoreZong = ((HtmlInputHidden)rptProNumCost.Items[i].FindControl("hidScoreZong")).Value.Trim();
string txtNote = ((System.Web.UI.WebControls.TextBox)rptProNumCost.Items[i].FindControl("txtNote")).Text.Trim();
//Id, Kh_Year, Kh_Month, Kh_ScoreHP, Kh_ScoreLD, Kh_ScoreTotal, Kh_BL, Kh_Id, Kh_BeiZhu, ST_NAME, ST_SEQUEN, ST_GENDER, DEP_NAME, POSITION, ST_WORKNO
string sqlText = "update TBDS_KaoHeTotal set Kh_ScoreHP=" + CommonFun.ComTryDecimal(scoreHp) + ",Kh_ScoreLD=" + CommonFun.ComTryDecimal(txtlScoreLD) + ",Kh_ScoreTotal=" + CommonFun.ComTryDecimal(lblScoreZong) + ",Kh_BeiZhu='" + txtNote + "' where Id='" + Id + "'";
sql_list.Add(sqlText);
}
//更新
DBCallCommon.ExecuteTrans(sql_list);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('数据已保存！！！');", true);
sql_list.Clear();
bindGrid();
} //删除功能建议在使用时隐藏
//保存
protected void btnsave_Click(object sender, EventArgs e)
{
List <string> listsql = new List <string>();
string sqltext = "";
string shenpibh = "";
if (txt_content.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请输入权限变更内容！');", true);
return;
}
if (action == "add")
{
shenpibh = "JP" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim() + "" + Session["UserID"].ToString().Trim() + "";
}
else
{
shenpibh = auditno;
}
if (action == "add")
{
sqltext = "insert into PowerContent(contentno,stid,stname,fankui,powercontent) values('" + shenpibh + "','" + stid.Text.Trim() + "','" + stname.Text.Trim() + "','否','" + txt_content.Text.Trim() + "')";
listsql.Add(sqltext);
sqltext = "insert into AuditNew(auditno,audittype,addpername,addperid,addtime) values('" + shenpibh + "','" + audittitle.Text.Trim() + "','" + Session["UserName"].ToString().Trim() + "','" + Session["UserID"].ToString().Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "')";//不需要修改
listsql.Add(sqltext);
}
else if (action == "edit")
{
sqltext = "update PowerContent set fankui='否',powercontent='" + txt_content.Text.Trim() + "' where contentno='" + shenpibh + "'";
listsql.Add(sqltext);
}
DBCallCommon.ExecuteTrans(listsql);
Response.Redirect("~/OM_Data/PowerAudit.aspx?action=edit&auditno=" + shenpibh);
}
//删除房间号
protected void btnfjh_click(object sender, EventArgs e)
{
List <string> sqltextlist = new List <string>();
int num = 0;
foreach (RepeaterItem rptitem in rptsushe.Items)
{
System.Web.UI.WebControls.CheckBox CKBOX_SELECT = (System.Web.UI.WebControls.CheckBox)rptitem.FindControl("CKBOX_SELECT");
if (CKBOX_SELECT.Checked == true)
{
num++;
}
}
if (num == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择要删除的数据！');", true);
return;
}
foreach (RepeaterItem rptitem in rptsushe.Items)
{
System.Web.UI.WebControls.CheckBox CKBOX_SELECT = (System.Web.UI.WebControls.CheckBox)rptitem.FindControl("CKBOX_SELECT");
System.Web.UI.WebControls.Label housenum = (System.Web.UI.WebControls.Label)rptitem.FindControl("housenum");
if (CKBOX_SELECT.Checked == true)
{
string sqldelete1 = "delete from OM_SUSHE where housenum='" + housenum.Text.Trim() + "'";
string sqldelete2 = "delete from OM_SSDEtail where SUSHEnum='" + housenum.Text.Trim() + "'";
sqltextlist.Add(sqldelete1);
sqltextlist.Add(sqldelete2);
}
}
DBCallCommon.ExecuteTrans(sqltextlist);
UCPaging1.CurrentPage = 1;
bindrpt();
danyuangehebing();
}
protected void btnDelete_onserverclick(object sender, EventArgs e)
{
List <string> list = new List <string>();
for (int i = 0, length = rptZPJH.Items.Count; i < length; i++)
{
CheckBox cbx = (CheckBox)rptZPJH.Items[i].FindControl("cbxXuHao");
if (cbx.Checked)
{
string JH_ID = ((HiddenField)rptZPJH.Items[i].FindControl("JH_ID")).Value;
string sql = "update OM_ZPJH set JH_SFCL='b' where JH_ID=" + JH_ID;
list.Add(sql);
}
}
if (list.Count == 0)
{
Response.Write("<script>alert('请勾选一条进行处理！！！')</script>");
return;
}
try
{
DBCallCommon.ExecuteTrans(list);
}
catch
{
Response.Write("<script>alert('删除的语句出现问题，请与管理员联系！！！')</script>");
return;
}
bindrpt();
}
//任务预算编制更新
public void Repeater1_ItemCommand(object sender, RepeaterCommandEventArgs e)
{
if (e.CommandName == "change")
{
// string task_code = ((LinkButton)sender).CommandArgument + "";//获取传递的任务号
string task_code = e.CommandArgument + "";
List <string> listsql = new List <string>();
//listsql.Add(string.Format("DELETE FROM dbo.YS_TASK_BUDGET WHERE task_code='{0}';", tsaId));//删除任务预算表内的信息
listsql.Add(string.Format("DELETE FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='{0}';", task_code)); //删除历史表内的信息
//listsql.Add(string.Format("DELETE FROM dbo.YS_NODE_INSTANCE WHERE task_code='{0}';", tsaId));//删除node实例表中的信息
listsql.Add(getInsertIntoHistoryInfoTableSqltext(task_code)); //向历史表重新插入信息
// listsql.Add(getInsertIntoTaskBudgetTableSqltext(tsaId));//向任务预算表重新插入信息
//listsql.Add(string.Format("UPDATE dbo.TBPM_TCTSASSGN SET TSA_BUDGET_DATETIME=GETDATE() WHERE TSA_ID='{0}';", tsaId));//更新任务表中预算提交的时间
//DBCallCommon.ExecuteTrans(listsql);
//listsql.Clear();
//string[] ids = new string[] { ConfigurationSettings.AppSettings["BudgetEditorId"] };//配置文件中读取预算编制人id
//BudgetFlowEngine.activeFollowNode(tsaId, "0", ids);//向node实例表中插入第一个实例
//更新任务预算表
string sqlText = " SELECT TOP 1 '" + task_code + "', CM_CONTR, CM_PROJ , TSA_ENGNAME ,( SELECT BM_TUTOTALWGHT FROM TBPM_STRINFODQO WHERE BM_ZONGXU='1' AND BM_ENGID='" + task_code + "'), ( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.07%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.11%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.15%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code LIKE '01.03%'),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND (material_code LIKE '01.08%' OR material_code LIKE '01.09%')),( SELECT ISNULL(SUM(c_total_cost),0) FROM dbo.YS_MATERIAL_HISTORY_INFO WHERE task_code='" + task_code + "' AND material_code NOT LIKE '01.07%' AND material_code NOT LIKE '01.11%' AND material_code NOT LIKE '01.15%' AND material_code NOT LIKE '01.03%' AND material_code NOT LIKE '01.08%' AND material_code NOT LIKE '01.09%'), GETDATE(), 1,( SELECT TSA_CONTYPE FROM TBPM_TCTSASSGN WHERE TSA_ID='" + task_code + "' ) FROM dbo.View_TM_TaskAssign WHERE TSA_ID = '" + task_code + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
////任务预算编制更新的时间和人员以及更新的各种材料价格
listsql.Add(string.Format("UPDATE dbo.YS_TASK_BUDGET SET task_weight= '{0}',ys_ferrous_metal_dep='{1}',ys_ferrous_metal='{1}', ys_purchase_part_dep='{2}',ys_purchase_part='{2}', ys_paint_coating_dep='{3}',ys_paint_coating='{3}',ys_electrical_dep='{4}', ys_electrical='{4}', ys_casting_forging_dep='{5}',ys_casting_forging_cost='{5}',ys_othermat_cost_dep='{6}',ys_othermat_cost='{6}',change_time=GETDATE(),change_name='" + Session["UserName"] + "' WHERE task_code='{7}';", dt.Rows[0][4].ToString(), dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString(), dt.Rows[0][8].ToString(), dt.Rows[0][9].ToString(), dt.Rows[0][10].ToString(), task_code));
DBCallCommon.ExecuteTrans(listsql);
listsql.Clear();
tb = new YS_Data.Model.TaskBudget(task_code);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功!');window.location='ys_task_budget_change.aspx'", true);
}
}
protected void btnPush_OnClick(object sender, EventArgs e)
{
List <string> sqllist = new List <string>();
string sql = "UPDATE EQU_Part_Store SET State=''";
sqllist.Add(sql);
string name = "";
string Type = "";
for (int i = 0; i < Repeater1.Items.Count; i++)
{
if (((CheckBox)Repeater1.Items[i].FindControl("CheckBox1")).Checked == true)
{
name = ((Label)Repeater1.Items[i].FindControl("lblName")).Text;
Type = ((Label)Repeater1.Items[i].FindControl("lblType")).Text;
sql = "UPDATE EQU_Part_Store SET State='1' WHERE ParName='" + name + "' AND ParType='" + Type + "'";//到备件领料单界面
sqllist.Add(sql);
}
}
if (sqllist.Count < 2)
{
string alert = "<script>alert('请选择下推条目！！！')</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", alert, false);
return;
}
DBCallCommon.ExecuteTrans(sqllist);
Response.Redirect("EQU_Part_Outbill.aspx?FLAG=PUSH");
}
//审核驳回
protected void btnshreject_Click(object sender, EventArgs e)
{
List <string> sqlshbh = new List <string>();
string fpbh = txtfpbh.Text.Trim();
string sqlgetjhgzh = "select YFGJ_JHGZH from TBFM_YFFPDETAIL where YFGJ_FPID='" + fpbh + "'";
DataTable dtjhgzh = DBCallCommon.GetDTUsingSqlText(sqlgetjhgzh); //获取该发票编号的计划跟踪号
string sqlrelationshstate = "update TBFM_YFFPDETAIL set YFGJ_SHSTATE='0',YFGJ_SHRNAME='',YFGJ_SHRID='' where YFGJ_FPID='" + fpbh + "'"; //勾稽关系表状态更改
string sqltotalshstate = "update TBFM_YFFPTOTAL set YFGI_STATE='0' where YFGI_CODE='" + fpbh + "'"; //发票总表状态更改
for (int i = 0; i < dtjhgzh.Rows.Count; i++)
{
string jhgzh = dtjhgzh.Rows[i]["YFGJ_JHGZH"].ToString();
string sqljsdstate = "update PM_CPFYJSD set JS_GJSTATE='1' where JS_JHGZH='" + jhgzh + "'";
sqlshbh.Add(sqljsdstate);
}//结算单
sqlshbh.Add(sqlrelationshstate);//勾稽关系表
sqlshbh.Add(sqltotalshstate);//发票总表
DBCallCommon.ExecuteTrans(sqlshbh);
btnbaocunxg.Visible = true;
btnshpass.Visible = true;
btnshreject.Visible = false;
btngjpass.Visible = false;
btngjreject.Visible = false;
this.BindInvrpt(yfgicode);
this.BindInvHead(yfgicode);
}
//勾稽驳回
protected void btngjreject_Click(object sender, EventArgs e)
{
List <string> sqlgjbh = new List <string>();
string gjyear = DateTime.Now.Year.ToString();
string gjmonth = DateTime.Now.Month.ToString();
string gjdate = DateTime.Now.ToString("yyyy-MM-dd");
if (Convert.ToInt32(gjmonth) < 10)
{
gjmonth = "0" + gjmonth;
}
string fpbh = txtfpbh.Text.Trim();
string sqlgetjhgzh = "select YFGJ_JHGZH from TBFM_YFFPDETAIL where YFGJ_FPID='" + fpbh + "'";
DataTable dtjhgzh = DBCallCommon.GetDTUsingSqlText(sqlgetjhgzh); //获取该发票编号的计划跟踪号
string sqlrelationshstate = "update TBFM_YFFPDETAIL set YFGJ_MONTH='',YFGJ_YEAR='',YFGJ_GJDATE='',YFGJ_GJRNAME='',YFGJ_GJRID='' where YFGJ_FPID='" + fpbh + "'"; //勾稽关系表时间信息更改
string sqltotalshstate = "update TBFM_YFFPTOTAL set YFGI_GJFLAG='0' where YFGI_CODE='" + fpbh + "'"; //发票总表状态更改
for (int i = 0; i < dtjhgzh.Rows.Count; i++)
{
string jhgzh = dtjhgzh.Rows[i]["YFGJ_JHGZH"].ToString();
string sqljsdstate = "update PM_CPFYJSD set JS_GJSTATE='2' where JS_JHGZH='" + jhgzh + "'";
sqlgjbh.Add(sqljsdstate);
}//结算单
sqlgjbh.Add(sqlrelationshstate);//勾稽关系表
sqlgjbh.Add(sqltotalshstate);//发票总表
DBCallCommon.ExecuteTrans(sqlgjbh);
btnbaocunxg.Visible = false;
btnshpass.Visible = false;
btnshreject.Visible = true;
btngjpass.Visible = true;
btngjreject.Visible = false;
this.BindInvrpt(yfgicode);
this.BindInvHead(yfgicode);
}
public void BuBJ()
{
List <string> sqllist = new List <string>();
string data = Request.Form["data"].ToString();
JArray ja = (JArray)JsonConvert.DeserializeObject(data);
foreach (JObject Jobj in ja)
{
string sql = "update TBPM_STRINFODQO set BM_YFNUM=BM_YFNUM+" + Jobj["bjnum"].ToString() + " where BM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and BM_ZONGXU='" + Jobj["zongxu"] + "'";
sqllist.Add(sql);
//
sql = "update a set CM_YBJNUM=CM_YBJNUM+" + Jobj["bjnum"].ToString() + " from TBCM_FHBASIC as a left join TBCM_FHNOTICE as b on a.CM_FID=b.CM_FID where CM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and ID='" + Jobj["zongxu"] + "' and b.CM_BIANHAO='" + Jobj["bianhao"] + "'";
sqllist.Add(sql);
}
foreach (JObject Jobj in ja)
{
string sql1 = "update TBPM_STRINFODQO set BM_FHSTATE=case when BM_YFNUM<BM_NUMBER then '4' else '2' end where BM_ENGID='" + Jobj["tsaid"].ToString() + "' and BM_ZONGXU='" + Jobj["zongxu"] + "'";
sqllist.Add(sql1);
sql1 = "update TBCM_FHBASIC set CM_BJZT=case when CM_YBJNUM< CM_FHNUM then '4' else '2' end where CM_ID='" + Jobj["pid"].ToString().Split('|')[0] + "' and ID='" + Jobj["zongxu"] + "'";
sqllist.Add(sql1);
}
result = "{\"msg\":\"操作成功！\"}";
try
{
DBCallCommon.ExecuteTrans(sqllist);
}
catch (Exception)
{
result = "{\"msg\":\"数据错误，请联系管理员\"}";
}
Response.Write(result);
}
protected void btnDelete_OnClick(object sender, EventArgs e)
{
List <string> list = new List <string>();
foreach (GridViewRow grow in GridView1.Rows)
{
CheckBox chk = (CheckBox)grow.FindControl("CHK");
if (chk.Checked)
{
string code = ((Label)grow.FindControl("lblCode")).Text;
string sqltext = "delete from TBOM_GDZCPCAPPLY where CODE='" + code + "'";
list.Add(sqltext);
sqltext = "delete from TBOM_GDZCRVW where CODE='" + code + "'";
list.Add(sqltext);
}
}
if (list.Count > 0)
{
DBCallCommon.ExecuteTrans(list);
this.ReGetBoundData();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('删除成功！！！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请勾选要删除的行！！！');", true);
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
List <string> sql_list = new List <string>();
List <string> sql = new List <string>();
string str_up = "update TBPM_SCWXRVW set PM_JHQ='" + tb_jhq.Text + "' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
sql.Add(str_up);
//string str_up1 = "update TBPM_SCWXRVW set PM_SPZT='0' where PM_DocuNum='" + tb_doc.Text.ToString() + "'";
//sql.Add(str_up1);
foreach (RepeaterItem LabelID in tbpc_otherpurbill_lookRepeater.Items)
{
Label lb_zj = ((Label)LabelID.FindControl("lb_zj"));
TextBox MS_PROCESS = ((TextBox)LabelID.FindControl("MS_PROCESS"));
TextBox MS_BZ = ((TextBox)LabelID.FindControl("MS_BZ"));
string id = ((Label)LabelID.FindControl("lb_id")).Text;
int num = Convert.ToInt32(((TextBox)LabelID.FindControl("MS_NUM")).Text);
double f_wght = Convert.ToDouble(((Label)LabelID.FindControl("MS_TUWGHT")).Text);
double f_totalwght = num * f_wght;
// string totalnum = ((Label)LabelID.FindControl("lab_num")).Text;
//if (Convert.ToInt32(num) <= Convert.ToInt32(totalnum))//外协的数量小于等于总数量
//{
string sqltext = "update TBPM_WXDetail set MS_PROCESS='" + MS_PROCESS.Text + "',MS_NUM=" + num + ",MS_TUTOTALWGHT=" + f_totalwght + ", MS_XHBZ='" + MS_BZ.Text + "',MS_scwaixie='1' WHERE MS_ID='" + lb_zj.Text.Trim() + "' and MS_PID='" + tb_pid.Text.ToString() + "'and ID='" + id + "'";
sql.Add(sqltext);
}
DBCallCommon.ExecuteTrans(sql);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('保存成功！！！');window.location=window.location;", true);
}
protected void btnSave_onserverclick(object sender, EventArgs e)
{
List <string> list = new List <string>();
for (int i = 0, length = rptRYPZ.Items.Count; i < length; i++)
{
CheckBox cbx = (CheckBox)rptRYPZ.Items[i].FindControl("cbxXuHao");
if (cbx.Checked)
{
string ST_POSITION = ((HiddenField)rptRYPZ.Items[i].FindControl("ST_POSITION")).Value;
string DEP_PZSR = ((TextBox)rptRYPZ.Items[i].FindControl("DEP_PZSR")).Text.Trim();
string sql = "update TBDS_DEPINFO set DEP_PZRS=" + DEP_PZSR + " where DEP_CODE='" + ST_POSITION + "'";
list.Add(sql);
}
}
if (list.Count == 0)
{
Response.Write("<script>alert('请勾选需要修改的数据行！！！')</script>");
return;
}
try
{
DBCallCommon.ExecuteTrans(list);
}
catch
{
Response.Write("<script>alert('保存的语句出现问题！！！请与管理员联系')</script>");
return;
}
bindrpt();
}
//删除选中行
protected void btndelete_Click(object sender, EventArgs e)
{
//需要删除的ID
int num = 0;
List <string> sqls = new List <string>();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
CheckBox chk = (CheckBox)gr.FindControl("CheckBox1");
if (chk.Checked)
{
string hidID = ((HtmlInputHidden)this.GridView1.Rows[i].FindControl("hidID")).Value.Trim(); //物料代码
string sql = "DELETE FROM TBOM_BGYPPCAPPLYINFO where ID='" + hidID + "'";
sqls.Add(sql);
num++;
}
}
//如果有删除的行
if (num != 0)
{
//执行删除操作
DBCallCommon.ExecuteTrans(sqls);
Binddata_add();
}
else
{
Response.Write("<script>alert('请选中删除行!')</script>");
}
}
//删除当前单据，删除单据前判断是否满足删除单据条件，删除单据后关闭当前页面。
protected void DeleteBill_Click(object sender, EventArgs e)
{
if (LabelState.Text == "1")
{
List <string> sqllist = new List <string>();
string sql = "DELETE FROM TBWS_OUT WHERE OP_CODE='" + LabelCode.Text + "'";
sqllist.Add(sql);
sql = "DELETE FROM TBWS_OUTDETAIL WHERE OP_CODE='" + LabelCode.Text + "'";
sqllist.Add(sql);
DBCallCommon.ExecuteTrans(sqllist);
string script = @"window.close();";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "error", script, true);
return;
}
else if (LabelState.Text == "0")
{
string script = @"alert('当前出库单尚未保存！');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "error", script, true);
return;
}
}
protected void btnqr_OnClick(object sender, EventArgs e)
{
int count = 0;
string ptcode = "";
List <string> list = new List <string>();
for (int i = 0; i < rptProNumCost.Items.Count; i++)
{
if ((rptProNumCost.Items[i].FindControl("CKBOX_SELECT") as CheckBox).Checked)
{
count++;
ptcode = ((Label)rptProNumCost.Items[i].FindControl("ptcode")).Text;
string sql = "update TBPC_PURCHASEPLAN set PUR_CKQR='1' where PUR_PTCODE='" + ptcode + "'";
list.Add(sql);
}
}
if (count > 0)
{
DBCallCommon.ExecuteTrans(list);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "myscript", "<script type='text/javascript'>alert('请选择要确认的项!')</script>");
return;
}
this.InitVar();
this.bindGrid();
}
//核算
protected void btnHS_Click(object sender, EventArgs e)
{
List <string> list_rwh = new List <string>();
for (int i = 0; i < rptProNumCost.Items.Count; i++)
{
if (((CheckBox)rptProNumCost.Items[i].FindControl("checkbox")).Checked)
{
list_rwh.Add(((Label)rptProNumCost.Items[i].FindControl("lbrwh")).Text);
}
}
if (list_rwh.Count > 0)
{
string b = CheckOutAct(list_rwh);
if (b == "")
{
List <string> sql = new List <string>();
for (int k = 0; k < list_rwh.Count; k++)
{
string hsrwh = list_rwh[k].ToString();
string sqlcwhs = update_cwcb(hsrwh);
sql.Add(sqlcwhs);
}
DBCallCommon.ExecuteTrans(sql);
}
}
else
{
this.ClientScript.RegisterStartupScript(GetType(), "js", "alert('请勾选要核算的任务号！！！')", true);
}
UCPaging1.CurrentPage = 1;
this.InitVar();
this.bindGrid();
}
protected void btnTransf_click(object sender, EventArgs e)
{
List <string> list = new List <string>();
string sqltxt = "DELETE FROM OM_CAR_ZZB";
list.Add(sqltxt);
for (int i = 0; i < Repeater1.Items.Count; i++)
{
if (((CheckBox)Repeater1.Items[i].FindControl("CheckBox1")).Checked == true)
{
string kc_mc = ((Label)Repeater1.Items[i].FindControl("lblbh")).Text;
string kc_gg = ((Label)Repeater1.Items[i].FindControl("lblName")).Text;
string kc_danwei = ((Label)Repeater1.Items[i].FindControl("lbdanwei")).Text;
string kc_danjia = ((Label)Repeater1.Items[i].FindControl("lbdanjia")).Text;
sqltxt = "insert into OM_CAR_ZZB (SP_MC,SP_GG,SP_DJ,SP_DANWEI) VALUES ('" + kc_mc + "','" + kc_gg + "','" + kc_danjia + "','" + kc_danwei + "')";
list.Add(sqltxt);
}
}
if (list.Count == 1)
{
Response.Write("<script>alert('请勾选序号后后再出库！！！')</script>");
}
else
{
DBCallCommon.ExecuteTrans(list);
Response.Redirect("OM_CARCK_detail.aspx?FLAG=add&id=1");
}
}
/// <summary>
/// 作废：改变审核表中的状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void hlDelete_OnClick(object sender, EventArgs e)
{
string lotnum = ((LinkButton)sender).CommandName;
string engid = lotnum.Split('.')[0];
string tablenameOrg = this.GetOrgTableNameByLotNum(lotnum);
List <string> list_sql = new List <string>();
if (lotnum.Contains(" WXBG/"))//变更驳回
{
//变更外协审核表:修改驳回状态
list_sql.Add(" update TBPM_OUTSCHANGERVW set OST_STATE='9' where OST_CHANGECODE='" + lotnum + "'");
//原始数据表（修改材料计划提交状态及审核状态）
list_sql.Add(" update " + tablenameOrg + " set BM_OSSTATE='0' and BM_OSREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select OSL_NEWXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + lotnum + "')");
}
else if (lotnum.Contains(" WX/"))//正常驳回
{
//正常外协审核表:修改驳回状态
list_sql.Add(" update TBPM_OUTSOURCETOTAL set OST_STATE='9' where OST_OUTSOURCENO='" + lotnum + "'");
//原始数据表（修改外协提交状态及审核状态）
list_sql.Add(" update " + tablenameOrg + " set BM_OSSTATE='0', BM_OSREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select OSL_NEWXUHAO from TBPM_OUTSOURCELIST where OSL_OUTSOURCENO='" + lotnum + "')");
}
else if (lotnum.Contains(" WXQX/"))//取消驳回
{
//变更外协审核表:修改驳回状态
list_sql.Add(" update TBPM_MPCHANGERVW set OST_STATE='9' where OST_CHANGECODE='" + lotnum + "'");
}
DBCallCommon.ExecuteTrans(list_sql);
this.SignStatus(rblstate.SelectedValue);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('操作成功！！！');", true);
}
protected void lnkDelete_OnClick(object sender, EventArgs e)
{
string SPBH = ((LinkButton)sender).CommandArgument;
List <string> list = new List <string>();
string sqlText = "delete from OM_GDZCBFSP where SPBH='" + SPBH + "'";
list.Add(sqlText);
string sql = "update TBOM_GDZCIN set BFSPBH=NULL where BFSPBH='" + SPBH + "'";
list.Add(sql);
try
{
DBCallCommon.ExecuteTrans(list);
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('数据异常，请联系管理员！！！');", true);
return;
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('删除成功！！！');", true);
UCPaging1.CurrentPage = 1;
bindrpt();
}
//删除功能建议在使用时隐藏
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("lb_stid")).Text;
sqltext = "delete FROM OM_SHBX WHERE SH_STID='" + check + "' and SH_DATE='" + dplYear.SelectedValue.ToString().Trim() + "-" + dplMoth.SelectedValue.ToString().Trim() + "' and symbol='X'";
sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(sql);
UCPaging1.CurrentPage = 1;
this.InitVar();
this.bindGrid();
}
//保存
protected void save_month_max_onclick(object sender, EventArgs e)
{
List <string> update_sql = new List <string>();
string sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_02.Text.ToString() + "' where DEP_CODE='02' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_03.Text.ToString() + "' where DEP_CODE='03' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_04.Text.ToString() + "' where DEP_CODE='04' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_05.Text.ToString() + "' where DEP_CODE='05' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_06.Text.ToString() + "' where DEP_CODE='06' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_07.Text.ToString() + "' where DEP_CODE='07' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_10.Text.ToString() + "' where DEP_CODE='10' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_11.Text.ToString() + "' where DEP_CODE='11' and Type='0'";
update_sql.Add(sql_update_max);
sql_update_max = "update TBOM_BGYP_Month_max set MONTH_MAX='" + MONTH_MAX_12.Text.ToString() + "' where DEP_CODE='12' and Type='0'";
update_sql.Add(sql_update_max);
DBCallCommon.ExecuteTrans(update_sql);
Response.Redirect("OM_Bgyp_DingE.aspx");
}
private void writedata()
{
string outname;
string outtype;
int numstore;
int outnum;
string outnote;
List <string> list_sql = new List <string>();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
outname = ((Label)gr.FindControl("lblName")).Text;
outtype = ((Label)gr.FindControl("lblType")).Text;
numstore = Convert.ToInt32(((TextBox)gr.FindControl("txtNumstore")).Text);
outnum = Convert.ToInt32(((TextBox)gr.FindControl("txtOutNum")).Text);
outnote = ((TextBox)gr.FindControl("txtOutNote")).Text;
numstore -= outnum;
if (outnum == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提示:无法保存！！！没有入库数据！！！');", true);
return;
}
else
{
sqltext = "insert into EQU_Part_Out(OutCode,OutDep,ParName,ParType,OutNum,OutPer,OutDate,OutDoc,OutNote)";
sqltext += "values('" + lblOutCode.Text + "','" + ddlDep.SelectedValue + "','" + outname + "','" + outtype + "'," + outnum + ",'" + txt_giver.Text + "','" + lblOutDate.Text + "','" + lblOutDoc.Text + "','" + outnote + "')";
list_sql.Add(sqltext);
sqltext = "update EQU_Part_Store set ParNumSto=" + numstore + " where ParName='" + outname + "'and ParType='" + outtype + "'";
list_sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(list_sql);
}
/// <summary>
/// 创建发票,写入相关数据表中
/// </summary>
private void CreateInvOpDataBase(string fpbh)
{
List <string> sql = new List <string>();
string fpcode = fpbh;//发票编号
string jhgzhcode = "";
//string[] arrayUniqCode = arrayJhgzh.Split('/');//计划跟踪号数组
foreach (RepeaterItem Reitem in rptProNumCost.Items)
{
jhgzhcode = ((Label)Reitem.FindControl("lbjhgzh")).Text.Trim().ToString();
}
sql.Add(this.CreateInvTOTAL(jhgzhcode, fpcode));//发票总表，参数传递（结算单计划跟踪号(主要为从结算单获取供应商信息)，发票编号）
foreach (RepeaterItem Reitem in rptProNumCost.Items)
{
string Uniqcode = ((Label)Reitem.FindControl("lbjhgzh")).Text.Trim().ToString();
sql.Add(this.CreateJSD(Uniqcode)); //更新结算单结算状态
sql.Add(this.CreateGJrelation(Uniqcode, fpcode)); //更新勾稽关系表
}
//根据发票明细上的金额更新发票总表(总金额、含税金额)
string str_je = "update TBFM_WXGHINVOICETOTAL set WXGI_MONEY=(select sum(isnull(WXGJ_JE,0)) from TBFM_WXGJRELATION where WXGJ_FPID='" + fpcode + "') where WXGI_CODE='" + fpcode + "'";
string str_hsje = "update TBFM_WXGHINVOICETOTAL set WXGI_HSMONEY=(select sum(isnull(WXGJ_HSJE,0)) from TBFM_WXGJRELATION where WXGJ_FPID='" + fpcode + "') where WXGI_CODE='" + fpcode + "'";
sql.Add(str_je);
sql.Add(str_hsje);
DBCallCommon.ExecuteTrans(sql);
}
protected void btnAll_Click(object sender, EventArgs e)
{
if (rptCK.Items.Count == 0)
{
Response.Write("<script>alert('您还未添加出库项目！！！')</script>");
return;
}
List <string> list = new List <string>();
//更新TBCM_CUSTOMER表
string sql = string.Format("update TBCM_CUSTOMER set CM_BTOUT='1',CM_OUTNUM='{0}',CM_OUT='{1}',CM_OUTDATE='{2}',CM_NOTE='{3}',CM_KGYUAN='{4}' where CM_ID='{5}'", ((TextBox)rptCK.Items[0].FindControl("CM_OUTNUM")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_OUT")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_OUTDATE")).Text, ((TextBox)rptCK.Items[0].FindControl("CM_NOTE")).Text, UserID.Value, CM_ID);
list.Add(sql);
//删除TBCM_CUSINFO的旧数据
sql = "delete from TBCM_CUSINFO where CM_ID='" + CM_ID + "'";
list.Add(sql);
foreach (RepeaterItem item in rptCK.Items)
{
string cm_out = ((TextBox)item.FindControl("CM_OUT")).Text;
string cm_outnum = ((TextBox)item.FindControl("CM_OUTNUM")).Text;
string cm_outdate = ((TextBox)item.FindControl("CM_OUTDATE")).Text;
string cm_note = ((TextBox)item.FindControl("CM_NOTE")).Text;
sql = string.Format("insert into TBCM_CUSINFO (CM_ID,CM_OUT,CM_OUTNUM,CM_OUTDATE,CM_NOTE) values('{0}','{1}','{2}','{3}','{4}')", CM_ID, cm_out, cm_outnum, cm_outdate, cm_note);
list.Add(sql);
}
try
{
DBCallCommon.ExecuteTrans(list);
}
catch
{
Response.Write("<script>alert('添加的sql语句出现问题，请与管理员联系！！！')</script>");
}
Response.Write("<script>window.close()</script>");
}
protected void btnsave_click(object sender, EventArgs e)
{
List <string> list = new List <string>();
string bh = "TZ" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim();
string stryearmonth = "";
for (int i = 0; i < rptProNumCost.Items.Count; i++)
{
Label lb_QD_YEARMONTH = (Label)rptProNumCost.Items[i].FindControl("lb_QD_YEARMONTH");
stryearmonth = lb_QD_YEARMONTH.Text.Trim();
Label lb_ST_ID = (Label)rptProNumCost.Items[i].FindControl("lb_ST_ID");
TextBox tb_GZTZ_BFJBF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BFJBF");
TextBox tb_GZTZ_BFZYBF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BFZYBF");
TextBox tb_GZTZ_BF = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BF");
TextBox tb_GZTZ_BK = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_BK");
TextBox tb_GZTZ_NOTE = (TextBox)rptProNumCost.Items[i].FindControl("tb_GZTZ_NOTE");
if (CommonFun.ComTryDecimal(tb_GZTZ_BK.Text.Trim()) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('补扣应为负数！');", true);
return;
}
string sql = "insert into OM_GZTZdetal(GZTZ_SPBH,GZTZ_YEARMONTH,GZTZ_STID,GZTZ_BFJBF,GZTZ_BFZYBF,GZTZ_BF,GZTZ_BK,GZTZ_NOTE) values('" + bh + "','" + stryearmonth + "','" + lb_ST_ID.Text.Trim() + "'," + CommonFun.ComTryDecimal(tb_GZTZ_BFJBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BFZYBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BF.Text.Trim()) + "," + CommonFun.ComTryDecimal(tb_GZTZ_BK.Text.Trim()) + ",'" + tb_GZTZ_NOTE.Text.Trim() + "')";
list.Add(sql);
}
string sqlinsertsp = "insert into OM_GZTZSP(GZTZSP_SPBH,GZTZSP_YEARMONTH,GZTZSP_SQRSTID,GZTZSP_SQRNAME,GZTZSP_SQTIME) values('" + bh + "','" + stryearmonth + "','" + Session["UserID"].ToString().Trim() + "','" + Session["UserName"].ToString().Trim() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "')";
list.Add(sqlinsertsp);
DBCallCommon.ExecuteTrans(list);
Response.Redirect("OM_GZTZSPdetail.aspx?spid=" + bh);
}
/// <summary>
/// 处理材料计划驳回：驳回》驳回已处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void hlDelete_OnClick(object sender, EventArgs e)
{
string lotnum = ((LinkButton)sender).CommandName;
string engid = lotnum.Split('.')[0];
List <string> list_sql = new List <string>();
if (lotnum.Contains("MPBG/"))//变更驳回
{
//变更材料计划审核表:修改驳回状态
list_sql.Add(" update TBPM_MPCHANGERVW set MP_STATE='9' where MP_ID='" + lotnum + "'");
//原始数据表（修改材料计划提交状态及审核状态）
list_sql.Add(" update TBPM_ set BM_MPSTATE='0',BM_MPREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select MP_NEWXUHAO from TBPM_MPCHANGE where MP_PID='" + lotnum + "')");
}
else if (lotnum.Contains("MP/"))//正常驳回
{
//正常材料计划审核表:修改驳回状态
list_sql.Add(" update TBPM_MPFORALLRVW set MP_STATE='9' where MP_ID='" + lotnum + "'");
//原始数据表（修改材料计划提交状态及审核状态）
list_sql.Add(" update TBPM_STRINFODQO set BM_MPSTATE='0', BM_MPREVIEW='0' where BM_ENGID='" + engid + "' and BM_XUHAO in(select MP_NEWXUHAO from TBPM_MPPLAN where MP_PID='" + lotnum + "')");
}
else if (lotnum.Contains("MPQX/"))//取消驳回
{
//变更材料计划审核表:修改驳回状态
list_sql.Add(" update TBPM_MPCHANGERVW set MP_STATE='9' where MP_ID='" + lotnum + "'");
}
DBCallCommon.ExecuteTrans(list_sql);
this.SignStatus(rblstate.SelectedValue);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('操作成功！！！');", true);
}
protected void btnSubmit_OnClick(object sender, EventArgs e)
{
string uprice;
string tprice;
string rowid;
List <string> list_sql = new List <string>();
if (price != '0')
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
uprice = ((TextBox)gr.FindControl("txtUprice")).Text.ToString();
tprice = ((TextBox)gr.FindControl("txtTprice")).Text.ToString();
rowid = ((Label)gr.FindControl("lblid")).Text.ToString();
sqltext = "update TBOM_GDZCPCAPPLY set [UPRICE]='" + uprice + "',[TPRICE]='" + tprice + "',[SHRID]='" + shrid.Value + "',[SHR]='" + txtshr.Text + "',[STATE]=1 where [ID]='" + rowid + "'";
list_sql.Add(sqltext);
}
sqltext = "update TBOM_GDZCRVW set CARRVWA='" + txtshr.Text.Trim() + "',CARRVWAID='" + shrid.Value.Trim() + "',STATUS='1' where CODE='" + lblCode.Text.Trim() + "'";
list_sql.Add(sqltext);
DBCallCommon.ExecuteTrans(list_sql);
string _emailto = DBCallCommon.GetEmailAddressByUserID(firstid.Value);
string _body = "非固定资产采购审批任务:"
+ "\r\n单号：" + lblCode.Text.ToString().Trim()
+ "\r\n制单日期：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string _subject = "您有新的【非固定资产采购】需要审批，请及时处理:" + lblCode.Text.ToString().Trim();
DBCallCommon.SendEmail(_emailto, null, null, _subject, _body);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功,请等待审批！');window.location.href='OM_GdzcPcPlan.aspx'", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写金额！！！');", true);
}
}
protected void btnSave_onserverclick(object sender, EventArgs e)
{
if (asd.action == "add")
{
List <string> list = addlist();
try
{
DBCallCommon.ExecuteTrans(list);
}
catch
{
Response.Write("<script>alert('新增sql语句出现问题，请与管理员联系！！！')</script>");
return;
}
}
else if (asd.action == "alter")
{
List <string> list = alterlist();
try
{
DBCallCommon.ExecuteTrans(list);
}
catch
{
Response.Write("<script>alert('修改sql语句出现问题，请与管理员联系！！！')</script>");
return;
}
}
Response.Redirect("OM_PXXQ_GL.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
string CPQRInData = Request.Form["CPQRInData"].ToString().Trim();
string CPQRInNum_Str = Request.Form["CPQRInNum"].ToString().Trim();
string CPnote = Request.Form["CPnote"].ToString().Trim();
string CPQRInPerson = Request.Form["CPQRInPerson"].ToString().Trim();
List <string> list = new List <string>();
string result = "";
string sqlInsert = "";
string[] arrData = CPQRInData.Split(';');
int CPQRIn_Num = Convert.ToInt32(CPQRInNum_Str); //入庫数量
string CPQRIn_Time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim(); //扫码时间
if (checkIfInstate(arrData[2].ToString().Trim(), arrData[3].ToString().Trim()))
{
sqlInsert = "insert into midTable_Finished_QRIn(CPQRIn_TaskID, CPQRIn_Zongxu, CPQRIn_Num, CPQRIn_Time, CPQRIn_Person, CPQRIn_Note, CPQRIn_State) values('" + arrData[2].ToString().Trim() + "','" + arrData[3].ToString().Trim() + "'," + CPQRIn_Num + ",'" + CPQRIn_Time + "','" + CPQRInPerson + "','" + CPnote + "','0')";
list.Add(sqlInsert);
try
{
DBCallCommon.ExecuteTrans(list);
result = "{\"result\":\"success\",\"msg\":\"操作成功!\"}";
}
catch
{
result = "{\"result\":\"fault\",\"msg\":\"程序执行出现错误!\"}";
}
}
else
{
result = "{\"result\":\"fault\",\"msg\":\"该成品已入库或正在审核，请勿重复入库!\"}";
}
Response.Write(result);
}
