void tbarbtnDelete_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int ichecked = 0; CheckBox chb; int idetailsid; foreach (GridViewRow gvr in spgvMaterial.Rows) { chb = (CheckBox)gvr.Cells[0].Controls[0]; if (!chb.Checked) { continue; } ichecked++; switch (_type) { case "维修保养": idetailsid = Convert.ToInt32(gvr.Cells[12].Text); SrinMaterialRepairDetails smrd = db.SrinMaterialRepairDetails.SingleOrDefault(a => a.SrinMaterialRepairDetailsID == idetailsid); db.SrinMaterialRepairDetails.DeleteOnSubmit(smrd); break; case "回收检验": idetailsid = Convert.ToInt32(gvr.Cells[9].Text); SrinMaterialVerifyDetails smvd = db.SrinMaterialVerifyDetails.SingleOrDefault(a => a.SrinMaterialVerifyDetailsID == idetailsid); db.SrinMaterialVerifyDetails.DeleteOnSubmit(smvd); break; } } if (ichecked != 0) { db.SubmitChanges(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>"); } } 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_QUERYERROR)); } }
private void SaveVerifyDetails() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { CheckBox chb; int iCount = 0; int iSrinDetailsID; SrinMaterialVerifyDetails smvd; foreach (GridViewRow gvr in spgvMaterial.Rows) { chb = (CheckBox)gvr.Cells[0].Controls[0]; if (!chb.Checked) { continue; } //将选中项保存到数据库 iSrinDetailsID = Convert.ToInt32(gvr.Cells[9].Text); smvd = new SrinMaterialVerifyDetails(); smvd.SrinVerifyTransferID = _formid; smvd.SrinDetailsID = iSrinDetailsID; smvd.ManufactureID = Convert.ToInt32((gvr.Cells[3].Controls[0] as DropDownList).SelectedValue); smvd.RetrieveTime = ((DateTimeControl)gvr.Cells[4].Controls[0]).SelectedDate; smvd.Remark = ((TextBox)(gvr.Cells[8].Controls[0])).Text; smvd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); smvd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID; db.SrinMaterialVerifyDetails.InsertOnSubmit(smvd); iCount++; } db.SubmitChanges(); //没有选中的情况 if (iCount == 0) { Response.Write("<script language='javaScript'>alert('没有选中要添加的物资!');</script>"); return; } Response.AddHeader("Refresh", "0"); } }