void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.txtMatMainName.Text) && !string.IsNullOrEmpty(this.txtMatMainCode.Text))
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//检查唯一性
var temp = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeCode == this.txtMatMainCode.Text.Trim());
if (temp == null)
{
MaterialMainType ei = new MaterialMainType();
ei.MaterialMainTypeName = this.txtMatMainName.Text.Trim();
ei.MaterialMainTypeCode = this.txtMatMainCode.Text.Trim();
if (this.ddlMatMain.SelectedIndex == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择所属主类！')</script>");
return;
}
ei.MaterialTypeID = int.Parse(this.ddlMatMain.SelectedValue);
// ei.Remark = this.txtRemark.Text.Trim();
db.MaterialMainType.InsertOnSubmit(ei);
db.SubmitChanges();
Response.Redirect("MatMainManager.aspx");
}
else
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('大类编码已存在')</script>");
}
}
}
}
void InsertRow()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
MaterialMainType ei = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeID == int.Parse(Request.QueryString["MaterialMainTypeID"]));
if (ei != null)
{
ei.MaterialMainTypeName = this.txtMatMainName.Text.Trim();
ei.MaterialMainTypeCode = this.txtMatMainCode.Text.Trim();
if (this.ddlMatMain.SelectedIndex == 0)
{
ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择所属物料主类！')</script>");
return;
}
ei.MaterialTypeID = int.Parse(this.ddlMatMain.SelectedValue);
//ei.Remark = this.txtRemark.Text.Trim();
db.SubmitChanges();
Response.Redirect("MatMainManager.aspx");
}
}
}
private void BindData()
{
int intID = 0;
if (int.TryParse(Request.QueryString["MaterialMainTypeID"], out intID))
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
MaterialMainType di = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeID == intID);
if (di != null)
{
this.txtMatMainName.Text = di.MaterialMainTypeName;
this.txtMatMainCode.Text = di.MaterialMainTypeCode;
this.ddlMatMain.SelectedValue = di.MaterialTypeID.ToString();
// this.txtRemark.Text = di.Remark;
}
}
}
else
{
Response.Redirect("MatMainManager.aspx");
}
}
private string InsertData(Net.SourceForge.Koogra.Excel.Row row)
{
string strResult = "";
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//分段获取4种值,父类无值直接跳出
//获取主类
if (row.Cells[0] == null || row.Cells[1] == null)
{
return("主类信息不完整");
}
MaterialType Temp;
//检查大类是否存在
if (!db.MaterialType.Any(a => a.MaterialTypeCode == row.Cells[0].Value.ToString()))
{
Temp = new MaterialType();
//MT.MaterialMainTypeCode =
Temp.MaterialTypeCode = row.Cells[0].Value.ToString();
Temp.MaterialTypeName = row.Cells[1].Value.ToString();
db.MaterialType.InsertOnSubmit(Temp);
db.SubmitChanges();
}
else
{
Temp = db.MaterialType.SingleOrDefault(a => a.MaterialTypeCode == row.Cells[0].Value.ToString());
Temp.MaterialTypeCode = row.Cells[0].Value.ToString();
Temp.MaterialTypeName = row.Cells[1].Value.ToString();
db.SubmitChanges();
}
//获取大类
if (row.Cells[2] == null || row.Cells[3] == null)
{
return("大类信息不完整");
}
MaterialMainType MT;
//检查大类是否存在
if (!db.MaterialMainType.Any(a => a.MaterialMainTypeCode == row.Cells[2].Value.ToString()))
{
MT = new MaterialMainType();
//MT.MaterialMainTypeCode =
MT.MaterialMainTypeCode = row.Cells[2].Value.ToString();
MT.MaterialMainTypeName = row.Cells[3].Value.ToString();
MT.MaterialTypeID = Temp.MaterialTypeID;
db.MaterialMainType.InsertOnSubmit(MT);
db.SubmitChanges();
}
else
{
MT = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeCode == row.Cells[2].Value.ToString());
MT.MaterialMainTypeCode = row.Cells[2].Value.ToString();
MT.MaterialMainTypeName = row.Cells[3].Value.ToString();
MT.MaterialTypeID = Temp.MaterialTypeID;
db.SubmitChanges();
}
//获取中类
if (row.Cells[4] == null || row.Cells[5] == null)
{
return("");
}
MaterialChildType mct;
if (!db.MaterialChildType.Any(a => a.MaterialChildTypeCode == row.Cells[4].Value.ToString()))
{
mct = new MaterialChildType();
mct.MaterialChildTypeCode = row.Cells[4].Value.ToString();
mct.MaterialChildTypeName = row.Cells[5].Value.ToString();
mct.MaterialMainTypeID = MT.MaterialMainTypeID;
db.MaterialChildType.InsertOnSubmit(mct);
db.SubmitChanges();
}
else
{
mct = db.MaterialChildType.SingleOrDefault(a => a.MaterialChildTypeCode == row.Cells[4].Value.ToString());
mct.MaterialChildTypeCode = row.Cells[4].Value.ToString();
mct.MaterialChildTypeName = row.Cells[5].Value.ToString();
mct.MaterialMainTypeID = MT.MaterialMainTypeID;
db.SubmitChanges();
}
//获取小类
if (row.Cells[6] == null || row.Cells[7] == null)
{
return("");
}
MaterialInfo mi;
if (!db.MaterialInfo.Any(a => a.FinanceCode == row.Cells[6].Value.ToString()))
{
mi = new MaterialInfo();
mi.MaterialchildTypeID = mct.MaterialChildTypeID;
mi.FinanceCode = row.Cells[6].Value.ToString();
mi.MaterialName = row.Cells[7].Value.ToString();
mi.SpecificationModel = row.Cells[8].Value.ToString() ?? "";
mi.Remark = row.Cells[9].Value.ToString() ?? "";
db.MaterialInfo.InsertOnSubmit(mi);
db.SubmitChanges();
}
else
{
mi = db.MaterialInfo.SingleOrDefault(a => a.FinanceCode == row.Cells[6].Value.ToString());
mi.MaterialchildTypeID = mct.MaterialChildTypeID;
mi.FinanceCode = row.Cells[6].Value.ToString();
mi.MaterialName = row.Cells[7].Value.ToString();
mi.SpecificationModel = row.Cells[8].Value.ToString() ?? "";
mi.Remark = row.Cells[9].Value.ToString() ?? "";
db.SubmitChanges();
}
}
return(strResult);
}
