private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinReceiptID == _receiptid);
((Label)GetControltByMaster("lblProject")).Text = srp.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblCode")).Text = srp.SrinReceiptCode;
//初始化调拨明细
this.spgvMaterial.DataSource = from a in db.SrinDetails
where a.SrinReceiptID == _receiptid
select new
{
a.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinStocktakingDetails.SrinSubDetails.TotleGentaojian,
a.SrinStocktakingDetails.SrinSubDetails.TotleMetre,
a.SrinStocktakingDetails.SrinSubDetails.TotleTon,
a.UnitPrice,
a.Amount,
a.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
a.Remark
};
this.spgvMaterial.DataBind();
//初始化表尾信息
((Label)GetControltByMaster("lblRemark")).Text = srp.Remark;
}
}
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();
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//生成回收物资设备入库单
SrinReceipt srp = new SrinReceipt();
srp.SrinReceiptCode = txtCode.Text.Trim();
srp.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate;
srp.Remark = ((TextBox)GetControltByMaster("txtRemark")).Text.Trim();
srp.SrinStocktakingConfirmID = _confirmid;
srp.TaskID = _taskid;
srp.Creator = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(SPContext.Current.Web.CurrentUser.LoginName)).EmpID;
db.SrinReceipt.InsertOnSubmit(srp);
db.SubmitChanges();
//添加物资明细
int iDetailsID;
SrinDetails sdl;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
iDetailsID = Convert.ToInt32(gvr.Cells[12].Text);
sdl = new SrinDetails();
sdl.SrinReceiptID = srp.SrinReceiptID;
sdl.SrinStocktakingDetailsID = iDetailsID;
sdl.UnitPrice = Convert.ToDecimal((gvr.Cells[8].Controls[0] as TextBox).Text);
sdl.CurUnit = (gvr.Cells[9].Controls[0] as DropDownList).Text;
sdl.Amount = Convert.ToDecimal(gvr.Cells[GetPricingIndex(sdl.CurUnit)].Text) * sdl.UnitPrice;
sdl.Remark = (gvr.Cells[11].Controls[0] as TextBox).Text.Trim();
sdl.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sdl.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
db.SrinDetails.InsertOnSubmit(sdl);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("RiAssetReceiptMessage.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 ShowCustomControls()
{
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgvMaterial);
if (lblResult.Text.Equals("清点有误"))
{
btnOK.Text = "通知核实";
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskType.Equals("物资组长确认清点结果") && u.StorageInID.Equals(_stocktakingid));
if (tsi != null)//分支流程--已经发送任务的情况
{
strBackUrl = "../../default-old.aspx";
btnOK.Text = "保养&检验";
ltrInfo.Visible = true;
string strMChief = string.Format("<font style=\"font-size:x-small;font-weight:bold;color:red\">{0}</font>", tsi.EmpInfo1.EmpName);
ltrInfo.Text = string.Format("清点结果已经发送物资组长{0}确认. . .<br/><br/>", strMChief);
bSendTask = true;
//分支流程--资产组员已经办理回收的情况
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinStocktakingConfirm.SrinStocktakingID.Equals(_stocktakingid));
if (srp == null)
{
btnOK.Enabled = false;
ltrInfo.Text = string.Format("清点结果已经发送物资组长{0}确认，请等待资产管理员办理回收入库单. . .<br/><br/>", strMChief);
}
else
{
_receiptid = srp.SrinReceiptID;
}
}
if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).TaskState.Equals("已完成"))
{
btnOK.Visible = false;
ltrInfo.Visible = true;
ltrInfo.Text = "该任务已完成，您正在查看清点信息 . . .";
}
}
}
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))
{
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinStocktakingConfirm.SrinStocktaking.TaskID.Equals(_taskid));
_receiptid = srp.SrinReceiptID;
}
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));
}
}
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))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid);
_confirmid = tsi.StorageInID;
//分支流程--已经创建回收入库单的情况
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.TaskID == _taskid);
if (srp != null)
{
if (db.TaskStorageIn.Count(u => u.TaskType.Equals("回收入库单资产组长确认") && u.PreviousTaskID == _taskid && u.StorageInID == srp.SrinReceiptID) != 0)//已经提交部门主管确认的情况
{
Response.Redirect(string.Format("RiAssetReceiptMessage.aspx?TaskID={0}", _taskid), false);
}
else//尚未提交部门主管确认的情况
{
Response.Redirect(string.Format("RiAssetModifyReceipt.aspx?TaskID={0}", _taskid), false);
}
return;
}
}
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));
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//修改回收物资设备入库单
SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinReceiptID == _receiptid);
srp.SrinReceiptCode = txtCode.Text.Trim();
srp.CreateTime = dtcCreateTime.SelectedDate;
srp.Remark = txtRemark.Text.Trim();
db.SubmitChanges();
//修改物资明细
SrinDetails sdl;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
sdl = db.SrinDetails.SingleOrDefault(u => u.SrinDetailsID == Convert.ToInt32(gvr.Cells[12].Text));
sdl.UnitPrice = Convert.ToDecimal((gvr.Cells[8].Controls[0] as TextBox).Text);
sdl.CurUnit = (gvr.Cells[9].Controls[0] as DropDownList).Text;
sdl.Amount = Convert.ToDecimal(gvr.Cells[GetPricingIndex(sdl.CurUnit)].Text) * sdl.UnitPrice;
sdl.Remark = ((TextBox)gvr.Cells[11].Controls[0]).Text.Trim();
sdl.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.SubmitChanges();
}
}
Response.Redirect(string.Format("RiAssetReceiptMessage.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));
}
}
