public void btnSave_Click(object sender, EventArgs e)
{
using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//修改上一条记录
StockTransferTask st = dc.StockTransferTask.SingleOrDefault(a => a.StockTransferID == Convert.ToInt32(Request.QueryString["StockTransferID"]) && a.TaskInType == "移库任务" && a.TaskState == "未完成");
if (st != null)
{
st.TaskState = "已完成";
}
//创建下一条记录
StockTransferTask stt = new StockTransferTask();
stt.Remark = ((TextBox)this.GetControltByMaster("txtRemark")).Text.Trim();
stt.StockTransferID = Convert.ToInt32(Request.QueryString["StockTransferID"]);
stt.TaskCreaterID = reEmpId(((Label)this.GetControltByMaster("lblCreator")).Text.Trim());
stt.TaskInType = "移库任务";
stt.TaskState = "未完成";
stt.TaskTargetID = reEmpId(txtExecutor.Text.Trim());
stt.TaskTitle = ((TextBox)this.GetControltByMaster("txtTaskTitle")).Text.Trim();
stt.TaskType = Request.QueryString["TaskType"];
stt.CreateTime = dc.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
dc.StockTransferTask.InsertOnSubmit(stt);
dc.SubmitChanges();
Response.Redirect(strBackUrl);
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
//将审核结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st1 = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
//页面已处理完毕就直接跳转到发送任务界面
if (((Panel)GetControltByMaster("PanelDone")).Visible == true)
{
Response.Redirect("StockTransferCreateTask.aspx?StockTransferID=" + st1.StockTransferID + "&&TaskType=材料会计审核&&BackUrl=" + HttpContext.Current.Request.Url.PathAndQuery);
}
//通過
//验证是否都有内容
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
st.AcceptTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
st.AuditOpinion = "";
st.AuditStatus = "审核通过";
st.TaskState = "已完成";
db.SubmitChanges();
Response.Redirect("StockTransferCreateTask.aspx?StockTransferID=" + st1.StockTransferID + "&&TaskType=材料会计审核&&BackUrl=" + HttpContext.Current.Request.Url.PathAndQuery);
//获取userid
// stNew.TaskTargetID = reEmpId(txtUser.Text.Trim());
}
Response.Redirect("../../default-old.aspx", false);
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
// private Panel panelUser;
//Literal L1;
protected void Page_Load(object sender, EventArgs e)
{
try
{
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StockTransferTask stt = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
if (stt != null)
{
// StockTransfer st = db.StockTransfer.SingleOrDefault(a => a.StockTransferID == stt.StockTransferID);
_noticeid = stt.StockTransferID;
var t = db.StockTransferTask.Where(a => a.StockTransferID == stt.StockTransferID && a.TaskInType == stt.TaskInType).OrderBy(a => a.StockTransferTaskID).First();
stt = t;
//加载任务相关信息
Label lblReceiver = (Label)GetControltByMaster("lblReceiver");
lblReceiver.Text = stt.EmpInfo.EmpName;
Label lblDate = (Label)GetControltByMaster("lblDate");
lblDate.Text = stt.CreateTime.ToShortTimeString();
StockTransfer sts = db.StockTransfer.SingleOrDefault(a => a.StockTransferID == stt.StockTransferID);
if (sts != null)
{
Label lblNoticeCode = (Label)GetControltByMaster("lblNoticeCode");
lblNoticeCode.Text = sts.StockTransferNum;
}
//加载过往批复信息
//获取物资组长审核信息记录
stStart = db.StockTransferTask.Where(a => a.StockTransferID == stt.StockTransferID && a.TaskType == "物资组长审核信息").OrderByDescending(a => a.StockTransferTaskID).First();
if (stStart != null)
{
Label lblsta = (Label)GetControltByMaster("lblsta");
lblsta.Text = stStart.AuditStatus;
Label lbluser = (Label)GetControltByMaster("lbluser");
lbluser.Text = stStart.EmpInfo1.EmpName;
Label lbldete = (Label)GetControltByMaster("lbldete");
lbldete.Text = stStart.AcceptTime.ToString();
((Label)GetControltByMaster("lblop")).Text = stStart.AuditOpinion;
}
//获取生产组长审核记录
//stStart = db.StockTransferTask.SingleOrDefault(a => a.StockTransferID == stt.StockTransferID && a.TaskType == "生产组长审核信息");
stStart = db.StockTransferTask.Where(a => a.StockTransferID == stt.StockTransferID && a.TaskType == "生产组长审核信息").OrderByDescending(a => a.StockTransferTaskID).First();
if (stStart != null)
{
Label lblsta0 = (Label)GetControltByMaster("lblsta0");
lblsta0.Text = stStart.AuditStatus;
Label lbluser0 = (Label)GetControltByMaster("lbluser0");
lbluser0.Text = stStart.EmpInfo1.EmpName;
Label lbldete0 = (Label)GetControltByMaster("lbldete0");
lbldete0.Text = stStart.AcceptTime.ToString();
((Label)GetControltByMaster("lblop0")).Text = stStart.AuditOpinion;
}
//获取提交材料会计审核记录
stStart = db.StockTransferTask.Where(a => a.StockTransferID == stt.StockTransferID && a.TaskType == "发起人确认").OrderByDescending(a => a.StockTransferTaskID).First();
if (stStart != null)
{
Label lblsta0 = (Label)GetControltByMaster("lblsta1");
lblsta0.Text = stStart.AuditStatus;
Label lbluser0 = (Label)GetControltByMaster("lbluser1");
lbluser0.Text = stStart.EmpInfo1.EmpName;
Label lbldete0 = (Label)GetControltByMaster("lbldete1");
lbldete0.Text = stStart.AcceptTime.ToString();
}
////判断是否已经发送过任务
//var n = db.StockTransferTask.Where(a => a.StockTransferID == stt.StockTransferID && a.TaskInType == stt.TaskInType).OrderByDescending(a => a.StockTransferTaskID).First();
btnOK = (Button)GetControltByMaster("btnOK");
//if (n.StockTransferTaskID > _taskid)
//{
// //任务已发送
// btnOK.Enabled = false;
//}
//else
//{
// //任务未发送
// btnOK.Enabled = true;
// btnOK.Text = "申请者接收";
//}
//判断任务是否已经完成
StockTransferTask stt2 = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
if (stt2.TaskState == "已完成")
{
((Panel)GetControltByMaster("PanelDone")).Visible = true;
((Panel)GetControltByMaster("PanelOp")).Visible = false;
//载入数据
((Label)GetControltByMaster("lblsta2")).Text = stt2.AuditStatus;
((Label)GetControltByMaster("lbluser2")).Text = stt2.EmpInfo1.EmpName;
((Label)GetControltByMaster("lbldete2")).Text = stt2.AcceptTime.ToString();
((Label)GetControltByMaster("lblop2")).Text = stt2.AuditOpinion;
// 任务已完成
btnOK.Enabled = false;
}
else
{
((Panel)GetControltByMaster("PanelDone")).Visible = false;
((Panel)GetControltByMaster("PanelOp")).Visible = true;
//任务未完成
btnOK.Enabled = true;
btnOK.Text = "材料会计审核";
}
}
}
//txtUser = (TextBox)GetControltByMaster("txtUser");
//L1 = (Literal)GetControltByMaster("L1");
//L1.Text = JSDialogAid.GetJSForDialog(txtUser.ClientID, "../StorageAndPile/SelectUser.aspx");
InitializeCustomControls();
BindDataToCustomControls();
ShowCustomControls();
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR));
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
//将审核结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (this.chbAgree.Checked)
{
//通過
//验证是否都有内容
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
bool done = false;
string strMessage = "";
//修改所有数量
var std = db.StockTransferDetail.Where(a => a.StockTransferID == st.StockTransferID);
foreach (var n in std)
{
//获取原有库存对象
var ts = n.TableOfStocks;
//判断是否足够数量进行运算
//获取原有数
decimal dcmT = 0;
decimal dcmT1 = 0;
decimal dcmT2 = 0;
decimal dcmT3 = 0;
decimal.TryParse(ts.QuantityGentaojian.ToString(), out dcmT);
decimal.TryParse(ts.QuantityMetre.ToString(), out dcmT1);
decimal.TryParse(ts.QuantityTon.ToString(), out dcmT2);
decimal.TryParse(ts.Quantity.ToString(), out dcmT3);
//获取移库数
//获取原有数
decimal dcmC = 0;
decimal dcmC1 = 0;
decimal dcmC2 = 0;
decimal dcmC3 = 0;
decimal.TryParse(n.QuantityGentaojian.ToString(), out dcmC);
decimal.TryParse(n.QuantityMetre.ToString(), out dcmC1);
decimal.TryParse(n.QuantityTon.ToString(), out dcmC2);
decimal.TryParse(n.Quantity.ToString(), out dcmC3);
if (dcmT - dcmC >= 0 && dcmT1 - dcmC1 >= 0 && dcmT2 - dcmC2 >= 0 && dcmT3 - dcmC3 >= 0)
{
//插入
TableOfStocks tsNew = new TableOfStocks();
tsNew.CurUnit = ts.CurUnit;
tsNew.financeCode = ts.financeCode;
tsNew.MaterialID = ts.MaterialID;
tsNew.MaterialsManager = ts.MaterialsManager;
tsNew.NumberQualified = ts.NumberQualified;
tsNew.PileID = n.TargetPile;
tsNew.Quantity = dcmC3;
tsNew.QuantityGentaojian = dcmC;
tsNew.QuantityMetre = dcmC1;
tsNew.QuantityTon = dcmC2;
tsNew.Remark = ts.Remark;
tsNew.SpecificationModel = ts.SpecificationModel;
tsNew.StorageInID = ts.StorageInID;
tsNew.StorageInType = ts.StorageInType;
tsNew.StorageTime = ts.StorageTime;
tsNew.SupplierID = ts.SupplierID;
tsNew.UnitPrice = ts.UnitPrice;
tsNew.WarehouseWorker = ts.WarehouseWorker;
db.TableOfStocks.InsertOnSubmit(tsNew);
//减数
ts.Quantity = dcmT3 - dcmC3;
ts.QuantityGentaojian = dcmT - dcmC;
ts.QuantityMetre = dcmT1 - dcmC1;
ts.QuantityTon = dcmT2 - dcmC2;
done = true;
}
else
{
strMessage += "移库失败!从" + ts.PileInfo.StorageInfo.StorageName + "|" + ts.PileInfo.PileName + "处移动到" + n.PileInfo.StorageInfo.StorageName + "|" + n.PileInfo.PileName + "失败!请检查数量是否足够!\br";
done = false;
break;
}
}
if (done)
{
st.AcceptTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
st.AuditOpinion = this.txtOpinion.Text.Trim();
st.AuditStatus = "审核通过";
st.TaskState = "已完成";
//写入新的内容
db.SubmitChanges();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('" + strMessage + "')</script>");
Response.AddHeader("Refresh", "0");
}
}
else
{
//未通過
//通過
//验证是否都有内容
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
st.AcceptTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
st.AuditOpinion = this.txtOpinion.Text.Trim();
st.AuditStatus = "审核未通过";
st.TaskState = "已完成";
//写入新的内容
StockTransferTask st0 = db.StockTransferTask.Where(a => a.StockTransferID == st.StockTransferID).OrderBy(a => a.StockTransferTaskID).First();
StockTransferTask stt = new StockTransferTask();
stt.Remark = this.txtOpinion.Text.Trim();
stt.StockTransferID = st.StockTransferID;
stt.TaskCreaterID = st.TaskTargetID;
stt.TaskInType = "移库任务";
stt.TaskState = "未完成";
stt.TaskTargetID = st0.TaskCreaterID;
stt.TaskTitle = st.TaskTitle + "[材料会计审核未通过]";
stt.TaskType = "发起人修改";
stt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.StockTransferTask.InsertOnSubmit(stt);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
//获取userid
// stNew.TaskTargetID = reEmpId(txtUser.Text.Trim());
}
// Response.Redirect("../../default-old.aspx", false);
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
//将审核结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st1 = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
//页面已处理完毕就直接跳转到发送任务界面
if (((Panel)GetControltByMaster("PanelDone")).Visible == true)
{
Response.Redirect("StockTransferCreateTask.aspx?StockTransferID=" + st1.StockTransferID + "&&TaskType=生产组长审核信息&&BackUrl=" + HttpContext.Current.Request.Url.PathAndQuery);
}
if (this.chbAgree.Checked)
{
//通過
//验证是否都有内容
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
st.AcceptTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
st.AuditOpinion = this.txtOpinion.Text.Trim();
st.AuditStatus = "审核通过";
st.TaskState = "已完成";
//db.SubmitChanges();
var all = from a in db.StockTransferDetail
where a.StockTransferID == st.StockTransferID
select a;
bool done = true;
foreach (var single in all)
{
switch (single.StocksStatus)
{
case "线上":
#region 改线上
var ul = db.StockOnline.SingleOrDefault(a => a.StockOnlineID == single.StocksID);
decimal gen, meter, ton;
gen = decimal.Parse((ul.QuantityGentaojian - single.QuantityGentaojian).ToString());
meter = decimal.Parse((ul.QuantityMetre - single.QuantityMetre).ToString());
ton = decimal.Parse((ul.QuantityTon - single.QuantityTon).ToString());
if (gen < 0 || meter < 0 || ton < 0)
{
done = false;
}
//创建新纪录//修改原纪录
StockOnline so = new StockOnline();
so.Amount = ul.Amount;
so.AssetsManager = ul.AssetsManager;
so.BatchIndex = ul.BatchIndex;
so.BillCode = ul.BillCode;
so.CurUnit = ul.CurUnit;
so.ExpectedProject = ul.ExpectedProject;
so.ManufacturerID = ul.ManufacturerID;
so.MaterialCode = ul.MaterialCode;
so.MaterialID = ul.MaterialID;
so.MaterialsManager = ul.MaterialsManager;
so.OfflineGentaojian = ul.OfflineGentaojian;
so.OfflineMetre = ul.OfflineMetre;
so.OfflineTon = ul.OfflineTon;
so.ReceivingTypeName = ul.ReceivingTypeName;
so.Remark = ul.Remark;
so.StorageInCode = ul.StorageInCode;
so.StorageInID = ul.StorageInID;
so.StorageInType = ul.StorageInType;
so.StorageTime = ul.StorageTime;
so.SupplierID = ul.SupplierID;
so.UnitPrice = ul.UnitPrice;
so.CertificateNum = ul.CertificateNum;
so.CreateTime = DateTime.Now;
so.Creator = ul.Creator;
switch (ul.OnlineUnit)
{
case "根/台/套/件":
so.CurQuantity = single.QuantityGentaojian;
ul.CurQuantity = gen;
// so.OnlineTotal = gen * ul.OnlineUnitPrice;
break;
case "米":
so.CurQuantity = single.QuantityMetre;
ul.CurQuantity = meter;
break;
case "吨":
so.CurQuantity = single.QuantityTon;
ul.CurQuantity = ton;
break;
}
so.OnlineCode = ul.OnlineCode;
so.OnlineDate = ul.OnlineDate;
so.OnlineTotal = so.CurQuantity * ul.OnlineUnitPrice;
ul.OnlineTotal = ul.CurQuantity * ul.OnlineUnitPrice;
so.OnlineUnit = ul.OnlineUnit;
so.OnlineUnitPrice = ul.OnlineUnitPrice;
so.OrderNum = ul.OrderNum;
so.QuantityGentaojian = single.QuantityGentaojian;
ul.QuantityGentaojian = gen;
so.QuantityMetre = single.QuantityMetre;
ul.QuantityMetre = meter;
so.QuantityTon = single.QuantityTon;
ul.QuantityTon = ton;
// so.TableOfStocksID = ul.TableOfStocksID;
so.PileID = single.TargetPile;
db.StockOnline.InsertOnSubmit(so);
#endregion
break;
case "线下":
#region 改线下
var un = db.TableOfStocks.SingleOrDefault(a => a.StocksID == single.StocksID);
gen = decimal.Parse((un.QuantityGentaojian - single.QuantityGentaojian).ToString());
meter = decimal.Parse((un.QuantityMetre - single.QuantityMetre).ToString());
ton = decimal.Parse((un.QuantityTon - single.QuantityTon).ToString());
if (gen < 0 || meter < 0 || ton < 0)
{
done = false;
}
//创建新纪录//修改原纪录
TableOfStocks tos = new TableOfStocks();
tos.AssetsManager = un.AssetsManager;
tos.BatchIndex = un.BatchIndex;
tos.BillCode = un.BillCode;
tos.CreateTime = DateTime.Now;
tos.Creator = un.Creator;
tos.CurUnit = un.CurUnit;
tos.ExpectedProject = un.ExpectedProject;
tos.ManufacturerID = un.ManufacturerID;
tos.MaterialCode = un.MaterialCode;
tos.MaterialID = un.MaterialID;
tos.MaterialsManager = un.MaterialsManager;
tos.PileID = single.TargetPile;
tos.QuantityGentaojian = single.QuantityGentaojian;
un.QuantityGentaojian = gen;
tos.QuantityMetre = single.QuantityMetre;
un.QuantityMetre = meter;
tos.QuantityTon = single.QuantityTon;
un.QuantityTon = ton;
tos.ReceivingTypeName = un.ReceivingTypeName;
tos.Remark = un.Remark;
tos.StorageID = single.PileInfo.StorageInfo.StorageID;
tos.StorageInCode = un.StorageInCode;
tos.StorageInID = un.StorageInID;
tos.StorageInType = un.StorageInType;
tos.StorageTime = un.StorageTime;
tos.SupplierID = un.SupplierID;
tos.UnitPrice = un.UnitPrice;
switch (tos.CurUnit)
{
case "根/台/套/件":
tos.Amount = decimal.Parse(tos.QuantityGentaojian.ToString()) * tos.UnitPrice;
un.Amount = gen * un.UnitPrice;
// so.OnlineTotal = gen * ul.OnlineUnitPrice;
break;
case "米":
tos.Amount = decimal.Parse(tos.QuantityMetre.ToString()) * tos.UnitPrice;
un.Amount = meter * un.UnitPrice;
break;
case "吨":
tos.Amount = decimal.Parse(tos.QuantityTon.ToString()) * tos.UnitPrice;
un.Amount = ton * un.UnitPrice;
break;
}
db.TableOfStocks.InsertOnSubmit(tos);
#endregion
break;
case "回收合格":
#region 回收
var ur = db.QualifiedStocks.SingleOrDefault(a => a.StocksID == single.StocksID);
gen = decimal.Parse((ur.Gentaojian - single.QuantityGentaojian).ToString());
meter = decimal.Parse((ur.Metre - single.QuantityMetre).ToString());
ton = decimal.Parse((ur.Ton - single.QuantityTon).ToString());
if (gen < 0 || meter < 0 || ton < 0)
{
done = false;
}
//创建新纪录//修改原纪录
QualifiedStocks qs = new QualifiedStocks();
qs.CurUnit = ur.CurUnit;
qs.ManufactureID = ur.ManufactureID;
qs.MaterialID = ur.MaterialID;
qs.PileID = single.TargetPile;
qs.Remark = ur.Remark;
qs.RetrieveProjectID = ur.RetrieveProjectID;
qs.RetrieveTime = ur.RetrieveTime;
qs.StorageID = single.PileInfo.StorageInfo.StorageID;
qs.StorageTime = ur.StorageTime;
qs.UnitPrice = ur.UnitPrice;
qs.Gentaojian = decimal.Parse(single.QuantityGentaojian.ToString());
ur.Gentaojian = gen;
qs.Metre = decimal.Parse(single.QuantityMetre.ToString());
ur.Metre = meter;
qs.Ton = decimal.Parse(single.QuantityTon.ToString());
ur.Ton = ton;
switch (qs.CurUnit)
{
case "根/台/套/件":
qs.Amount = decimal.Parse(qs.Gentaojian.ToString()) * qs.UnitPrice;
ur.Amount = gen * ur.UnitPrice;
// so.OnlineTotal = gen * ul.OnlineUnitPrice;
break;
case "米":
qs.Amount = decimal.Parse(qs.Metre.ToString()) * qs.UnitPrice;
ur.Amount = meter * ur.UnitPrice;
break;
case "吨":
qs.Amount = decimal.Parse(qs.Ton.ToString()) * qs.UnitPrice;
ur.Amount = ton * ur.UnitPrice;
break;
}
db.QualifiedStocks.InsertOnSubmit(qs);
#endregion
break;
}
if (!done)
{
break;
}
}
if (done)
{
db.SubmitChanges();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", "移动数目超过库存数,请检查数据!"));
}
//Response.Redirect("StockTransferCreateTask.aspx?StockTransferID=" + st.StockTransferID + "&&TaskType=生产组长审核信息&&BackUrl=" + HttpContext.Current.Request.Url.PathAndQuery);
}
else
{
//未通過
//通過
//验证是否都有内容
_taskid = Convert.ToInt32(Request.QueryString["StockTransferTaskID"]);
StockTransferTask st = db.StockTransferTask.SingleOrDefault(a => a.StockTransferTaskID == _taskid);
st.AcceptTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
st.AuditOpinion = this.txtOpinion.Text.Trim();
st.AuditStatus = "审核未通过";
st.TaskState = "已完成";
//写入新的内容
StockTransferTask stt = new StockTransferTask();
stt.Remark = this.txtOpinion.Text.Trim();
stt.StockTransferID = st.StockTransferID;
stt.TaskCreaterID = st.TaskTargetID;
stt.TaskInType = "移库任务";
stt.TaskState = "未完成";
stt.TaskTargetID = st.TaskCreaterID;
stt.TaskTitle = st.TaskTitle + "[审核未通过]";
stt.TaskType = "发起人修改";
stt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.StockTransferTask.InsertOnSubmit(stt);
db.SubmitChanges();
}
}
Response.Redirect("../../default-old.aspx", false);
}
catch (Exception ex)
{
MethodBase mb = MethodBase.GetCurrentMethod();
LogToDBHelper lhelper = LogToDBHelper.Instance;
lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name));
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR));
}
}
