private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid);
((Label)GetControltByMaster("lblCreater")).Text = ssd.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = ssd.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString());
//初始化回收分单中的物资
this.spgvMaterial.DataSource = from a in db.SrinSubDetails
where a.SrinSubDocID == _subdocid
select new
{
a.MaterialInfo.MaterialName,
a.MaterialInfo.SpecificationModel,
a.MaterialInfo.FinanceCode,
a.TotleGentaojian,
a.TotleMetre,
a.TotleTon,
a.RetrieveCode,
a.Remark,
a.SrinSubDetailsID
};
this.spgvMaterial.DataBind();
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == this._subdocid);
txtTaker.Text = ssd.EmpInfo1.Account;
txtRemark.Text = ssd.Remark;
ddlCompany.SelectedValue = ssd.ProjectInfo.Owner.ToString();
dtcCreateTime.SelectedDate = ssd.CreateTime;
BindProject();
ddlProject.SelectedValue = ssd.Project.ToString();
btnSave.Text = "修改";
}
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
if (this.ddlProject.SelectedIndex == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "提示", "<script>alert('请选择回收项目! ');</script>");
return;
}
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
SrinSubDoc ssd;
if (this._subdocid == 0) //主流程--新建的情况
{
ssd = new SrinSubDoc();
ssd.Creator = this._userid;
ssd.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate;
ssd.Project = Convert.ToInt32(ddlProject.SelectedValue);
ssd.Remark = ((TextBox)GetControltByMaster("txtRemark")).Text.Trim();
ssd.Taker = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(txtTaker.Text.Trim())).EmpID;
db.SrinSubDoc.InsertOnSubmit(ssd);
}
else
{
ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == this._subdocid);
ssd.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate;
ssd.Project = Convert.ToInt32(ddlProject.SelectedValue);
ssd.Remark = txtRemark.Text.Trim();
ssd.Taker = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(txtTaker.Text.Trim())).EmpID;
}
db.SubmitChanges();
}
Response.Redirect("ManageSrinSubDoc.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));
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == db.TaskStorageIn.SingleOrDefault(v => v.TaskStorageID.Equals(_taskid)).StorageInID);
((Label)GetControltByMaster("lblCreater")).Text = ssd.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = ssd.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString());
//初始化回收分单中的物资
this.spgvMaterial.DataSource = from a in db.SrinStocktakingDetails
where a.SrinStocktakingID == _stocktakingid
select new
{
a.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinSubDetails.TotleGentaojian,
a.SrinSubDetails.TotleMetre,
a.SrinSubDetails.TotleTon,
a.SrinSubDetails.RetrieveCode,
a.StorageID,
a.PileID,
a.Remark,
a.SrinStocktakingDetailsID
};
this.spgvMaterial.DataBind();
//初始化清点信息
if (!Page.IsPostBack)
{
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid);
if (sst != null)
{
chbCheck.AutoPostBack = false;
chbCheck.Checked = sst.StocktakingResult.Equals("清点有误") ? true : false;
chbCheck.AutoPostBack = true;
txtProblem.Visible = sst.StocktakingResult.Equals("清点有误") ? true : false;
txtProblem.Text = sst.StocktakingProblem;
btnOK.Text = "修改清点表单";
}
}
}
}
private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid);
((Label)GetControltByMaster("lblCreater")).Text = ssd.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = ssd.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString());
//初始化清点物资明细
this.spgvMaterial.DataSource = from a in db.SrinStocktakingDetails
where a.SrinStocktakingID == _stocktakingid
select new
{
a.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinSubDetails.TotleGentaojian,
a.SrinSubDetails.TotleMetre,
a.SrinSubDetails.TotleTon,
a.SrinSubDetails.RetrieveCode,
a.StorageInfo.StorageName,
a.PileInfo.PileName,
a.Remark,
a.SrinStocktakingDetailsID
};
this.spgvMaterial.DataBind();
//初始化清点信息
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid);
((Label)GetControltByMaster("lblMaterial")).Text = sst.EmpInfo.EmpName;
lblResult.Text = sst.StocktakingResult;
((Label)GetControltByMaster("lblInventoryDate")).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString());
lblOpinion.Text = sst.StocktakingProblem;
}
}
