void subMit_Click(object sender, EventArgs e)
{
if (CheckStringEmpty() != true)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整且财务编码不能重复!')</script>");
return;
}
List <CheckBox> listString = GetCheckedID();
if (listString.Count > 0)
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
for (int i = 0; i < listString.Count; i++)
{
StorageOutDetails SOD = db.StorageOutDetails.SingleOrDefault(u => u.StorageOutDetailsID == Convert.ToInt32(Request.QueryString["StorageOutDetailsID"].ToString()));
TextBox tboxCode = (TextBox)(this.gv.Rows[i].Cells[5].Controls[0]);
TextBox tboxNums = (TextBox)(this.gv.Rows[i].Cells[6].Controls[0]);
SOD.FinanceCode = tboxCode.Text.Trim();
SOD.Gentaojian = Convert.ToDecimal(tboxNums.Text.Trim());
db.SubmitChanges();
}
}
Response.Redirect("StorageOutDetailsManage.aspx?StorageOutNoticeID=" + Request.QueryString["StorageOutNoticeID"] + "&&StorageOutTaskID=" + Request.QueryString["StorageOutTaskID"] + "");
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择后提交修改!')</script>");
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
CheckBox chb;
int iCount = 0;
int iMaterialID;
StorageOutDetails sod;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
chb = (CheckBox)gvr.Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
//将选中项保存到数据库
iMaterialID = Convert.ToInt32(gvr.Cells[11].Text);
sod = new StorageOutDetails();
sod.StorageOutNoticeID = _noticeid;
sod.MaterialID = iMaterialID;
sod.Gentaojian = Convert.ToDecimal((gvr.Cells[5].Controls[0] as TextBox).Text.Trim());
sod.Metre = Convert.ToDecimal((gvr.Cells[7].Controls[0] as TextBox).Text.Trim());
sod.Ton = Convert.ToDecimal((gvr.Cells[9].Controls[0] as TextBox).Text.Trim());
sod.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
sod.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
sod.Remark = (gvr.Cells[10].Controls[0] as TextBox).Text.Trim();
db.StorageOutDetails.InsertOnSubmit(sod);
iCount++;
}
db.SubmitChanges();
//没有选中的情况
if (iCount == 0)
{
Response.Write("<script language='javaScript'>alert('没有选中要添加的物资明细！');</script>");
return;
}
}
Response.AddHeader("Refresh", "0");
}
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));
}
}
