private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinAChiefQReceiptConfirm smqc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.SrinQualifiedReceiptID.Equals(_receiptid)); ((Label)GetControltByMaster("lblProject")).Text = smqc.SrinQualifiedReceipt.SrinInspectorVerifyTransfer.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(smqc.SrinQualifiedReceipt.CreateTime.ToLongDateString(), smqc.SrinQualifiedReceipt.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = smqc.SrinQualifiedReceipt.SrinQualifiedReceiptCode; int projectid = smqc.SrinQualifiedReceipt.SrinInspectorVerifyTransfer.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.Project; //初始化冲销物资明细--同一项目的出库物资中包含的回收合格物资 this.spgvMaterial.DataSource = from a in db.WriteOffDetails where a.ProjectID == projectid && (from d in db.SrinAssetQualifiedDetails where d.SrinQualifiedReceiptID == _receiptid select d.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID).Contains(a.MaterialID) join b in db.SrinAssetQualifiedDetails on new { a.MaterialID, ReceiptID = _receiptid } equals new { b.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, ReceiptID = b.SrinQualifiedReceiptID } orderby a.MaterialID select new { MaterialName = string.Format("{0}--规格型号:{1}", a.MaterialName, a.SpecificationModel), a.StorageOutNoticeCode, a.MaterialCode, a.ManufacturerName, a.CreateTime, a.Status, a.RealGentaojian, a.RealMetre, a.RealTon, a.CurUnit, a.UnitPrice, a.RealAmount, b.Remark, a.StorageOutRealDetailsID, b.SrinAssetQualifiedDetailsID, Description = string.Format("财务编码:{0}--待冲销数量(根台套件/米/吨):{1}/{2}/{3}", a.FinanceCode, b.Gentaojian, b.Metre, b.Ton) }; this.spgvMaterial.DataBind(); //初始化表尾信息 (GetControltByMaster("lblAsset") as Label).Text = smqc.SrinQualifiedReceipt.EmpInfo.EmpName; (GetControltByMaster("lblAChief") as Label).Text = smqc.EmpInfo.EmpName; (GetControltByMaster("lblAChiefDate") as Label).Text = string.Concat(smqc.ConfirmTime.ToLongDateString(), smqc.ConfirmTime.ToLongTimeString()); (GetControltByMaster("lblRemark") as Label).Text = smqc.Remark; } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinQualifiedReceipt sqrp = db.SrinQualifiedReceipt.SingleOrDefault(u => u.SrinQualifiedReceiptID == _receiptid); ((Label)GetControltByMaster("lblProject")).Text = sqrp.SrinInspectorVerifyTransfer.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(sqrp.CreateTime.ToLongDateString(), sqrp.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = sqrp.SrinQualifiedReceiptCode; //初始化调拨明细 this.spgvMaterial.DataSource = from a in db.SrinAssetQualifiedDetails where a.SrinQualifiedReceiptID == _receiptid let mname = a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName let fcode = a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode let smodel = a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel select new { MaterialName = string.Format("{0}--规格型号:{1}", mname, smodel), a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName, a.Gentaojian, a.Metre, a.Ton, a.OutUnitPrice, a.InUnitPrice, a.Amount, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode, a.SrinInspectorVerifyDetails.VerifyCode, a.Remark, Description = string.Format("财务编码:{0}--回收合格数量(根/台/套/件):{1}", fcode, a.SrinInspectorVerifyDetails.QualifiedGentaojian) }; this.spgvMaterial.DataBind(); //初始化表尾信息 ((Label)GetControltByMaster("lblAsset")).Text = sqrp.EmpInfo.EmpName; ((Label)GetControltByMaster("lblWriteOff")).Text = sqrp.NeedWriteOff?"执行冲销":"不执行冲销"; if (!Page.IsPostBack) { SrinAChiefQReceiptConfirm smrc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid)); if (smrc != null)//分支流程--已经确认的情况 { txtRemark.Text = smrc.Remark; } else { txtRemark.Text = sqrp.Remark; } } } }
private void ShowCustomControls() { Panel p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.spgvMaterial); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskType.Equals("资产组长确认合格物资") && u.StorageInID.Equals(_receiptid)); if (tsi != null)//分支流程--已经发送任务的情况 { strBackUrl = "../../default-old.aspx"; btnOK.Text = lblWriteOff.Text.Equals("执行冲销") ? "冲销" : "入库"; ctAsset = lblWriteOff.Text.Equals("执行冲销") ? CommandType.WriteOff : CommandType.Storing; //获取显示信息 ltrInfo.Visible = true; string strAChief = string.Format("<font style=\"font-size:x-small;font-weight:bold;color:red\">{0}</font>", tsi.EmpInfo1.EmpName); SrinAChiefQReceiptConfirm smqc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.SrinQualifiedReceiptID == _receiptid); if (smqc != null)//分支流程--资产组长已经确认的情况 { if (lblWriteOff.Text.Equals("执行冲销")) { ltrInfo.Text = string.Format("回收入库单(合格)已经通过资产组长{0}确认,请执行冲销. . .<br/><br/>", strAChief); } else { ltrInfo.Text = string.Format("回收入库单(合格)已经通过资产组长{0}确认,请执行入库. . .<br/><br/>", strAChief); } btnOK.Enabled = true; } else { ltrInfo.Text = string.Format("回收入库单(合格)已经发送资产组长{0}确认,请等待. . .<br/><br/>", strAChief); btnOK.Enabled = false; } } } }
void btnOK_Click(object sender, EventArgs e) { try { //将确认结果保存到数据库 SrinAChiefQReceiptConfirm smqc; using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { smqc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid)); if (smqc == null) { smqc = new SrinAChiefQReceiptConfirm(); smqc.SrinQualifiedReceiptID = _receiptid; smqc.AssetChief = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID; smqc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); smqc.Remark = txtRemark.Text.Trim(); smqc.TaskID = _taskid; db.SrinAChiefQReceiptConfirm.InsertOnSubmit(smqc); } else { smqc.Remark = txtRemark.Text.Trim(); smqc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); } db.SubmitChanges(); } Response.Redirect(string.Format("RiAChiefConfirmQReceiptMessage.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)) { //初始化表头信息 SrinAChiefQReceiptConfirm saqc = db.SrinAChiefQReceiptConfirm.SingleOrDefault(u => u.SrinQualifiedReceiptID.Equals(_receiptid)); ((Label)GetControltByMaster("lblProject")).Text = saqc.SrinQualifiedReceipt.SrinInspectorVerifyTransfer.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(saqc.SrinQualifiedReceipt.CreateTime.ToLongDateString(), saqc.SrinQualifiedReceipt.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = saqc.SrinQualifiedReceipt.SrinQualifiedReceiptCode; projectid = saqc.SrinQualifiedReceipt.SrinInspectorVerifyTransfer.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.Project; //初始化回收入库单(合格)明细 if (bWriteOff)//执行了冲销的情况 { this.spgvMaterial.DataSource = (from a in db.SrinWriteOffDetails.AsEnumerable() join b in db.StorageStocks on new { a.StorageOutRealDetails.StocksID, Status = a.StorageOutRealDetails.MaterialStatus, a.SrinQualifiedReceiptID } equals new { b.StocksID, b.Status, SrinQualifiedReceiptID = _receiptid } where a.SrinQualifiedReceiptID == _receiptid select new { StorageType = b.Status.Equals("线上") ? "线上物资" : b.Status.Equals("线下") ? "线下入库" : "回收合格入库", b.MaterialName, b.MaterialCode, b.SpecificationModel, b.FinanceCode, b.ManufacturerName, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileInfo.PileName, a.Gentaojian, a.Metre, a.Ton, a.SrinAssetQualifiedDetails.InUnitPrice, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.RetrieveTime, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.CreateTime, a.SrinAssetQualifiedDetails.CurUnit, a.Remark, b.Status, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageID, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileID, a.SrinAssetQualifiedDetails.ManufactureID, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, Description = "入库物资详情" }).Union( from a in db.SrinWriteOffDetails.AsEnumerable() where !a.StorageOutRealDetails.MaterialStatus.Equals("回收合格") && !a.SrinAssetQualifiedDetails.Gentaojian.Equals((from c in db.SrinWriteOffDetails where c.SrinAssetQualifiedDetailsID.Equals(a.SrinAssetQualifiedDetailsID) select c).Sum(u => u.Gentaojian)) join b in db.StorageStocks on new { a.StorageOutRealDetails.StocksID, Status = a.StorageOutRealDetails.MaterialStatus, a.SrinQualifiedReceiptID } equals new { b.StocksID, b.Status, SrinQualifiedReceiptID = _receiptid } select new { StorageType = "回收合格入库", b.MaterialName, b.MaterialCode, b.SpecificationModel, b.FinanceCode, b.ManufacturerName, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileInfo.PileName, Gentaojian = a.SrinAssetQualifiedDetails.Gentaojian - a.Gentaojian, Metre = a.SrinAssetQualifiedDetails.Metre - a.Metre, Ton = a.SrinAssetQualifiedDetails.Ton - a.Ton, a.SrinAssetQualifiedDetails.InUnitPrice, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.RetrieveTime, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.CreateTime, a.SrinAssetQualifiedDetails.CurUnit, a.Remark, Status = "回收合格", a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageID, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileID, a.SrinAssetQualifiedDetails.ManufactureID, a.SrinAssetQualifiedDetails.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, Description = "入库物资详情" } ); } else { this.spgvMaterial.DataSource = from a in db.SrinAssetQualifiedDetails where a.SrinQualifiedReceiptID == _receiptid let fcode = a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode let smodel = a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel select new { a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileInfo.PileName, a.Gentaojian, a.Metre, a.Ton, a.InUnitPrice, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.RetrieveTime, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.CreateTime, a.CurUnit, a.Remark, Status = "回收合格", a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.StorageID, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.PileID, a.ManufactureID, a.SrinInspectorVerifyDetails.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialID, Description = string.Format("规格型号:{0}--财务编码:{1}--回收合格数量(根/台/套/件):{2}", smodel, fcode, a.SrinInspectorVerifyDetails.QualifiedGentaojian) }; } this.spgvMaterial.DataBind(); //初始化表尾信息 (GetControltByMaster("lblAsset") as Label).Text = saqc.SrinQualifiedReceipt.EmpInfo.EmpName; (GetControltByMaster("lblAChief") as Label).Text = saqc.EmpInfo.EmpName; (GetControltByMaster("lblAChiefDate") as Label).Text = string.Concat(saqc.ConfirmTime.ToLongDateString(), saqc.ConfirmTime.ToLongTimeString()); (GetControltByMaster("lblWriteOff") as Label).Text = saqc.SrinQualifiedReceipt.NeedWriteOff?"执行冲销":"不执行冲销"; (GetControltByMaster("lblRemark") as Label).Text = saqc.Remark; } }