/// <summary>
/// 驳回至生产反馈：财务调整、一级审批、二级审批使用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_RebutToShengChan_Click(object sender, EventArgs e)
{
#region 财务调整
if (depId == "06" && caiWu == 1 && position == "0601")
{
if (DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_SHENGCHAN=1,YS_CAIWU=3,YS_CAIWU_NAME='{0}',YS_CAIWU_YJ='{1}',YS_CAIWU_SJ=GETDATE(),YS_STATE=2,YS_REBUT='04' WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_CAIWU_YJ.UniqueID], tsaId)) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已驳回到生产部重新反馈!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('错误！');window.close();window.opener.location.reload();", true);
}
}
#endregion
#region 一级驳回
else if (yiJi == 1 && position == "0102")
{
if (DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_FIRST_REVSTATE=3,YS_FIRST_REV_NAME='{0}',YS_FIRST_REV_YJ='{1}',YS_FIRST_REV_SJ=GETDATE(),YS_REVSTATE=3,YS_STATE=2,YS_SHENGCHAN=1,YS_REBUT='04' WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_FIRST_REV_YJ.UniqueID], tsaId)) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已驳回到生产部重新填写!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('错误！');window.close();window.opener.location.reload();", true);
}
}
#endregion
#region 二级驳回
else if (erJi == 1 && position == "0101")
{
if (DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_SECOND_REVSTATE=3,YS_SECOND_REV_NAME='{0}',YS_SECOND_REV_YJ='{1}',YS_SECOND_REV_SJ=GETDATE(),YS_REVSTATE=3,YS_STATE=2,YS_SHENGCHAN=1,YS_REBUT='04' WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_SECOND_REV_YJ.UniqueID], tsaId)) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已驳回到生产部重新填写!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('错误！');window.close();window.opener.location.reload();", true);
}
}
#endregion
}
/// <summary>
/// 提交按钮：采购部反馈、生产部反馈、财务调整、一级审批、二级审批用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Submit_Click(object sender, EventArgs e)
{
List <string> listsql = new List <string>();//保存更新语句
#region 采购部提交
if (caiGou == 1 && depId == "05") //05采购部，采购状态为待反馈
{
//获取各个repeater中的数据
listsql.Clear();
GetDeatils(rpt_YS_FERROUS_METAL, "txt_YS_FERROUS_METAL_Average_Price_FB", listsql);
GetDeatils(rpt_YS_PURCHASE_PART, "txt_YS_PURCHASE_PART_Average_Price_FB", listsql);
GetDeatils(rpt_YS_PAINT_COATING, "txt_YS_PAINT_COATING_Average_Price_FB", listsql);
GetDeatils(rpt_YS_ELECTRICAL, "txt_YS_ELECTRICAL_Average_Price_FB", listsql);
GetDeatils(rpt_YS_CASTING_FORGING_COST, "txt_YS_CASTING_FORGING_COST_Average_Price_FB", listsql);
GetDeatils(rpt_YS_OTHERMAT_COST, "txt_YS_OTHERMAT_COST_Average_Price_FB", listsql);
listsql.Add(string.Format(@"UPDATE dbo.YS_COST_BUDGET
SET
YS_FERROUS_METAL_FB = '{0}' ,
YS_PURCHASE_PART_FB = '{1}' ,
YS_PAINT_COATING_FB = '{2}' ,
YS_ELECTRICAL_FB = '{3}' ,
YS_CASTING_FORGING_COST_FB = '{4}' ,
YS_OTHERMAT_COST_FB = '{5}' ,
YS_UNIT_LABOUR_COST_FB = '{6}'
WHERE YS_TSA_ID = '{7}';",
Request.Form[txt_YS_FERROUS_METAL_FB.UniqueID].Trim(),
Request.Form[txt_YS_PURCHASE_PART_FB.UniqueID].Trim(),
Request.Form[txt_YS_PAINT_COATING_FB.UniqueID].Trim(),
Request.Form[txt_YS_ELECTRICAL_FB.UniqueID].Trim(),
Request.Form[txt_YS_CASTING_FORGING_COST_FB.UniqueID].Trim(),
Request.Form[txt_YS_OTHERMAT_COST_FB.UniqueID].Trim(),
Request.Form[txt_YS_UNIT_LABOUR_COST_FB.UniqueID].Trim(),
tsaId));
listsql.Add(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_CAIGOU=2,YS_CAIGOU_NAME='{0}',YS_CAIGOU_YJ='{1}',YS_CAIGOU_SJ=GETDATE(),YS_REVSTATE=0 WHERE YS_TSA_ID='{2}'", userName, Request.Form[txt_YS_CAIGOU_YJ.UniqueID], tsaId));
DBCallCommon.ExecuteTrans(listsql);
string sql = "SELECT YS_SHENGCHAN,YS_CAIGOU FROM dbo.YS_COST_BUDGET WHERE YS_TSA_ID='" + tsaId + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
listsql.Clear();
if (dt.Rows[0]["YS_SHENGCHAN"].ToString() == "2" && dt.Rows[0]["YS_CAIGOU"].ToString() == "2")
{
DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_STATE=3,YS_CAIWU=1,YS_CAIWU_NAME=NULL,YS_CAIWU_SJ=NULL,YS_CAIWU_YJ=NULL,YS_REVSTATE=0,YS_REBUT=0 WHERE YS_TSA_ID='{0}'", tsaId));
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
#endregion
#region 生产部提交
else if (depId == "04" && shengChan == 1) //04生产部，生产状态为待反馈
{
listsql.Clear();
listsql.Add(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_UNIT_LABOUR_COST_FB='{0}',YS_SHENGCHAN=2,YS_SHENGCHAN_NAME='{1}',YS_SHENGCHAN_YJ='{2}',YS_SHENGCHAN_SJ=GETDATE(),YS_REVSTATE=0 WHERE YS_TSA_ID='{3}'", Request.Form[txt_YS_UNIT_LABOUR_COST_FB.UniqueID], userName, Request.Form[txt_YS_SHENGCHAN_YJ.UniqueID], tsaId));
DBCallCommon.ExecuteTrans(listsql);
listsql.Clear();
string sql = "SELECT YS_SHENGCHAN,YS_CAIGOU FROM dbo.YS_COST_BUDGET WHERE YS_TSA_ID='" + tsaId + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows[0]["YS_SHENGCHAN"].ToString() == "2" && dt.Rows[0]["YS_CAIGOU"].ToString() == "2")
{
DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_STATE=3,YS_CAIWU=1,YS_CAIWU_NAME=NULL,YS_CAIWU_SJ=NULL,YS_CAIWU_YJ=NULL,YS_REVSTATE=0,YS_REBUT=0 WHERE YS_TSA_ID='{0}'", tsaId));
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
#endregion
#region 财务调整提交
else if (caiWu == 1 && position == "0601") //财务部长进行财务调整
{
listsql.Clear();
listsql.Add(string.Format(@"UPDATE dbo.YS_COST_BUDGET
SET YS_NOTE = '{0}' ,
YS_MATERIAL_COST = '{1}' ,
YS_LABOUR_COST = '{2}' ,
YS_FERROUS_METAL = '{3}' ,
YS_PURCHASE_PART = '{4}' ,
YS_PAINT_COATING = '{5}' ,
YS_ELECTRICAL = '{6}' ,
YS_CASTING_FORGING_COST = '{7}' ,
YS_OTHERMAT_COST = '{8}'
WHERE YS_TSA_ID = '{9}';",
Request.Form[txt_YS_NOTE.UniqueID].Trim(),
Request.Form[txt_YS_MATERIAL_COST.UniqueID].Trim(),
Request.Form[txt_YS_LABOUR_COST.UniqueID].Trim(),
Request.Form[txt_YS_FERROUS_METAL.UniqueID].Trim(),
Request.Form[txt_YS_PURCHASE_PART.UniqueID].Trim(),
Request.Form[txt_YS_PAINT_COATING.UniqueID].Trim(),
Request.Form[txt_YS_ELECTRICAL.UniqueID].Trim(),
Request.Form[txt_YS_CASTING_FORGING_COST.UniqueID].Trim(),
Request.Form[txt_YS_OTHERMAT_COST.UniqueID].Trim(),
tsaId));
listsql.Add(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_CAIWU='2',YS_CAIWU_NAME='{0}',YS_CAIWU_SJ=GETDATE(),YS_CAIWU_YJ='{1}',YS_STATE='4',YS_REVSTATE='1',YS_FIRST_REVSTATE='1',YS_REBUT='0' WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_CAIWU_YJ.UniqueID], tsaId));
DBCallCommon.ExecuteTrans(listsql);
listsql.Clear();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提交成功！');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
#endregion
#region 一级提交
else if (yiJi == 1 && position == "0102")
{
if (DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_FIRST_REVSTATE=2,YS_FIRST_REV_NAME='{0}',YS_FIRST_REV_YJ='{1}',YS_FIRST_REV_SJ=GETDATE(),YS_SECOND_REVSTATE=1 WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_FIRST_REV_YJ.UniqueID], tsaId)) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已提交审批!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('错误！');window.close();window.opener.location.reload();", true);
}
}
#endregion
#region 二级提交
else if (erJi == 1 && position == "0101")
{
if (DBCallCommon.ExeSqlTextGetInt(string.Format("UPDATE dbo.YS_COST_BUDGET SET YS_SECOND_REVSTATE=2,YS_SECOND_REV_NAME='{0}',YS_SECOND_REV_YJ='{1}',YS_SECOND_REV_SJ=GETDATE(),YS_STATE=5,YS_REVSTATE=2 WHERE YS_TSA_ID='{2}';", userName, Request.Form[txt_YS_SECOND_REV_YJ.UniqueID], tsaId)) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已提交审批!');window.close();window.opener.location.reload();window.opener.parent.left.location.reload();", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('错误！');window.close();window.opener.location.reload();", true);
}
}
#endregion
}
