private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
txtNoticeCode.Text = scon.StorageCommitOutNoticeCode;
txtRemark.Text = scon.Remark;
ddlReceiver.SelectedValue = scon.Receiver.ToString();
dtcCreateTime.SelectedDate = scon.CreateTime;
btnSave.Text = "修改";
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName;
((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode;
((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString();
//初始化审核列表
this.spgvMaterial.DataSource = from a in db.StorageCommitOutDetails
where a.StorageCommitOutNoticeID == _noticeid
select new
{
a.MaterialInfo.FinanceCode,
a.MaterialInfo.MaterialName,
a.MaterialInfo.SpecificationModel,
a.Gentaojian,
a.Metre,
a.Ton,
StocksGenTaojian = (from c in db.StorageStocks
where c.MaterialID == a.MaterialID
select c).Sum(u => u.StocksGenTaojian),
StocksMetre = (from c in db.StorageStocks
where c.MaterialID == a.MaterialID
select c).Sum(u => u.StocksMetre),
StocksTon = (from c in db.StorageStocks
where c.MaterialID == a.MaterialID
select c).Sum(u => u.StocksTon),
a.Remark
};
this.spgvMaterial.DataBind();
//分支流程--已经审核的情况
if (this.scopa != null)
{
if (!Page.IsPostBack)
{
if (scopa.AuditStatus.Equals("未通过"))
{
txtOpinion.Text = scopa.AuditOpinion;
txtOpinion.Enabled = true;
chbAgree.AutoPostBack = false;
chbAgree.Checked = false;
chbAgree.AutoPostBack = true;
}
}
}
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName;
((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode;
((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString();
//初始化审核列表
this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails
where a.StorageCommitOutNoticeID == _noticeid
select new
{
//a.StorageCommitOutDetails.FinanceCode,
//a.StorageCommitOutDetails.TableOfStocks.MaterialCode,
//a.StorageCommitOutDetails.TableOfStocks.MaterialInfo.MaterialName,
//a.StorageCommitOutDetails.TableOfStocks.MaterialInfo.SpecificationModel,
//a.StorageCommitOutDetails.TableOfStocks.SupplierInfo.SupplierName,
//a.StorageCommitOutDetails.TableOfStocks.PileInfo.StorageInfo.StorageName,
//a.StorageCommitOutDetails.TableOfStocks.PileInfo.PileName,
//a.StorageCommitOutDetails.TableOfStocks.StorageTime,
//a.RealGentaojian,
//a.RealMetre,
//a.RealTon,
//a.RealAmount,
//a.StorageCommitOutDetails.TableOfStocks.UnitPrice
};
this.spgvMaterial.DataBind();
//初始化主任审批信息
StorageCommitOutRemove scor = db.StorageCommitOutRemove.SingleOrDefault(u => u.StorageCommitOutRemoveID == this._auditid);
((Label)GetControltByMaster("lblDirectorOpinion")).Text = scor.DirectorOpinion;
((Label)GetControltByMaster("lblDirectorResult")).Text = scor.DirectorAuditStatus;
((Label)GetControltByMaster("lblDirector")).Text = scor.EmpInfo.EmpName;
//初始化物资组长审核信息
((Label)GetControltByMaster("lblMaterialOpinion")).Text = scor.StorageCommitOutMaterialAudit.MaterialAuditOpinion;
((Label)GetControltByMaster("lblMaterialResult")).Text = scor.StorageCommitOutMaterialAudit.MaterialAuditStatus;
((Label)GetControltByMaster("lblMaterialChief")).Text = scor.StorageCommitOutMaterialAudit.EmpInfo.EmpName;
//初始化生产组长审核信息
((Label)GetControltByMaster("lblProduceOpinion")).Text = scor.StorageCommitOutProducingAudit.AuditOpinion;
((Label)GetControltByMaster("lblProduceResult")).Text = scor.StorageCommitOutProducingAudit.AuditStatus;
((Label)GetControltByMaster("lblProduceChief")).Text = scor.StorageCommitOutProducingAudit.EmpInfo.EmpName;
}
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
if (this.ddlReceiver.SelectedIndex == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择领料单位! ');</script>");
return;
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageCommitOutNotice scon;
if (this._noticeid == 0) //主流程--新建的情况
{
scon = new StorageCommitOutNotice();
scon.Creator = this._userid;
scon.CreateTime = dtcCreateTime.SelectedDate;
scon.Receiver = Convert.ToInt32(ddlReceiver.SelectedValue);
scon.Remark = ((TextBox)GetControltByMaster("txtRemark")).Text.Trim();
scon.StorageCommitOutNoticeCode = ((TextBox)GetControltByMaster("txtNoticeCode")).Text.Trim();
db.StorageCommitOutNotice.InsertOnSubmit(scon);
}
else
{
scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
scon.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate;
scon.Receiver = Convert.ToInt32(ddlReceiver.SelectedValue);
scon.Remark = txtRemark.Text.Trim();
scon.StorageCommitOutNoticeCode = txtNoticeCode.Text.Trim();
}
db.SubmitChanges();
}
Response.Redirect("ManageCommitOutNotice.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 vldNoticeCode_ServerValidate(object source, ServerValidateEventArgs args)
{
try
{
if (btnSave.Text.Equals("创建"))
{
string strNoticeCode = this.txtNoticeCode.Text.Trim();
//NoticeID为空的情况
if (string.IsNullOrEmpty(strNoticeCode))
{
args.IsValid = false;
vldNoticeCode.Text = "调拨通知单号不能为空！";
return;
}
//数据库中存在相同NoticeCode的情况
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeCode == strNoticeCode);
if (scon != null)
{
args.IsValid = false;
vldNoticeCode.Text = "调拨通知单号已存在！";
return;
}
}
args.IsValid = true;
}
}
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));
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName;
((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode;
((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString();
//初始化物资出库明细列表
this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails
join b in db.StorageStocks on new { a.StocksID, Status = a.MaterialStatus } equals new { b.StocksID, b.Status }
where a.StorageCommitOutNoticeID == _noticeid
orderby b.MaterialID, b.StorageTime ascending
let v1 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID
select new { e.RealGentaojian }).Sum(u => u.RealGentaojian)
let v2 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID
select new { e.RealMetre }).Sum(u => u.RealMetre)
let v3 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.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.StorageCommitOutDetails.Gentaojian,
a.StorageCommitOutDetails.Metre,
a.StorageCommitOutDetails.Ton)
};
this.spgvMaterial.DataBind();
//分支流程--已经审核的情况
scoaa = db.StorageCommitOutAssetAudit.SingleOrDefault(u => u.TaskID.Equals(_taskid));
if (scoaa != null)
{
btnOK.Text = "修改审核表单";
if (!Page.IsPostBack)
{
if (scoaa.AuditStatus.Equals("未通过"))
{
txtOpinion.Text = scoaa.AuditOpinion;
txtOpinion.Enabled = true;
chbAgree.AutoPostBack = false;
chbAgree.Checked = false;
chbAgree.AutoPostBack = true;
}
}
}
//初始化生产组审核信息
StorageCommitOutProduceAudit scopa = db.StorageCommitOutProduceAudit.SingleOrDefault(u => u.TaskID == GetPreviousTaskID("物资调拨审核", _taskid));
(GetControltByMaster("lblOpinion") as Label).Text = scopa.AuditOpinion;
(GetControltByMaster("lblResult") as Label).Text = scopa.AuditStatus;
(GetControltByMaster("lblProduceChief") as Label).Text = scopa.EmpInfo.EmpName;
(GetControltByMaster("lblProduceTime") as Label).Text = string.Concat(scopa.AuditTime.ToLongDateString(), scopa.AuditTime.ToLongTimeString());
_pauditid = scopa.StorageCommitOutProduceAuditID;
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid);
((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName;
(GetControltByMaster("lblNoticeCode") as Label).Text = scon.StorageCommitOutNoticeCode;
((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString();
//初始化出库物资明细
this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails
join b in db.StorageStocks on new { a.StocksID, Status = a.MaterialStatus } equals new { b.StocksID, b.Status }
where a.StorageCommitOutNoticeID == _noticeid
orderby b.MaterialID, b.StorageTime ascending
let v1 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID
select new { e.RealGentaojian }).Sum(u => u.RealGentaojian)
let v2 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID
select new { e.RealMetre }).Sum(u => u.RealMetre)
let v3 = (from e in db.StorageCommitOutRealDetails.AsEnumerable()
where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.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.StorageCommitOutDetails.Gentaojian,
a.StorageCommitOutDetails.Metre,
a.StorageCommitOutDetails.Ton)
};
this.spgvMaterial.DataBind();
////初始化主任审批信息
StorageCommitOutDirectorConfirm scodc = db.StorageCommitOutDirectorConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid));
(GetControltByMaster("lblDirector") as Label).Text = scodc.EmpInfo.EmpName;
(GetControltByMaster("lblDirectorTime") as Label).Text = string.Concat(scodc.ConfirmTime.ToLongDateString(), scodc.ConfirmTime.ToLongTimeString());
//初始化资产组长审核信息
(GetControltByMaster("lblAssetOpinion") as Label).Text = scodc.StorageCommitOutAssetAudit.AuditOpinion;
(GetControltByMaster("lblAssetResult") as Label).Text = scodc.StorageCommitOutAssetAudit.AuditStatus;
(GetControltByMaster("lblAssetChief") as Label).Text = scodc.StorageCommitOutAssetAudit.EmpInfo.EmpName;
(GetControltByMaster("lblAssetTime") as Label).Text = string.Concat(scodc.StorageCommitOutAssetAudit.AuditTime.ToLongDateString(), scodc.StorageCommitOutAssetAudit.AuditTime.ToLongTimeString());
//初始化生产组长审核信息
(GetControltByMaster("lblProduceOpinion") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditOpinion;
(GetControltByMaster("lblProduceResult") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditStatus;
(GetControltByMaster("lblProduceChief") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.EmpInfo.EmpName;
(GetControltByMaster("lblProduceTime") as Label).Text = string.Concat(scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditTime.ToLongDateString(), scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditTime.ToLongTimeString());
}
}
