protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
ERP.Model.Materials model = new ERP.Model.Materials();
model.MID = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text);
model.MCode = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text);
model.MName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();
model.MModel = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString();
model.MMaterial = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString();
model.MStandard = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString();
model.MUnit = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text.ToString();
model.MNumber = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text);
model.WName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[0]).Text.ToString();
try
{
bool TrueOrFalse = bll.Update(model);
if (TrueOrFalse)
{
Response.Write("<script language=javascript>alert('保存成功！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('保存失败！')</script>");
}
GridView1.EditIndex = -1;
LoadList();
}
catch (Exception erro)
{
Response.Write("错误信息:" + erro.Message);
}
}
private void ShowInfo(int MID)
{
ERP.BLL.Materials bll = new ERP.BLL.Materials();
ERP.Model.Materials model = bll.GetModel(MID);
this.lblMID.Text = model.MID.ToString();
this.lblMCode.Text = model.MCode.ToString();
this.lblMName.Text = model.MName;
this.lblMModel.Text = model.MModel;
this.lblMMaterial.Text = model.MMaterial;
this.lblMStandard.Text = model.MStandard;
this.lblMUnit.Text = model.MUnit;
this.lblMNumber.Text = model.MNumber.ToString();
this.lblWName.Text = model.WName;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ERP.Model.Materials model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Materials set ");
strSql.Append("MCode=@MCode,");
strSql.Append("MModel=@MModel,");
strSql.Append("MMaterial=@MMaterial,");
strSql.Append("MStandard=@MStandard,");
strSql.Append("MUnit=@MUnit,");
strSql.Append("MNumber=@MNumber,");
strSql.Append("WName=@WName");
strSql.Append(" where MID=@MID");
SqlParameter[] parameters =
{
new SqlParameter("@MCode", SqlDbType.Int, 4),
new SqlParameter("@MModel", SqlDbType.NVarChar, 50),
new SqlParameter("@MMaterial", SqlDbType.NVarChar, 50),
new SqlParameter("@MStandard", SqlDbType.NVarChar, 50),
new SqlParameter("@MUnit", SqlDbType.NVarChar, 50),
new SqlParameter("@MNumber", SqlDbType.Int, 4),
new SqlParameter("@WName", SqlDbType.NVarChar, 50),
new SqlParameter("@MID", SqlDbType.Int, 4),
new SqlParameter("@MName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.MCode;
parameters[1].Value = model.MModel;
parameters[2].Value = model.MMaterial;
parameters[3].Value = model.MStandard;
parameters[4].Value = model.MUnit;
parameters[5].Value = model.MNumber;
parameters[6].Value = model.WName;
parameters[7].Value = model.MID;
parameters[8].Value = model.MName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERP.Model.Materials DataRowToModel(DataRow row)
{
ERP.Model.Materials model = new ERP.Model.Materials();
if (row != null)
{
if (row["MID"] != null && row["MID"].ToString() != "")
{
model.MID = int.Parse(row["MID"].ToString());
}
if (row["MCode"] != null && row["MCode"].ToString() != "")
{
model.MCode = int.Parse(row["MCode"].ToString());
}
if (row["MName"] != null)
{
model.MName = row["MName"].ToString();
}
if (row["MModel"] != null)
{
model.MModel = row["MModel"].ToString();
}
if (row["MMaterial"] != null)
{
model.MMaterial = row["MMaterial"].ToString();
}
if (row["MStandard"] != null)
{
model.MStandard = row["MStandard"].ToString();
}
if (row["MUnit"] != null)
{
model.MUnit = row["MUnit"].ToString();
}
if (row["MNumber"] != null && row["MNumber"].ToString() != "")
{
model.MNumber = int.Parse(row["MNumber"].ToString());
}
if (row["WName"] != null)
{
model.WName = row["WName"].ToString();
}
}
return(model);
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
ERP.BLL.Materials bll = new ERP.BLL.Materials();
ERP.Model.Materials model = new ERP.Model.Materials();
model.MCode = Convert.ToInt32(TextBoxMCode.Text);
model.MName = TextBoxMName.Text.ToString();
model.MModel = TextBoxMModel.Text.ToString();
model.MMaterial = TextBoxMMaterial.Text.ToString();
model.MStandard = TextBoxMStandard.Text.ToString();
model.MUnit = TextBoxMUnit.Text.ToString();
model.MNumber = Convert.ToInt32(TextBoxMNumber.Text);
//仓库名称-由下拉菜单选择
model.WName = DropDownList.Text.ToString();
try
{
bll.Add(model);
Response.Write("<script>alert('插入成功');history.back()</script>");
TextBoxMCode.Text = "";
TextBoxMName.Text = "";
TextBoxMModel.Text = "";
TextBoxMMaterial.Text = "";
TextBoxMStandard.Text = "";
TextBoxMUnit.Text = "";
TextBoxMNumber.Text = "";
}
catch (Exception)
{
Response.Write("<script>alert('插入失败');history.back()</script>");
TextBoxMCode.Text = "";
TextBoxMName.Text = "";
TextBoxMModel.Text = "";
TextBoxMMaterial.Text = "";
TextBoxMStandard.Text = "";
TextBoxMUnit.Text = "";
TextBoxMNumber.Text = "";
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ERP.Model.Materials model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Materials(");
strSql.Append("MCode,MName,MModel,MMaterial,MStandard,MUnit,MNumber,WName)");
strSql.Append(" values (");
strSql.Append("@MCode,@MName,@MModel,@MMaterial,@MStandard,@MUnit,@MNumber,@WName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MCode", SqlDbType.Int, 4),
new SqlParameter("@MName", SqlDbType.NVarChar, 50),
new SqlParameter("@MModel", SqlDbType.NVarChar, 50),
new SqlParameter("@MMaterial", SqlDbType.NVarChar, 50),
new SqlParameter("@MStandard", SqlDbType.NVarChar, 50),
new SqlParameter("@MUnit", SqlDbType.NVarChar, 50),
new SqlParameter("@MNumber", SqlDbType.Int, 4),
new SqlParameter("@WName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.MCode;
parameters[1].Value = model.MName;
parameters[2].Value = model.MModel;
parameters[3].Value = model.MMaterial;
parameters[4].Value = model.MStandard;
parameters[5].Value = model.MUnit;
parameters[6].Value = model.MNumber;
parameters[7].Value = model.WName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERP.Model.Materials GetModel(int MID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MID,MCode,MName,MModel,MMaterial,MStandard,MUnit,MNumber,WName from Materials ");
strSql.Append(" where MID=@MID");
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.Int, 4)
};
parameters[0].Value = MID;
ERP.Model.Materials model = new ERP.Model.Materials();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtMCode.Text))
{
strErr += "MCode格式错误！\\n";
}
if (this.txtMModel.Text.Trim().Length == 0)
{
strErr += "MModel不能为空！\\n";
}
if (this.txtMMaterial.Text.Trim().Length == 0)
{
strErr += "MMaterial不能为空！\\n";
}
if (this.txtMStandard.Text.Trim().Length == 0)
{
strErr += "MStandard不能为空！\\n";
}
if (this.txtMUnit.Text.Trim().Length == 0)
{
strErr += "MUnit不能为空！\\n";
}
if (!PageValidate.IsNumber(txtMNumber.Text))
{
strErr += "MNumber格式错误！\\n";
}
if (this.txtWName.Text.Trim().Length == 0)
{
strErr += "WName不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int MID = int.Parse(this.lblMID.Text);
int MCode = int.Parse(this.txtMCode.Text);
string MName = this.lblMName.Text;
string MModel = this.txtMModel.Text;
string MMaterial = this.txtMMaterial.Text;
string MStandard = this.txtMStandard.Text;
string MUnit = this.txtMUnit.Text;
int MNumber = int.Parse(this.txtMNumber.Text);
string WName = this.txtWName.Text;
ERP.Model.Materials model = new ERP.Model.Materials();
model.MID = MID;
model.MCode = MCode;
model.MName = MName;
model.MModel = MModel;
model.MMaterial = MMaterial;
model.MStandard = MStandard;
model.MUnit = MUnit;
model.MNumber = MNumber;
model.WName = WName;
ERP.BLL.Materials bll = new ERP.BLL.Materials();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
