private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from MarerialScrapLog where Id='{0}' ", ToolManager.GetQueryString("Id"));
//sql = string.Format(@" select * from MarerialScrapLog where Id='{0}' ", "1");
txtCreateTime.ReadOnly = true;
txtMaterialNumber.ReadOnly = true;
txtProductNumber.ReadOnly = true;
Model.MarerialScrapLog marerialscraplog = MarerialScrapLogManager.ConvertDataTableToModel(sql);
this.txtId.Text = marerialscraplog.Id;
this.trId.Visible = false;
this.txtCreateTime.Text = marerialscraplog.CreateTime;
this.txtProductNumber.Text = marerialscraplog.ProductNumber;
this.txtMaterialNumber.Text = marerialscraplog.MaterialNumber;
this.txtScrapDate.Text = marerialscraplog.ScrapDate;
this.txtTeam.Text = marerialscraplog.Team;
this.txtCount.Text = marerialscraplog.Count;
this.txtResponsiblePerson.Text = marerialscraplog.ResponsiblePerson;
this.txtScrapReason.Text = marerialscraplog.ScrapReason;
this.txtRemark.Text = marerialscraplog.Remark;
btnSubmit.Text = "修改";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string error = string.Empty;
Model.MarerialScrapLog marerialscraplog = new Model.MarerialScrapLog();
marerialscraplog.Id = this.txtId.Text.Trim();
marerialscraplog.CreateTime = this.txtCreateTime.Text.Trim();
marerialscraplog.ProductNumber = this.txtProductNumber.Text.Trim();
marerialscraplog.MaterialNumber = this.txtMaterialNumber.Text.Trim();
marerialscraplog.ScrapDate = this.txtScrapDate.Text.Trim();
marerialscraplog.Team = this.txtTeam.Text.Trim();
marerialscraplog.Count = this.txtCount.Text.Trim();
marerialscraplog.ResponsiblePerson = this.txtResponsiblePerson.Text.Trim();
marerialscraplog.ScrapReason = this.txtScrapReason.Text.Trim();
marerialscraplog.Remark = this.txtRemark.Text.Trim();
bool result = false;
if (string.IsNullOrEmpty(marerialscraplog.CreateTime) || string.IsNullOrEmpty(marerialscraplog.MaterialNumber) ||
string.IsNullOrEmpty(marerialscraplog.ProductNumber) || string.IsNullOrEmpty(marerialscraplog.ScrapDate) ||
string.IsNullOrEmpty(marerialscraplog.Team) || string.IsNullOrEmpty(marerialscraplog.Count) ||
string.IsNullOrEmpty(marerialscraplog.ResponsiblePerson) || string.IsNullOrEmpty(marerialscraplog.ScrapReason))
{
lbSubmit.Text = "请将带*号的内容填写完整！";
return;
}
if (btnSubmit.Text.Equals("添加"))
{
result = MarerialScrapLogManager.AddMarerialScrapLog(marerialscraplog, ref error);
lbSubmit.Text = result == true?"添加成功！": "添加失败，原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "增加原材料报废信息" + marerialscraplog.Id, "增加成功");
ToolCode.Tool.ResetControl(this.Controls);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "增加原材料报废信息" + marerialscraplog.Id, "增加失败！原因" + error);
return;
}
}
else
{
result = MarerialScrapLogManager.EditMarerialScrapLog(marerialscraplog, ref error);
lbSubmit.Text = result == true ? "修改成功！" : "修改失败，原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑原材料报废信息" + marerialscraplog.Id, "编辑成功");
ToolCode.Tool.ResetControl(this.Controls);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑原材料报废信息" + marerialscraplog.Id, "编辑失败！原因" + error);
return;
}
}
}
private void onload()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from MarerialScrapLog where Id='{0}' ", ToolManager.GetQueryString("Id"));
Model.MarerialScrapLog marerialscraplog = MarerialScrapLogManager.ConvertDataTableToModel(sql);
this.lbId.InnerText = marerialscraplog.Id;
this.lbCreateTime.InnerText = marerialscraplog.CreateTime;
this.lbProductNumber.InnerText = marerialscraplog.ProductNumber;
this.lbMaterialNumber.InnerText = marerialscraplog.MaterialNumber;
this.lbScrapDate.InnerText = marerialscraplog.ScrapDate;
this.lbTeam.InnerText = marerialscraplog.Team;
this.lbCount.InnerText = marerialscraplog.Count;
this.lbResponsiblePerson.InnerText = marerialscraplog.ResponsiblePerson;
this.lbScrapReason.InnerText = marerialscraplog.ScrapReason;
this.lbRemark.InnerText = marerialscraplog.Remark;
}
}
/// <summary>
/// 添加原材料报废
/// </summary>
/// <param name="customer"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool AddMarerialScrapLog(Model.MarerialScrapLog marerialscraplog, ref string error)
{
if (IsExit(marerialscraplog.Id))
{
error = "已存在该编号！请重新填写编号。";
return(false);
}
if (string.IsNullOrEmpty(marerialscraplog.CreateTime) || string.IsNullOrEmpty(marerialscraplog.MaterialNumber) ||
string.IsNullOrEmpty(marerialscraplog.ProductNumber) || string.IsNullOrEmpty(marerialscraplog.ScrapDate) ||
string.IsNullOrEmpty(marerialscraplog.Team) || string.IsNullOrEmpty(marerialscraplog.Count) ||
string.IsNullOrEmpty(marerialscraplog.ResponsiblePerson) || string.IsNullOrEmpty(marerialscraplog.ScrapReason))
{
error = "原材料报废上报信息不完整！";
return(false);
}
string sql = string.Format(@" insert into MarerialScrapLog (Id,CreateTime,ProductNumber,MaterialNumber,
ScrapDate,Team,Count,ResponsiblePerson,ScrapReason,Remark) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}') ",
marerialscraplog.Id, marerialscraplog.CreateTime, marerialscraplog.ProductNumber, marerialscraplog.MaterialNumber,
marerialscraplog.ScrapDate, marerialscraplog.Team, marerialscraplog.Count, marerialscraplog.ResponsiblePerson,
marerialscraplog.ScrapReason, marerialscraplog.Remark);
return(SqlHelper.ExecuteSql(sql, ref error));
}