void btnOK_Click(object sender, EventArgs e)
{
try
{
//将审核结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageOutDirectorConfirm sodc;
//将审核结果保存到数据库
sodc = new StorageOutDirectorConfirm();
sodc.StorageOutNoticeID = _noticeid;
sodc.StorageOutAssetAuditID = _aauditid;
sodc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sodc.Director = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
sodc.TaskID = _taskid;
db.StorageOutDirectorConfirm.InsertOnSubmit(sodc);
db.SubmitChanges();
//转到审核表单页
Response.Redirect(string.Format("NormalOutDirectorMessage.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))
{
//初始化表头信息
StorageOutNotice son = db.StorageOutNotice.SingleOrDefault(u => u.StorageOutNoticeID == this._noticeid);
(GetControltByMaster("lblConstructor") as Label).Text = son.BusinessUnitInfo1.BusinessUnitName;
(GetControltByMaster("lblProprietor") as Label).Text = son.BusinessUnitInfo.BusinessUnitName;
(GetControltByMaster("lblProject") as Label).Text = string.Format("{0}({1}阶段)", son.ProjectInfo.ProjectName, son.ProjectStage);
(GetControltByMaster("lblNoticeCode") as Label).Text = son.StorageOutNoticeCode;
(GetControltByMaster("lblProperty") as Label).Text = son.ProjectInfo.ProjectProperty;
(GetControltByMaster("lblDate") as Label).Text = son.CreateTime.ToLongDateString();
//初始化出库物资明细
this.spgvMaterial.DataSource = from a in db.StorageOutRealDetails
join b in db.StorageStocks on new { a.StocksID, Status = a.MaterialStatus } equals new { b.StocksID, b.Status }
where a.StorageOutNoticeID == _noticeid
orderby b.MaterialID, b.StorageTime ascending
let v1 = (from e in db.StorageOutRealDetails.AsEnumerable()
where e.StorageOutNoticeID == _noticeid && e.StorageOutDetails.MaterialID == b.MaterialID
select new { e.RealGentaojian }).Sum(u => u.RealGentaojian)
let v2 = (from e in db.StorageOutRealDetails.AsEnumerable()
where e.StorageOutNoticeID == _noticeid && e.StorageOutDetails.MaterialID == b.MaterialID
select new { e.RealMetre }).Sum(u => u.RealMetre)
let v3 = (from e in db.StorageOutRealDetails.AsEnumerable()
where e.StorageOutNoticeID == _noticeid && e.StorageOutDetails.MaterialID == b.MaterialID
select new { e.RealTon }).Sum(u => u.RealTon)
select new
{
MaterialName = string.Format("{0}--规格型号：{1}", b.MaterialName, b.SpecificationModel),
b.MaterialCode,
b.ManufacturerName,
b.StorageName,
b.PileName,
b.BatchIndex,
a.MaterialStatus,
b.StorageTime,
StocksGenTaojian = b.StocksGenTaojian + a.RealGentaojian,
StocksMetre = b.StocksMetre + a.RealMetre,
StocksTon = b.StocksTon + a.RealTon,
a.RealGentaojian,
a.RealMetre,
a.RealTon,
b.UnitPrice,
a.RealAmount,
a.Remark,
Description = string.Format("财务编码：{0}--根台套件/米/吨(总库存)：{1}/{2}/{3}--根台套件/米/吨(调拨)：{4}/{5}/{6}", b.FinanceCode,
(from c in db.StorageStocks
where c.MaterialID == b.MaterialID
select c).Sum(u => u.StocksGenTaojian) + v1,
(from c in db.StorageStocks
where c.MaterialID == b.MaterialID
select c).Sum(u => u.StocksMetre) + v2,
(from c in db.StorageStocks
where c.MaterialID == b.MaterialID
select c).Sum(u => u.StocksTon) + v3,
a.StorageOutDetails.Gentaojian,
a.StorageOutDetails.Metre,
a.StorageOutDetails.Ton)
};
this.spgvMaterial.DataBind();
////初始化主任审批信息
StorageOutDirectorConfirm sodc = db.StorageOutDirectorConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid));
(GetControltByMaster("lblDirector") as Label).Text = sodc.EmpInfo.EmpName;
(GetControltByMaster("lblDirectorTime") as Label).Text = string.Concat(sodc.ConfirmTime.ToLongDateString(), sodc.ConfirmTime.ToLongTimeString());
//初始化资产组长审核信息
(GetControltByMaster("lblAssetOpinion") as Label).Text = sodc.StorageOutAssetAudit.AuditOpinion;
(GetControltByMaster("lblAssetResult") as Label).Text = sodc.StorageOutAssetAudit.AuditStatus;
(GetControltByMaster("lblAssetChief") as Label).Text = sodc.StorageOutAssetAudit.EmpInfo.EmpName;
(GetControltByMaster("lblAssetTime") as Label).Text = string.Concat(sodc.StorageOutAssetAudit.AuditTime.ToLongDateString(), sodc.StorageOutAssetAudit.AuditTime.ToLongTimeString());
//初始化生产组长审核信息
(GetControltByMaster("lblProduceOpinion") as Label).Text = sodc.StorageOutAssetAudit.StorageOutProduceAudit.AuditOpinion;
(GetControltByMaster("lblProduceResult") as Label).Text = sodc.StorageOutAssetAudit.StorageOutProduceAudit.AuditStatus;
(GetControltByMaster("lblProduceChief") as Label).Text = sodc.StorageOutAssetAudit.StorageOutProduceAudit.EmpInfo.EmpName;
(GetControltByMaster("lblProduceTime") as Label).Text = string.Concat(sodc.StorageOutAssetAudit.StorageOutProduceAudit.AuditTime.ToLongDateString(), sodc.StorageOutAssetAudit.StorageOutProduceAudit.AuditTime.ToLongTimeString());
}
}
