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 SaveRepairDetails()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
CheckBox chb;
int iCount = 0;
int iSrinDetailsID;
SrinMaterialRepairDetails smrd;
foreach (GridViewRow gvr in spgvMaterial.Rows)
{
chb = (CheckBox)gvr.Cells[0].Controls[0];
if (!chb.Checked)
{
continue;
}
//将选中项保存到数据库
iSrinDetailsID = Convert.ToInt32(gvr.Cells[9].Text);
smrd = new SrinMaterialRepairDetails();
smrd.SrinRepairPlanID = _formid;
smrd.SrinDetailsID = iSrinDetailsID;
smrd.ManufactureID = Convert.ToInt32((gvr.Cells[3].Controls[0] as DropDownList).SelectedValue);
smrd.ArrivalTime = ((DateTimeControl)gvr.Cells[4].Controls[0]).SelectedDate;
smrd.Gentaojian = Convert.ToDecimal(((TextBox)(gvr.Cells[6].Controls[0])).Text);
smrd.RepairReason = ((TextBox)(gvr.Cells[7].Controls[0])).Text;
smrd.RealGentaojian = 0;
smrd.Remark = ((TextBox)(gvr.Cells[8].Controls[0])).Text;
smrd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
smrd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
db.SrinMaterialRepairDetails.InsertOnSubmit(smrd);
iCount++;
}
db.SubmitChanges();
//没有选中的情况
if (iCount == 0)
{
Response.Write("<script language='javaScript'>alert('没有选中要添加的物资！');</script>");
return;
}
Response.AddHeader("Refresh", "0");
}
}
