void btnSend_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var tp = from a in db.CommitInDirector
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"])
select a;
if (tp.ToArray().Length > 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复插入记录!')</script>");
return;
}
}
if (chbAgree.Checked == true)
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
//写入流程中的主任审核表
CommitInDirector sid = new CommitInDirector();
sid.CommitInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
MaterialInfo mi = db.MaterialInfo.SingleOrDefault(u => u.MaterialCode == this.gv.Rows[i].Cells[2].Text.ToString());
sid.MaterialID = mi.MaterialID;
sid.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString();
sid.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString());
sid.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString());
sid.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString());
sid.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString());
sid.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString();
sid.NumberQualified = 0;
sid.InspectionReportNum = this.gv.Rows[i].Cells[12].Text.ToString();
sid.InspectionTime = Convert.ToDateTime(this.gv.Rows[i].Cells[13].Text.ToString());
sid.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString());
sid.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[10].Text.ToString());
PileInfo pi = db.PileInfo.SingleOrDefault(u => u.PileCode == this.gv.Rows[i].Cells[15].Text.ToString());
sid.PileID = pi.PileID;
sid.financeCode = this.gv.Rows[i].Cells[16].Text.ToString();
sid.StorageTime = Convert.ToDateTime(this.gv.Rows[i].Cells[17].Text.ToString());
//这里不唯一要出问题。
sid.SupplierID = Convert.ToInt32(this.gv.Rows[i].Cells[25].Text.ToString());
var temp = from a in db.CommitInAudited
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"])
select new { a.MaterialsManager, a.WarehouseWorker, a.MaterialAccounting };
var list = temp.ToList();
sid.MaterialsManager = list[i].MaterialsManager;
sid.WarehouseWorker = list[i].WarehouseWorker;
sid.MaterialAccounting = list[i].MaterialAccounting;
sid.AuditStatus = this.gv.Rows[i].Cells[22].Text.ToString();
sid.AuditTime = Convert.ToDateTime(this.gv.Rows[i].Cells[23].Text.ToString());
sid.DirectorStatus = "已审批";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sid.DirectorTime = SevTime.First();
sid.Remark = this.gv.Rows[i].Cells[24].Text.ToString();
//sid.BatchIndex = this.gv.Rows[i].Cells[20].Text.ToString();
sid.Director = reEmpId(SPContext.Current.Web.CurrentUser.LoginName.ToString());
db.CommitInDirector.InsertOnSubmit(sid);
//写入库存表
TableOfStocks tos = new TableOfStocks();
tos.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
tos.StorageInType = "委外入库";
tos.MaterialID = mi.MaterialID;
tos.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString();
tos.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString());
tos.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString());
tos.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString());
tos.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString());
tos.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString();
tos.UnitPrice = sid.UnitPrice;
tos.NumberQualified = 0;
tos.PileID = pi.PileID;
tos.financeCode = sid.financeCode;
tos.StorageTime = sid.StorageTime;
tos.SupplierID = sid.SupplierID;
tos.MaterialsManager = list[i].MaterialsManager;
tos.WarehouseWorker = list[i].WarehouseWorker;
sid.Remark = sid.Remark;
db.TableOfStocks.InsertOnSubmit(tos);
db.SubmitChanges();
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (ts != null)
{
ts.TaskState = "已完成";
ts.InspectState = "已审核";
////修改代理任务完成状态
//ProxyDirector pd = db.ProxyDirector.SingleOrDefault(u => u.TaskID == Convert.ToInt32(Request.QueryString["TaskStorageID"]) && u.TaskProxy.TaskProxyType.TaskProxyTypeName == "正常入库");
//if (pd != null)
//{
// TaskProxy tp = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "正常入库" && u.ProxyPrincipal == pd.TaskProxy.ProxyPrincipal && u.TaskDispose == "未完成");
// tp.TaskDispose = "完成";
//}
}
db.SubmitChanges();
}
}
Response.Redirect("DirectorPass.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "");
}
else
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == tsi.StorageInID);
//发送新任务(回退任务)
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = "委外入库";
TSI.TaskTitle = "主任审批任务：" + tsi.TaskTitle.ToString() + "(未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "材料会计审核";
TSI.InspectState = "驳回";
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.CommitInCode + "的物资审批不合格原因：" + this.txtOpinion.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
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));
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//用户IE回退操作检验
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.StorageInID == _storageinid && u.TaskType == "主任审核" && u.InspectState == "未审核" && u.StorageInType == "委外入库");
if (tsi != null)
{
Response.Redirect("../../default-old.aspx", false);
return;
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
ts.TaskState = "已完成";
ts.InspectState = "已审核";
}
//审核完在主表StorageIn中填入入库类型
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == _storageinid);
si.ReceivingType = Convert.ToInt32(ddlReceivingType.SelectedValue);
int iDirector = reEmpId(txtDirector.Text.Trim());
if (iDirector == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
//在StorageInAudited表中填入审批主任
var Auditeds = from a in db.CommitInAudited
where a.CommitInID == _storageinid
select a;
foreach (CommitInAudited audited in Auditeds)
{
audited.Director = iDirector;
}
oldDor = iDirector;
iDirector = Proxy.send(iDirector, 2);
//发送新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(((Label)this.GetControltByMaster("lblCreator")).Text.Trim());
TSI.TaskTargetID = iDirector;
TSI.StorageInID = _storageinid;
TSI.StorageInType = "委外入库";
TSI.TaskTitle = ((TextBox)this.GetControltByMaster("txtTaskTitle")).Text.Trim();
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "主任审核";
//ProxyDirector pd = new ProxyDirector();
//TaskProxy TP = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "委外入库" && u.ProxyPrincipal == TSI.TaskTargetID);
//if (TSI.TaskType == "主任审核")
//{
// if (TP != null)
// {
// pd.TaskProxy.ProxyPrincipal = TP.ProxyPrincipal;
// pd.TaskID = TSI.TaskStorageID;
// pd.TaskProxyID = TP.TaskProxyID;
// pd.TaskProxy.ProxyFiduciary = TP.ProxyFiduciary;
// TSI.TaskTargetID = TP.ProxyFiduciary;
// TSI.TaskTitle = TP.EmpInfo.EmpName + "主任委托委外入库审批任务：" + TSI.TaskTitle;
// db.ProxyDirector.InsertOnSubmit(pd);
// }
//}
TSI.InspectState = "未审核";
TSI.Remark = ((TextBox)this.GetControltByMaster("txtRemark")).Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
TSI.QCBatch = "第一批";
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
//pd.TaskID = TSI.TaskStorageID;
//db.SubmitChanges();
//保存代理任务信息
Proxy.saveTask(TSI.TaskStorageID, Proxy.getProxyTaskId(oldDor, 2));
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 void BindGridView()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化TaskStoreIn信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(t => t.TaskStorageID == _taskstorageid);
if (tsi == null)
{
Response.Redirect(_errorpage);
return;
}
((Label)GetControltByMaster("labTaskCreater")).Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]";
((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString();
((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle;
((Label)GetControltByMaster("labRemark")).Text = tsi.Remark;
//初始化StoreInQualified信息
CommitIn siq = db.CommitIn.SingleOrDefault(s => s.CommitInID == _storageinid);
if (siq == null)
{
Response.Redirect(_errorpage);
return;
}
this.spgviewAuditControl.DataSource = from a in db.CommitInQualified
join b in db.CommitIn on a.CommitInID equals b.CommitInID
join c in db.MaterialInfo on a.MaterialID equals c.MaterialID
join d in db.PileInfo on a.PileID equals d.PileID
join e in db.SupplierInfo on a.SupplierID equals e.SupplierID
where a.CommitInID == this._storageinid
select new
{
a.CommitInQualifiedID,
b.CommitInQualifiedNum,
b.CommitInCode,
c.MaterialName,
c.MaterialCode,
a.SpecificationModel,
a.Quantity,
a.QuantityGentaojian,
a.QuantityMetre,
a.QuantityTon,
a.CurUnit,
a.InspectionTime,
a.InspectionReportNum,
a.UnitPrice,
a.Amount,
d.StorageInfo.StorageName,
d.PileCode,
a.financeCode,
a.StorageTime,
e.SupplierName,
MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName,
WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName,
a.Remark,
e.SupplierID,
MaterialsManagerID = a.MaterialsManager,
WarehouseWorkerID = a.WarehouseWorker,
};
this.spgviewAuditControl.DataBind();
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 1].Visible = false;
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 2].Visible = false;
this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 3].Visible = false;
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//判断所选质检批次是否在待质检表中
var tmp = from a in db.CommitInDetailed
where a.CommitInID == Convert.ToInt32(Request.QueryString["CommitInID"])
select new { a.CommitDetailedID };
if (tmp.ToArray().Length == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('无此待质检批次,请重新选择 ')</script>");
return;
}
//判断任务列表中是否已发过此条任务
var task = from a in db.TaskStorageIn
where a.StorageInID == Convert.ToInt32(Request.QueryString["CommitInID"]) && a.TaskType == currentFlow && a.StorageInType == storageInType
select new { a.TaskCreaterID, a.InspectState };
if (task.ToArray().Length != 0)
{
//如果是驳回的信息允许再次发送
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复发送相同任务 ')</script>");
return;
}
//修改完成状态
if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"]))
{
TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (ts != null)
{
ts.TaskState = "已完成";
}
}
//生成质检完成流水号
if (Request.QueryString["state"].ToString() == "材料会计审核")
{
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == Convert.ToInt32(Request.QueryString["CommitInID"]));
si.CommitInQualifiedNum = this.txtMessageCode.Text.Trim();
}
//发送新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(this.lblCreator.Text.Trim());
TSI.TaskTargetID = reEmpId(this.txtRecipient.Text.Trim());
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["CommitInID"]);
TSI.StorageInType = storageInType;
TSI.TaskTitle = this.txtTaskTitle.Text.Trim();
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = Request.QueryString["state"].ToString();
TSI.InspectState = "未审核";
TSI.QCBatch = "第一批";//无批次默认为第一批
TSI.Remark = this.txtRemark.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
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));
}
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
string strTaskID = this.Request.QueryString["TaskStorageID"];
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(a => a.TaskStorageID == int.Parse(strTaskID));
if (tsi == null)
{
Response.Redirect(strUrl);
}
Label labTaskCreater = (Label)GetControltByMaster("labTaskCreater");
labTaskCreater.Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]";
((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString();
((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle;
((Label)GetControltByMaster("labRemark")).Text = tsi.Remark;
string strID = this.Request.QueryString["StorageInID"];
CommitIn si = db.CommitIn.SingleOrDefault(a => a.CommitInID == int.Parse(strID));
if (si == null)
{
Response.Redirect(strUrl);
}
BoundField bf = new BoundField();
BoundField bfColumn;
//TemplateField tfieldTextBox = new TemplateField();
//tfieldTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "CommitDetailedID", "txtCount");
//tfieldTextBox.HeaderTemplate = new MulTextBoxTemplate("合格数量", DataControlRowType.Header);
//tfieldTextBox.ItemStyle.Width = 150;
TemplateField GentaojianTextBox = new TemplateField();
GentaojianTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtGentaojian");
GentaojianTextBox.HeaderTemplate = new MulTextBoxTemplate("根/套/件", DataControlRowType.Header);
GentaojianTextBox.ItemStyle.Width = 150;
TemplateField MetreTextBox = new TemplateField();
MetreTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtMetre");
MetreTextBox.HeaderTemplate = new MulTextBoxTemplate("米", DataControlRowType.Header);
MetreTextBox.ItemStyle.Width = 150;
TemplateField TonTextBox = new TemplateField();
TonTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtTon");
TonTextBox.HeaderTemplate = new MulTextBoxTemplate("吨", DataControlRowType.Header);
TonTextBox.ItemStyle.Width = 150;
TemplateField reportTextBox = new TemplateField();
reportTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "CommitDetailedID", "txtQualityNum");
reportTextBox.HeaderTemplate = new MulTextBoxTemplate("质检报告号", DataControlRowType.Header);
reportTextBox.ItemStyle.Width = 150;
foreach (var kvp in Tlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewQualityControl.Columns.Add(bfColumn);
}
this.spgviewQualityControl.Columns.Insert(10, GentaojianTextBox);
this.spgviewQualityControl.Columns.Insert(11, MetreTextBox);
this.spgviewQualityControl.Columns.Insert(12, TonTextBox);
//this.spgviewQualityControl.Columns.Insert(13, tfieldTextBox);
this.spgviewQualityControl.Columns.Insert(13, reportTextBox);
this.spgviewQualityControl.DataSource = from a in db.CommitInDetailed
join b in db.CommitIn on a.CommitInID equals b.CommitInID
join c in db.MaterialInfo on a.MaterialID equals c.MaterialID
join d in db.PileInfo on a.PileID equals d.PileID
join e in db.SupplierInfo on a.SupplierID equals e.SupplierID
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"])
select new
{
a.CommitDetailedID,
b.CommitInCode,
a.SpecificationModel,
c.MaterialName,
c.MaterialCode,
a.Quantity,
a.UnitPrice,
a.Amount,
d.StorageInfo.StorageName,
d.PileCode,
a.financeCode,
a.StorageTime,
e.SupplierName,
a.QuantityGentaojian,
a.QuantityMetre,
a.QuantityTon,
a.CurUnit,
MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName,
WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName,
a.Remark,
e.SupplierID
};
this.spgviewQualityControl.DataBind();
this.spgviewQualityControl.Columns[0].Visible = false;
this.spgviewQualityControl.Columns[this.spgviewQualityControl.Columns.Count - 1].Visible = false;
p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgviewQualityControl);
}
}
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_QUERYERROR));
}
}
void btnEdit_Click(object sender, EventArgs e)
{
try
{
//检查输入格式
if (CheckStringEmpty() != true)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将数据填写完整,且合格数量只能是数字 ')</script>");
return;
}
//检查输入数据是否溢出
if (CheckOverFlow() != true)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('合格数量不能超过质检前数量! ')</script>");
return;
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
var task = from a in db.TaskStorageIn
where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.TaskType == "质检" && a.InspectState == "驳回" && a.TaskState == "未完成" && a.StorageInType == "委外入库"
select new { a.TaskCreaterID, a.InspectState };
//如果是回退到质检的调拨单
if (task.ToList().Count > 0)
{
//更新
var tep = from a in db.CommitInQualified
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString())
orderby a.CommitInQualifiedID ascending
select new { a.CommitInQualifiedID };
var li = tep.ToList();
for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++)
{
CommitInQualified SIQ = new CommitInQualified();
SIQ = db.CommitInQualified.SingleOrDefault(u => u.CommitInQualifiedID == li[i].CommitInQualifiedID);
TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]);
SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim());
TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]);
SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim());
TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]);
SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim());
TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]);
SIQ.InspectionReportNum = ti.Text.Trim();
db.SubmitChanges();
}
//旧任务
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == tsi.StorageInID);
//新任务
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]);
TSI.StorageInType = tsi.StorageInType;
TSI.TaskTitle = "交货通知单编号为:" + si.CommitInCode + "的物资已质检，请重新审核";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "材料会计审核";
TSI.InspectState = "未审核";
TSI.Remark = "交货通知单编号为:" + si.CommitInCode + "的物资已重新质检";
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
db.SubmitChanges();
Response.Redirect("../../default-old.aspx", false);
}
else
{
//更新数据
var tep = from a in db.CommitInQualified
where a.CommitInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString())
orderby a.CommitInQualifiedID ascending
select new { a.CommitInQualifiedID };
var li = tep.ToList();
for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++)
{
CommitInQualified SIQ = new CommitInQualified();
SIQ = db.CommitInQualified.SingleOrDefault(u => u.CommitInQualifiedID == li[i].CommitInQualifiedID);
TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]);
SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim());
TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]);
SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim());
TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]);
SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim());
TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]);
SIQ.InspectionReportNum = ti.Text.Trim();
db.SubmitChanges();
}
Response.Redirect("QualifiedCommitIn.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "");
}
}
}
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_UPDATEERROR));
}
}
/// <summary>
/// 发回重新质检
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnReCheck_Click(object sender, EventArgs e)
{
try
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//从审核表中删除此批次记录,之前写过库
var siaTemp = from a in db.CommitInAudited
where a.CommitInID == _storageinid
select new { a.CommitInAuditedID };
for (int i = 0; i < siaTemp.ToList().Count; i++)
{
CommitInAudited sia = db.CommitInAudited.SingleOrDefault(a => a.CommitInAuditedID == siaTemp.ToList()[i].CommitInAuditedID);
if (sia != null)
{
db.CommitInAudited.DeleteOnSubmit(sia);
}
}
db.SubmitChanges();
//任务信息
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid);
tsi.TaskState = "已完成";
tsi.InspectState = "已审核";
CommitIn si = db.CommitIn.SingleOrDefault(u => u.CommitInID == tsi.StorageInID);
//发送新任务(回退任务)
TaskStorageIn TSI = new TaskStorageIn();
TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
TSI.TaskTargetID = tsi.TaskCreaterID;
if (TSI.TaskTargetID == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户，请同步AD账户 ')</script>");
return;
}
TSI.StorageInID = _storageinid;
TSI.StorageInType = tsi.StorageInType;
TSI.TaskTitle = "材料会计审核任务：" + tsi.TaskTitle.ToString() + "(未通过)";
TSI.TaskState = "未完成";
TSI.TaskDispose = "未废弃";
TSI.TaskType = "质检";
TSI.InspectState = "驳回";
TSI.QCBatch = tsi.QCBatch;
TSI.Remark = "交货通知单编号为:" + si.CommitInCode + "的物资审核不合格原因：" + this.txtOpinion.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
TSI.CreateTime = SevTime.First();
db.TaskStorageIn.InsertOnSubmit(TSI);
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));
}
}
