void btnOK_Click(object sender, EventArgs e)
{
try
{
//将确认结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int creatorid = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
//生成回收检验传递表--质检人员
SrinInspectorVerifyTransfer sivt = new SrinInspectorVerifyTransfer();
sivt.SrinProduceVerifyTransferID = _transferid;
sivt.Remark = txtRemark.Text.Trim();
sivt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sivt.Creator = creatorid;
sivt.TaskID = _taskid;
db.SrinInspectorVerifyTransfer.InsertOnSubmit(sivt);
db.SubmitChanges();
//生成质检清单
SrinInspectorVerifyDetails sivd;
foreach (GridViewRow gvr in this.spgvMaterial.Rows)
{
sivd = new SrinInspectorVerifyDetails();
sivd.SrinInspectorVerifyTransferID = sivt.SrinInspectorVerifyTransferID;
sivd.SrinMaterialVerifyDetailsID = Convert.ToInt32(gvr.Cells[13].Text);
sivd.QualifiedGentaojian = Convert.ToDecimal((gvr.Cells[4].Controls[0] as TextBox).Text.Trim());
sivd.RepairGentaojian = Convert.ToDecimal((gvr.Cells[5].Controls[0] as TextBox).Text.Trim());
sivd.RejectGentaojian = Convert.ToDecimal((gvr.Cells[6].Controls[0] as TextBox).Text.Trim());
sivd.VerifyCode = (gvr.Cells[7].Controls[0] as TextBox).Text.Trim();
sivd.RealVerifyTime = (gvr.Cells[8].Controls[0] as DateTimeControl).SelectedDate;
sivd.Remark = (gvr.Cells[12].Controls[0] as TextBox).Text.Trim();
sivd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sivd.Creator = creatorid;
db.SrinInspectorVerifyDetails.InsertOnSubmit(sivd);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("RiInspectorVerifyDetailsMessage.aspx?TaskID={0}", _taskid), 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 BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinInspectorVerifyTransfer sivt = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.TaskID == _taskid);
((Label)GetControltByMaster("lblProject")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.CreateTime.ToLongDateString(), sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblCode")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinVerifyTransferCode;
((Label)GetControltByMaster("lblMaterial")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.EmpInfo.EmpName;
((Label)GetControltByMaster("lblReadyWork")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.ReadyWorkIsFinished ? "是" : "否";
((Label)GetControltByMaster("lblProduce")).Text = sivt.SrinProduceVerifyTransfer.EmpInfo.EmpName;
((Label)GetControltByMaster("lblVerifyTime")).Text = sivt.SrinProduceVerifyTransfer.VerifyTime.ToLongDateString();
//初始化回收检验物资
this.spgvMaterial.DataSource = from a in db.SrinInspectorVerifyDetails
where a.SrinInspectorVerifyTransferID == _transferid
select new
{
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.TotleGentaojian,
a.QualifiedGentaojian,
a.RepairGentaojian,
a.RejectGentaojian,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileInfo.PileName,
a.SrinMaterialVerifyDetails.RetrieveTime,
a.RealVerifyTime,
a.VerifyCode,
a.Remark,
a.SrinInspectorVerifyDetailsID
};
this.spgvMaterial.DataBind();
//初始化表尾
if (!Page.IsPostBack)
{
txtRemark.Text = sivt.Remark;
}
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinInspectorVerifyTransfer sivt = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.TaskID == GetPreviousTaskID(0, _taskid));
((Label)GetControltByMaster("lblProject")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sivt.CreateTime.ToLongDateString(), sivt.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblInspector")).Text = sivt.EmpInfo.EmpName;
//初始化质检待修复物资
spgvMaterial.DataSource = from a in db.SrinInspectorVerifyDetails
where a.SrinInspectorVerifyTransferID == _transferid &&
a.RepairGentaojian != 0
select new
{
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName,
a.RepairGentaojian,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
a.VerifyCode,
a.Remark,
a.SrinInspectorVerifyDetailsID
};
this.spgvMaterial.DataBind();
if (bcreated)//分支流程--已经生成报告的情况
{
if (!Page.IsPostBack)
{
SrinRepairReport srrp = db.SrinRepairReport.SingleOrDefault(u => u.TaskID.Equals(_taskid));
txtCode.Text = srrp.SrinRepairReportCode;
txtRemark.Text = srrp.Remark;
dtcCreateTime.SelectedDate = srrp.CreateTime;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
SrinInspectorVerifyTransfer sivt = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.TaskID.Equals(_taskid));
if (sivt != null)//分支流程--已经生成质检清单的情况
{
//质检清单已经处理的情况
int count = db.TaskStorageIn.Count(u => u.StorageInType.Equals("回收入库") && (u.TaskType.Equals("资产组处理合格物资") || u.TaskType.Equals("生产组申请维修")) && u.StorageInID.Equals(sivt.SrinInspectorVerifyTransferID));
count += db.MessageInfo.Count(u => u.TaskID.Equals(_taskid));
if (count != 0)
{
Response.Redirect(string.Format("RiInspectorVerifyDetailsMessage.aspx?TaskID={0}", _taskid), false);
}
else
{
Response.Redirect(string.Format("RiInspectorModifyVerifyDetails.aspx?TaskID={0}", _taskid), false);
}
return;
}
_formid = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid)).StorageInID;
}
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));
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinInspectorVerifyTransfer sivt = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.SrinInspectorVerifyTransferID.Equals(_transferid));
((Label)GetControltByMaster("lblProject")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sivt.CreateTime.ToLongDateString(), sivt.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblInspector")).Text = sivt.EmpInfo.EmpName;
//初始化质检合格物资
if (_tasktype.Equals("资产组处理合格物资"))
{
this.spgvMaterial.DataSource = (from a in db.StorageOutRealDetails
where a.StorageOutNotice.ProjectID == sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectID &&
(from b in db.SrinInspectorVerifyDetails
where b.SrinInspectorVerifyTransferID.Equals(_transferid) && b.QualifiedGentaojian != 0
select b.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID).Contains(a.StorageOutDetails.MaterialID)
join c in db.SrinInspectorVerifyDetails on new { a.StorageOutDetails.MaterialID, TransferID = _transferid } equals new { c.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, TransferID = c.SrinInspectorVerifyTransferID }
join d in db.StorageStocks on new { a.StorageOutDetails.MaterialID, Status = a.MaterialStatus, a.StocksID } equals new { d.MaterialID, d.Status, d.StocksID }
orderby a.StorageOutDetails.MaterialID, a.CreateTime ascending
select new
{
MaterialName = string.Format("{0}--规格型号：{1}", d.MaterialName, d.SpecificationModel),
d.ManufacturerName,
d.UnitPrice,
d.CurUnit,
c.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
c.VerifyCode,
c.SrinInspectorVerifyDetailsID,
c.Remark,
d.ManufacturerID,
Description = string.Format("财务编码：{0}--回收合格数量(根/台/套/件)：{1}", d.FinanceCode, c.QualifiedGentaojian)
}).Distinct();
}
else
{
spgvMaterial.DataSource = (from a in db.StorageOutRealDetails
where a.StorageOutNotice.ProjectID == sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectID &&
(from b in db.SrinInspectorVerifyDetails
where b.SrinInspectorVerifyTransferID.Equals(_transferid) && b.QualifiedGentaojian != 0
select b.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID).Contains(a.StorageOutDetails.MaterialID)
join c in db.SrinInspectorVerifyRDetails on new { a.StorageOutDetails.MaterialID, TransferID = _transferid } equals new { c.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, TransferID = c.SrinInspectorVerifyDetails.SrinInspectorVerifyTransferID }
join d in db.StorageStocks on new { a.StorageOutDetails.MaterialID, Status = a.MaterialStatus, a.StocksID } equals new { d.MaterialID, d.Status, d.StocksID }
orderby a.StorageOutDetails.MaterialID, a.CreateTime ascending
select new
{
MaterialName = string.Format("{0}--规格型号：{1}", d.MaterialName, d.SpecificationModel),
d.ManufacturerName,
d.UnitPrice,
d.CurUnit,
c.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
c.VerifyCode,
c.SrinInspectorVerifyDetailsID,
c.Remark,
d.ManufacturerID,
Description = string.Format("财务编码：{0}--回收合格数量(根/台/套/件)：{1}", d.FinanceCode, c.QualifiedGentaojian)
}).Distinct();
}
this.spgvMaterial.DataBind();
}
}