void btnOK_Click(object sender, EventArgs e)
{
try
{
//保存清点结果
SrinStocktaking sst;
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
sst = new SrinStocktaking();
sst.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
sst.StocktakingDate = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sst.SrinSubDocID = _subdocid;
sst.StocktakingResult = chbCheck.Checked ? "清点有误" : "清点无误";
sst.StocktakingProblem = txtProblem.Text.Trim();
sst.TaskID = _taskid;
db.SrinStocktaking.InsertOnSubmit(sst);
db.SubmitChanges();
//保存清点物资明细
int iDetailsID, iStorageID, iPileID;
SrinStocktakingDetails sstd;
foreach (GridViewRow gvr in this.spgvMaterial.Rows)
{
iDetailsID = Convert.ToInt32(gvr.Cells[10].Text);
iStorageID = Convert.ToInt32((gvr.Cells[6].Controls[0] as DropDownList).SelectedValue);
iPileID = Convert.ToInt32((gvr.Cells[7].Controls[0] as DropDownList).SelectedValue);
sstd = new SrinStocktakingDetails();
sstd.SrinStocktakingID = sst.SrinStocktakingID;
sstd.SrinSubDetailsID = iDetailsID;
sstd.StorageID = iStorageID == 0?new Nullable <int>():iStorageID;
sstd.PileID = iPileID == 0?new Nullable <int>():iPileID;
sstd.Remark = ((TextBox)gvr.Cells[9].Controls[0]).Text.Trim();
sstd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sstd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
db.SrinStocktakingDetails.InsertOnSubmit(sstd);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("RiMaterialStocktakingMessage.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))
{
//初始化清点信息
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid);
(GetControltByMaster("lblMaterial") as Label).Text = sst.EmpInfo.EmpName;
(GetControltByMaster("lblResult") as Label).Text = sst.StocktakingResult;
(GetControltByMaster("lblInventoryDate") as Label).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString());
(GetControltByMaster("lblOpinion") as Label).Text = sst.StocktakingProblem;
//初始化回收入库单信息
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinReceiptID == _receiptid);
((Label)GetControltByMaster("lblProject")).Text = srp.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblAsset")).Text = srp.EmpInfo.EmpName;
((Label)GetControltByMaster("lblCode")).Text = srp.SrinReceiptCode;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblRemark")).Text = srp.Remark;
this.spgvRepair.DataSource = from a in db.SrinRepairPlan
join b in db.TaskStorageIn on new { TaskID = a.TaskID, RepairPlanID = a.SrinRepairPlanID, TaskType = "维修保养物资组长审核" } equals new { TaskID = b.PreviousTaskID.Value, RepairPlanID = b.StorageInID, b.TaskType }
into c
from d in c.DefaultIfEmpty()
where a.SrinReceiptID == _receiptid
select new
{
a.Remark,
MaterialCount = a.SrinMaterialRepairDetails.Count,
a.CreateTime,
a.SrinRepairPlanCode,
a.SrinRepairPlanID,
MaterialChief = d == null ? "N/A" : d.EmpInfo1.EmpName,
};
this.spgvRepair.DataBind();
this.spgvVerify.DataSource = from v in db.SrinVerifyTransfer
where v.SrinReceiptID == _receiptid
select new
{
v.Remark,
MaterialCount = v.SrinMaterialVerifyDetails.Count,
v.CreateTime,
v.SrinVerifyTransferCode,
Ready = v.ReadyWorkIsFinished ? "已完成" : "未完成",
v.SrinVerifyTransferID
};
this.spgvVerify.DataBind();
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == db.TaskStorageIn.SingleOrDefault(v => v.TaskStorageID.Equals(_taskid)).StorageInID);
((Label)GetControltByMaster("lblCreater")).Text = ssd.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = ssd.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString());
//初始化回收分单中的物资
this.spgvMaterial.DataSource = from a in db.SrinStocktakingDetails
where a.SrinStocktakingID == _stocktakingid
select new
{
a.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinSubDetails.TotleGentaojian,
a.SrinSubDetails.TotleMetre,
a.SrinSubDetails.TotleTon,
a.SrinSubDetails.RetrieveCode,
a.StorageID,
a.PileID,
a.Remark,
a.SrinStocktakingDetailsID
};
this.spgvMaterial.DataBind();
//初始化清点信息
if (!Page.IsPostBack)
{
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid);
if (sst != null)
{
chbCheck.AutoPostBack = false;
chbCheck.Checked = sst.StocktakingResult.Equals("清点有误") ? true : false;
chbCheck.AutoPostBack = true;
txtProblem.Visible = sst.StocktakingResult.Equals("清点有误") ? true : false;
txtProblem.Text = sst.StocktakingProblem;
btnOK.Text = "修改清点表单";
}
}
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.SrinStocktakingID == _stocktakingid);
((Label)GetControltByMaster("lblDelivery")).Text = sst.SrinSubDoc.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = sst.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sst.SrinSubDoc.CreateTime.ToLongDateString(), sst.SrinSubDoc.CreateTime.ToLongTimeString());
//初始化调拨明细
this.spgvMaterial.DataSource = from a in db.SrinStocktakingDetails
where a.SrinStocktakingID == _stocktakingid
select new
{
a.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinSubDetails.TotleGentaojian,
a.SrinSubDetails.TotleMetre,
a.SrinSubDetails.TotleTon,
a.SrinSubDetails.RetrieveCode,
a.StorageInfo.StorageName,
a.PileInfo.PileName,
a.Remark,
a.SrinStocktakingDetailsID
};
this.spgvMaterial.DataBind();
//初始化表尾
((Label)GetControltByMaster("lblMaterial")).Text = sst.EmpInfo.EmpName;
((Label)GetControltByMaster("lblInventoryDate")).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString());
((Label)GetControltByMaster("lblResult")).Text = sst.StocktakingResult.Trim();
((Label)GetControltByMaster("lblOpinion")).Text = sst.StocktakingProblem.Trim();
SrinStocktakingConfirm sstc = db.SrinStocktakingConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid));
((Label)GetControltByMaster("lblMChief")).Text = sstc.EmpInfo.EmpName;
((Label)GetControltByMaster("lblConfirmTime")).Text = string.Concat(sstc.ConfirmTime.ToLongDateString(), sstc.ConfirmTime.ToLongTimeString());
_confirmid = sstc.SrinStocktakingConfirmID;
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid);
(GetControltByMaster("lblCreater") as Label).Text = ssd.EmpInfo.EmpName;
(GetControltByMaster("lblProject") as Label).Text = ssd.ProjectInfo.ProjectName;
(GetControltByMaster("lblDate") as Label).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString());
//初始化调拨明细
this.spgvMaterial.DataSource = from a in db.SrinSubDetails
where a.SrinSubDocID == _subdocid
select new
{
a.MaterialInfo.MaterialName,
a.MaterialInfo.SpecificationModel,
a.MaterialInfo.FinanceCode,
a.TotleGentaojian,
a.TotleMetre,
a.TotleTon,
a.RetrieveCode,
a.Remark,
a.SrinSubDetailsID
};
this.spgvMaterial.DataBind();
//初始化清点信息
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _pretaskid);
(GetControltByMaster("lblMaterial") as Label).Text = sst.EmpInfo.EmpName;
(GetControltByMaster("lblResult") as Label).Text = sst.StocktakingResult;
(GetControltByMaster("lblInventoryDate") as Label).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString());
(GetControltByMaster("txtOpinion") as TextBox).Text = sst.StocktakingProblem;
}
}
