private void LoadData()
{
//单据ID
int mainID = 0;
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
int id = Convert.ToInt32(Request.QueryString["CommitDetailedID"]);
CommitInDetailed SID = db.CommitInDetailed.SingleOrDefault(a => a.CommitDetailedID == id);
if (SID != null)
{
//单据id
mainID = SID.CommitInID;
CommitIn SI = db.CommitIn.SingleOrDefault(u => u.CommitInID == mainID);
this.txtStorageinNum.Text = SI.CommitInCode;
this.txtMaterialCode.Text = SID.MaterialInfo.FinanceCode;
this.txtMaterialMod.Text = SID.SpecificationModel;
this.txtMaterialQuantity.Text = SID.Quantity.ToString();
this.txtGTJ.Text = SID.QuantityGentaojian.ToString();
this.txtMetre.Text = SID.QuantityMetre.ToString();
this.txtTon.Text = SID.QuantityTon.ToString();
this.ddlUnit.SelectedIndex = reIndex(SID.CurUnit.ToString());
this.txtMaterialUnitPrice.Text = SID.UnitPrice.ToString();
this.txtMaterialAmount.Text = SID.Amount.ToString();
this.ddlStorage.SelectedValue = SID.PileInfo.StorageID.ToString();
this.ddlPile.SelectedValue = SID.PileInfo.PileID.ToString();
this.txtMaterialfinance.Text = SID.financeCode.ToString();
this.DateTimeStorageIn.SelectedDate = SID.StorageTime;
this.ddlSupplier.SelectedValue = SID.SupplierInfo.SupplierID.ToString();
this.txtManager.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.MaterialsManager).Account;
this.txtWarehouseWorker.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.WarehouseWorker).Account;
this.txtRemark.Text = SID.Remark.ToString();
//再次新建初始化委外物料名称
//关系表存放的新建物料索引值唯一
RelationCommitIn rci = db.RelationCommitIn.SingleOrDefault(u => u.CommitMaterial == SID.CommitDetailedID);
StorageCommitOutRealDetails scord = db.StorageCommitOutRealDetails.SingleOrDefault(u => u.StorageCommitOutRealDetailsID == rci.CommitOutMaterial);
strCmit = "物料名称:" + scord.StorageCommitOutDetails.TableOfStocks.MaterialInfo.MaterialName + " | " + "物料编码:" + scord.StorageCommitOutDetails.TableOfStocks.MaterialInfo.MaterialCode;
this.txtCommitMaterialCode.Text = strCmit;
this.txtID.Text = scord.StorageCommitOutRealDetailsID.ToString();
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>");
Response.Redirect("CommitInDetailedManage.aspx?CommitInID=" + Request.QueryString["CommitInID"] + "");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
InitControl();
//再次新建初始化委外物料名称
if (!string.IsNullOrEmpty(Request.QueryString["CommitMid"]))
{
cmid = Request.QueryString["CommitMid"];
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
StorageCommitOutRealDetails scord = db.StorageCommitOutRealDetails.SingleOrDefault(u => u.StorageCommitOutRealDetailsID == Convert.ToInt32(cmid));
strCmit = "物料名称:" + scord.StorageCommitOutDetails.TableOfStocks.MaterialInfo.MaterialName + " | " + "物料编码:" + scord.StorageCommitOutDetails.TableOfStocks.MaterialCode;
this.txtCommitMaterialCode.Text = strCmit;
this.txtID.Text = scord.StorageCommitOutRealDetailsID.ToString();
}
}
selUser(this.txtManager, this.txtWarehouseWorker);
selectUser(this.txtCommitMaterialCode, this.txtID, "../StorageCommitIn/SelectCommitMaterial.aspx");
if (!IsPostBack)
{
BindUnit();
BindDefaultDate();
BindDDL();
BindStorage();
LoadData();
BindPile(Convert.ToInt32(this.ddlStorage.SelectedValue));
}
}
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))
{
StorageCommitOutRealDetails scord;
decimal iPricingQuantity;
foreach (GridViewRow gvr in this.spgvMaterial.Rows)
{
iPricingQuantity = Convert.ToDecimal((gvr.Cells[GetPricingIndex(gvr.Cells[16].Text)].Controls[0] as TextBox).Text.Trim());
if (iPricingQuantity == 0)
{
continue;
}
scord = new StorageCommitOutRealDetails();
scord.StorageCommitOutNoticeID = _noticeid;
scord.StorageCommitOutDetailsID = Convert.ToInt32(gvr.Cells[17].Text);
scord.StocksID = Convert.ToInt32(gvr.Cells[18].Text);
scord.MaterialStatus = gvr.Cells[7].Text;
scord.RealGentaojian = Convert.ToDecimal(((TextBox)gvr.Cells[9].Controls[0]).Text);
scord.RealMetre = Convert.ToDecimal(((TextBox)gvr.Cells[11].Controls[0]).Text);
scord.RealTon = Convert.ToDecimal(((TextBox)gvr.Cells[13].Controls[0]).Text);
scord.RealAmount = iPricingQuantity * Convert.ToDecimal(gvr.Cells[14].Text);
scord.Remark = (gvr.Cells[15].Controls[0] as TextBox).Text.Trim();
scord.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
scord.Creator = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
db.StorageCommitOutRealDetails.InsertOnSubmit(scord);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("CommitOutAssetDetailsMessage.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));
}
}
