/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_ROLL_DEPLOY_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMC_ROLL_DEPLOY_LOG set ");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("C_OLDAREA=:C_OLDAREA,");
strSql.Append("C_NEWAREA=:C_NEWAREA,");
strSql.Append("C_EMPID=:C_EMPID,");
strSql.Append("C_EMPNAME=:C_EMPNAME,");
strSql.Append("D_MOD=:D_MOD");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_OLDAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMPID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_BATCH_NO;
parameters[1].Value = model.C_MAT_CODE;
parameters[2].Value = model.C_STL_GRD;
parameters[3].Value = model.C_SPEC;
parameters[4].Value = model.C_OLDAREA;
parameters[5].Value = model.C_NEWAREA;
parameters[6].Value = model.C_EMPID;
parameters[7].Value = model.C_EMPNAME;
parameters[8].Value = model.D_MOD;
parameters[9].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_ROLL_DEPLOY_LOG DataRowToModel(DataRow row)
{
Mod_TMC_ROLL_DEPLOY_LOG model = new Mod_TMC_ROLL_DEPLOY_LOG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_BATCH_NO"] != null)
{
model.C_BATCH_NO = row["C_BATCH_NO"].ToString();
}
if (row["C_MAT_CODE"] != null)
{
model.C_MAT_CODE = row["C_MAT_CODE"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_SPEC"] != null)
{
model.C_SPEC = row["C_SPEC"].ToString();
}
if (row["C_OLDAREA"] != null)
{
model.C_OLDAREA = row["C_OLDAREA"].ToString();
}
if (row["C_NEWAREA"] != null)
{
model.C_NEWAREA = row["C_NEWAREA"].ToString();
}
if (row["C_EMPID"] != null)
{
model.C_EMPID = row["C_EMPID"].ToString();
}
if (row["C_EMPNAME"] != null)
{
model.C_EMPNAME = row["C_EMPNAME"].ToString();
}
if (row["D_MOD"] != null && row["D_MOD"].ToString() != "")
{
model.D_MOD = DateTime.Parse(row["D_MOD"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_ROLL_DEPLOY_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMC_ROLL_DEPLOY_LOG(");
strSql.Append("C_ID,C_BATCH_NO,C_MAT_CODE,C_STL_GRD,C_SPEC,C_OLDAREA,C_NEWAREA,C_EMPID,C_EMPNAME,D_MOD)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_BATCH_NO,:C_MAT_CODE,:C_STL_GRD,:C_SPEC,:C_OLDAREA,:C_NEWAREA,:C_EMPID,:C_EMPNAME,:D_MOD)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_OLDAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWAREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMPID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_BATCH_NO;
parameters[2].Value = model.C_MAT_CODE;
parameters[3].Value = model.C_STL_GRD;
parameters[4].Value = model.C_SPEC;
parameters[5].Value = model.C_OLDAREA;
parameters[6].Value = model.C_NEWAREA;
parameters[7].Value = model.C_EMPID;
parameters[8].Value = model.C_EMPNAME;
parameters[9].Value = model.D_MOD;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_ROLL_DEPLOY_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_BATCH_NO,C_MAT_CODE,C_STL_GRD,C_SPEC,C_OLDAREA,C_NEWAREA,C_EMPID,C_EMPNAME,D_MOD from TMC_ROLL_DEPLOY_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMC_ROLL_DEPLOY_LOG model = new Mod_TMC_ROLL_DEPLOY_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
try
{
string nextStep = hidNextSetpID.Value;//下一步骤
if (nextStep == "0")
{
#region //先判定是否资源调配成功
bool result = true; //判断当前发运数量已超出可发运量
string stlgrd = string.Empty;
#region //初始化DataTable
DataTable dt = new DataTable();
dt.Columns.Add("matCode", typeof(string)); //物料编码
dt.Columns.Add("stdCode", typeof(string)); //执行标准
dt.Columns.Add("area", typeof(string)); //区域
dt.Columns.Add("pack", typeof(string)); //包装
dt.Columns.Add("lev", typeof(string)); //等级
dt.Columns.Add("custname", typeof(string)); //客户名称
dt.Columns.Add("conno", typeof(string)); //合同号
dt.Columns.Add("stlgrd", typeof(string)); //钢种
dt.Columns.Add("wgt", typeof(string)); //重量
#endregion
List <Mod_TMC_ROLL_DEPLOY_LOG> list = new List <Mod_TMC_ROLL_DEPLOY_LOG>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
Literal ltlbatch = (Literal)rptList.Items[i].FindControl("ltlbatch"); //批次号
Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode"); //物料编码
Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd"); //钢种
Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec"); //规格
Literal ltlsalearea = (Literal)rptList.Items[i].FindControl("ltlsalearea"); //销售区域
Literal ltlstdcode = (Literal)rptList.Items[i].FindControl("ltlstdcode"); //执行标准
Literal ltlpack = (Literal)rptList.Items[i].FindControl("ltlpack"); //包装要求
Literal ltllev = (Literal)rptList.Items[i].FindControl("ltllev"); //质量等级
Literal ltlN_WGT = (Literal)rptList.Items[i].FindControl("ltlN_WGT"); //重量
Literal ltlneedarea = (Literal)rptList.Items[i].FindControl("ltlneedarea"); //需求区域
Literal ltlneedcust = (Literal)rptList.Items[i].FindControl("ltlneedcust"); //需求客户
Literal ltlneedcon = (Literal)rptList.Items[i].FindControl("ltlneedcon"); //需求合同
Literal ltlzycust = (Literal)rptList.Items[i].FindControl("ltlzycust"); //原资源客户
Literal ltlzycon = (Literal)rptList.Items[i].FindControl("ltlzycon"); //原资源合同
#region //插入值
if (ts_dic.GetAreaFlag(ltlsalearea.Text) == "N") //获取区域是否按客户发运Y/N
{
DataRow[] dr2 = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "'");
if (dr2.Length <= 0)
{
dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text, "", "", ltlstlgrd.Text, ltlN_WGT.Text });
}
else
{
foreach (var item in dr2)
{
item["wgt"] = Convert.ToString(Convert.ToDecimal(item["wgt"]) + Convert.ToDecimal(ltlN_WGT.Text));
}
}
}
else
{
DataRow[] dr2 = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "' and custname='" + ltlzycust.Text + "' and conno='" + ltlzycon.Text + "'");
if (dr2.Length <= 0)
{
dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text, ltlzycust.Text, ltlzycon.Text, ltlstlgrd.Text, ltlN_WGT.Text });
}
else
{
foreach (var item in dr2)
{
item["wgt"] = Convert.ToString(Convert.ToDecimal(item["wgt"]) + Convert.ToDecimal(ltlN_WGT.Text));
}
}
}
#endregion
#region //参数
Mod_TMC_ROLL_DEPLOY_LOG modLog = new Mod_TMC_ROLL_DEPLOY_LOG();
modLog.C_ROLL_PROCID = cbxselect.Value;
modLog.C_BATCH_NO = ltlbatch.Text;
modLog.C_MAT_CODE = ltlmatcode.Text;
modLog.C_STL_GRD = ltlstlgrd.Text;
modLog.C_SPEC = ltlspec.Text;
modLog.C_OLDAREA = ltlsalearea.Text; //原资源区域
modLog.C_NEWAREA = ltlneedarea.Text; //需求区域
modLog.C_OLDCUST = ltlzycust.Text; //原资源客户
modLog.C_NEWCUST = ltlneedcust.Text; //需求客户信息
modLog.C_OLDCON = ltlzycon.Text; //原资源合同
modLog.C_NEWCON = ltlneedcon.Text; //需求合同
modLog.C_EMPID = ltlUserID.Text;
modLog.C_EMPNAME = ltlUserName.Text;
modLog.C_STD_CODE = ltlstdcode.Text;
modLog.C_JUDGE_LEV = ltllev.Text;
modLog.C_PACK = ltlpack.Text;
list.Add(modLog);
#endregion
}
#region //在途量/库存量
for (int i = 0; i < dt.Rows.Count; i++)
{
if (ts_dic.GetAreaFlag(dt.Rows[i]["area"].ToString()) == "N")//获取区域是否按客户发运Y/N
{
//判断当前发运数量已超出可发运量
if (!tmo_order.IsFy(Convert.ToDecimal(dt.Rows[i]["wgt"].ToString()), dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()))
{
stlgrd = dt.Rows[i]["stlgrd"].ToString();
result = false;
break;
}
}
else
{
//判断当前发运数量已超出可发运量
if (!tmo_order.IsFy(Convert.ToDecimal(dt.Rows[i]["wgt"].ToString()), dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString(), dt.Rows[i]["custname"].ToString(), dt.Rows[i]["conno"].ToString()))
{
stlgrd = dt.Rows[i]["stlgrd"].ToString();
result = false;
break;
}
}
}
//if (dt.Rows.Count > 0)
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// DataTable dtfyzt = tmo_order.ZTWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0];
// if (dtfyzt.Rows.Count > 0)//在途量
// {
// ztwgt += Convert.ToDecimal(dtfyzt.Compute("sum(N_FYWGT)", "true"));//合计在途量
// }
// DataTable dtkc = tmo_order.KCWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0];
// if (dtkc.Rows.Count > 0)//库存量
// {
// if (!string.IsNullOrEmpty(dtkc.Rows[0]["N_WGT"].ToString()))
// {
// kcwgt += Convert.ToDecimal(dtkc.Rows[0]["N_WGT"]);//合计在途量
// }
// }
// }
//}
#endregion
if (result)
{
if (tmc_roll_deploy_log.InsertRoll_Proc3(list)) //执行调配资源
{
#region //最后步骤操作
Mod_ApproveCon mod = new Mod_ApproveCon();
mod.C_EMP_ID = ltlUserID.Text; //当前审批人
mod.NEXTSTEPID = nextStep; //下一步骤
mod.FILE_STATUS = "1"; // 办结
mod.FILEID = ltlFileID.Text;
mod.CON_STATUS = "2"; //审核通过
mod.CON_NO = ltlTaskID.Text;
mod.STEPID = ltlStepID.Text; //当前步骤
if (fileinfo.UpdateLastStep_ROLL(mod))
{
ProAdd("批准");
}
#endregion
}
}
else
{
string msg = stlgrd + ",存在发运单占用该资源";
txtContent.Text = msg;
WebMsg.MessageBox(stlgrd + ",存在发运单占用该资源,请点击驳回！");
}
#endregion
}
else
{
#region //下一步骤操作
if (tmb_file_next_emp.UpdateNextSetp(ltlFileID.Text, ltlStepID.Text, nextStep, hidEmpID.Value, ltlUserID.Text))
{
ProAdd("批准");
}
#endregion
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_ROLL_DEPLOY_LOG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_ROLL_DEPLOY_LOG model)
{
return(dal.Add(model));
}
//修改资源区域
protected void btnedit_Click(object sender, EventArgs e)
{
try
{
#region //初始化DataTable
DataTable dt = new DataTable();
dt.Columns.Add("matCode", typeof(string)); //物料编码
dt.Columns.Add("stdCode", typeof(string)); //执行标准
dt.Columns.Add("area", typeof(string)); //区域
dt.Columns.Add("pack", typeof(string)); //包装
dt.Columns.Add("lev", typeof(string)); //等级
#endregion
decimal ztwgt = 0; //在途量
decimal kcwgt = 0; //库存量
decimal tpwgt = 0; //调配量
decimal kfwgt = 0; //可发量
List <Mod_TMC_ROLL_DEPLOY_LOG> list = new List <Mod_TMC_ROLL_DEPLOY_LOG>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
Literal ltlbatch = (Literal)rptList.Items[i].FindControl("ltlbatch"); //批次号
Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode"); //物料编码
Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd"); //钢种
Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec"); //规格
Literal ltlsalearea = (Literal)rptList.Items[i].FindControl("ltlsalearea"); //销售区域
Literal ltlstdcode = (Literal)rptList.Items[i].FindControl("ltlstdcode"); //执行标准
Literal ltlpack = (Literal)rptList.Items[i].FindControl("ltlpack"); //包装要求
Literal ltllev = (Literal)rptList.Items[i].FindControl("ltllev"); //质量等级
Literal ltlN_WGT = (Literal)rptList.Items[i].FindControl("ltlN_WGT"); //重量
if (cbxselect.Checked)
{
if (!string.IsNullOrEmpty(ltlN_WGT.Text))
{
tpwgt += Convert.ToDecimal(ltlN_WGT.Text);//合计调配量
}
DataRow[] dr = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "'");
if (dr.Length <= 0)
{
dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text });
}
#region//参数
Mod_TMC_ROLL_DEPLOY_LOG mod = new Mod_TMC_ROLL_DEPLOY_LOG();
mod.C_ROLL_PROCID = cbxselect.Value;
mod.C_BATCH_NO = ltlbatch.Text;
mod.C_MAT_CODE = ltlmatcode.Text;
mod.C_STL_GRD = ltlstlgrd.Text;
mod.C_SPEC = ltlspec.Text;
mod.C_OLDAREA = ltlsalearea.Text;
mod.C_NEWAREA = dropneedarea.SelectedItem.Value;
mod.C_EMPID = ltlempid.Text;
mod.C_EMPNAME = ltlempname.Text;
mod.C_STD_CODE = ltlstdcode.Text;
mod.C_JUDGE_LEV = ltllev.Text;
mod.C_PACK = ltlpack.Text;
list.Add(mod);
#endregion
}
}
#region //在途量/库存量
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtfyzt = tmo_order.ZTWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0];
if (dtfyzt.Rows.Count > 0) //在途量
{
ztwgt += Convert.ToDecimal(dtfyzt.Compute("sum(N_FYWGT)", "true")); //合计在途量
}
DataTable dtkc = tmo_order.KCWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0];
if (dtkc.Rows.Count > 0)//库存量
{
if (!string.IsNullOrEmpty(dtkc.Rows[0]["N_WGT"].ToString()))
{
kcwgt += Convert.ToDecimal(dtkc.Rows[0]["N_WGT"]);//合计在途量
}
}
}
}
#endregion
#region //执行调配资源
kfwgt = kcwgt - ztwgt;
if (tpwgt <= kfwgt)
{
if (list.Count > 0)
{
if (tmc_roll_deploy_log.InsertRoll_Proc2(list))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配成功');</script>", false);
BindList();
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配失败');</script>", false);
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> close();</script>", false);
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配资源，存在发运单占用其中资源');</script>", false);
}
#endregion
}
catch (Exception ex)
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('" + ex.Message + "');</script>", false);
}
}
//客户调配
protected void btneditCust_Click(object sender, EventArgs e)
{
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
string dept = ts_user.GetDept(vUser.Account);
bool result = true; //判断当前发运数量已超出可发运量
bool result2 = true; //调配区域是否一致
string stlgrd = string.Empty;
#region //初始化DataTable
DataTable dt = new DataTable();
dt.Columns.Add("matCode", typeof(string)); //物料编码
dt.Columns.Add("stdCode", typeof(string)); //执行标准
dt.Columns.Add("area", typeof(string)); //区域
dt.Columns.Add("pack", typeof(string)); //包装
dt.Columns.Add("lev", typeof(string)); //等级
dt.Columns.Add("custname", typeof(string)); //客户
dt.Columns.Add("conno", typeof(string)); //合同号
dt.Columns.Add("stlgrd", typeof(string)); //钢种
dt.Columns.Add("wgt", typeof(string)); //重量
#endregion
decimal ztwgt = 0; //在途量
decimal kcwgt = 0; //库存量
decimal tpwgt = 0; //调配量
decimal kfwgt = 0; //可发量
List <Mod_TMC_ROLL_DEPLOY_LOG> list = new List <Mod_TMC_ROLL_DEPLOY_LOG>();
for (int i = 0; i < rptList.Items.Count; i++)
{
HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect");
Literal ltlbatch = (Literal)rptList.Items[i].FindControl("ltlbatch"); //批次号
Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode"); //物料编码
Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd"); //钢种
Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec"); //规格
Literal ltlsalearea = (Literal)rptList.Items[i].FindControl("ltlsalearea"); //销售区域
Literal ltlstdcode = (Literal)rptList.Items[i].FindControl("ltlstdcode"); //执行标准
Literal ltlpack = (Literal)rptList.Items[i].FindControl("ltlpack"); //包装要求
Literal ltllev = (Literal)rptList.Items[i].FindControl("ltllev"); //质量等级
Literal ltlN_WGT = (Literal)rptList.Items[i].FindControl("ltlN_WGT"); //重量
Literal ltlC_CUST_NAME = (Literal)rptList.Items[i].FindControl("ltlC_CUST_NAME"); //客户信息
Literal ltlC_CON_NO = (Literal)rptList.Items[i].FindControl("ltlC_CON_NO"); //合同号
if (cbxselect.Checked)
{
//if (ltlsalearea.Text != dept)
//{
// result = false;
// break;
//}
DataRow[] dr = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "' and custname='" + ltlC_CUST_NAME.Text + "' and conno='" + ltlC_CON_NO.Text + "'");
if (dr.Length <= 0)
{
dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text, ltlC_CUST_NAME.Text, ltlC_CON_NO.Text, ltlstlgrd.Text, ltlN_WGT.Text });
}
else
{
foreach (var item in dr)
{
item["wgt"] = Convert.ToString(Convert.ToDecimal(item["wgt"]) + Convert.ToDecimal(ltlN_WGT.Text));
}
}
#region //参数
Mod_TMC_ROLL_DEPLOY_LOG mod = new Mod_TMC_ROLL_DEPLOY_LOG();
mod.C_ROLL_PROCID = cbxselect.Value;
mod.C_BATCH_NO = ltlbatch.Text;
mod.C_MAT_CODE = ltlmatcode.Text;
mod.C_STL_GRD = ltlstlgrd.Text;
mod.C_SPEC = ltlspec.Text;
mod.C_OLDAREA = ltlsalearea.Text;
mod.C_NEWAREA = dropneedarea.SelectedValue;
mod.C_OLDCUST = ltlC_CUST_NAME.Text;
mod.C_NEWCUST = txtC_CGC.Value.Trim();
mod.C_OLDCON = ltlC_CON_NO.Text; //原资源合同
mod.C_NEWCON = txtNeedCon.Text.Trim() == "" ? ltlC_CON_NO.Text : txtNeedCon.Text.Trim(); //需求合同
mod.C_EMPID = ltlempid.Text;
mod.C_EMPNAME = ltlempname.Text;
mod.C_STD_CODE = ltlstdcode.Text;
mod.C_JUDGE_LEV = ltllev.Text;
mod.C_PACK = ltlpack.Text;
list.Add(mod);
#endregion
}
}
if (result2)
{
#region //在途量/库存量
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tpwgt = Convert.ToDecimal(dt.Rows[i]["wgt"]);
DataTable dtfyzt = tmo_order.ZTWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString(), dt.Rows[i]["custname"].ToString(), dt.Rows[i]["conno"].ToString()).Tables[0];
if (dtfyzt.Rows.Count > 0) //在途量
{
ztwgt = Convert.ToDecimal(dtfyzt.Compute("sum(N_FYWGT)", "true")); //合计在途量
}
DataTable dtkc = tmo_order.KCWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString(), dt.Rows[i]["custname"].ToString(), dt.Rows[i]["conno"].ToString()).Tables[0];
if (dtkc.Rows.Count > 0)//库存量
{
if (!string.IsNullOrEmpty(dtkc.Rows[0]["N_WGT"].ToString()))
{
kcwgt = Convert.ToDecimal(dtkc.Rows[0]["N_WGT"]);//合计在途量
}
}
kfwgt = kcwgt - ztwgt;
if (tpwgt > kfwgt)
{
result = false;
break;
}
}
}
#endregion
#region //执行调配资源
if (dropflag.SelectedValue == "Y") //已判执行
{
if (result) //判断当前发运数量已超出可发运量
{
if (list.Count > 0)
{
if (tmc_roll_deploy_log.InsertRoll_Proc3(list))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配成功');</script>", false);
BindList();
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> close();</script>", false);
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配资源，存在发运单占用其中客户资源');</script>", false);
}
}
else
{
#region//待判执行
if (list.Count > 0)
{
if (tmc_roll_deploy_log.InsertRoll_Proc3(list))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('调配成功');</script>", false);
BindList();
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> close();</script>", false);
}
#endregion
}
#endregion
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "", "<script language='javascript'> _closemsg('其中资源涉及跨区调配，请重新选择！');</script>", false);
}
}
