void btnSave_Click(object sender, EventArgs e)
{
try
{
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
if (CheckStringEmpty())
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox)
{
itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0];
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text));
asp.ScrapReportNum = itembox.Text.Trim();
db.SubmitChanges();
}
}
}
Response.Redirect("AwaitScrapManage.aspx", false);
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>");
return;
}
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>");
return;
}
}
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_UPDATEERROR));
}
}
void btnReject_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (db.AwaitScrap.Count(u => u.TransferID.Equals(_transferid) && u.TransferType.Equals("正常检验")) == 0)//没有写入报废库则写入，考虑用户IE回退等问题
{
AwaitScrap asrp;
foreach (GridViewRow gvr in this.spgvRejectMaterial.Rows)
{
asrp = new AwaitScrap();
asrp.State = "待报废";
asrp.ScrapReportNum = "未填写";
asrp.TransferType = "正常检验";
asrp.StorageID = Convert.ToInt32(gvr.Cells[12].Text);
asrp.PileID = Convert.ToInt32(gvr.Cells[13].Text);
asrp.MaterialID = Convert.ToInt32(gvr.Cells[14].Text);
asrp.ManufactureID = Convert.ToInt32(gvr.Cells[15].Text);
asrp.Gentaojian = Convert.ToDecimal(gvr.Cells[3].Text);
asrp.TransferID = _transferid;
asrp.ProjectID = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.SrinInspectorVerifyTransferID.Equals(_transferid)).SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.Project;
asrp.Creator = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
asrp.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.AwaitScrap.InsertOnSubmit(asrp);
}
db.SubmitChanges();
}
}
Response.Redirect(string.Format("../PublicPage/SendMessage.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));
}
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
if (listString.Count != 1)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择一条且仅能有一条记录进行报废!')</script>");
return;
}
if (CheckReportNum())
{
if (CheckStringEmpty())
{
for (int i = 0; i < this.gv.Rows.Count; i++)
{
chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox)
{
itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0];
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
AapId = int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text);
AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == AapId);
asp.State = "已报废";
Scrapped sp = new Scrapped();
sp.AwaitScrapID = AapId;
sp.StockID = Convert.ToInt32(this.txtID.Text.Trim());
sp.StockType = this.txtType.Text.Trim();
sp.ScrappedNum = itembox.Text.Trim();
var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sp.ScrappedTime = SevTime.First();
var Time = db.ExecuteQuery <DateTime>("select getdate()", new object[] { });
sp.CreateTime = Time.First();
sp.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName);
db.Scrapped.InsertOnSubmit(sp);
db.SubmitChanges();
}
}
}
Response.Redirect("ScrappedInfo.aspx", false);
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>");
return;
}
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('所选物资中存在未设定待报废报告号的物资!')</script>");
return;
}
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>");
return;
}
}
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_UPDATEERROR));
}
}
