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;
}
}
