private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from ProcessTestingTable where Id='{0}' ", ToolManager.GetQueryString("Id"));
ProcessTestingTable processtestingtable = ProcessTestingTableManager.ConvertDataTableToModel(sql);
this.lblProductionOrderNumber.Text = processtestingtable.ProductionOrderNumber;
this.lblProductNumber.Text = processtestingtable.ProductNumber;
this.lblCustomerProductNumber.Text = processtestingtable.CustomerProductNumber;
this.txtRemark.Text = processtestingtable.Remark;
this.lblVersion.Text = processtestingtable.Version;
btnSubmit.Text = "修改";
txtCustomerProductNumber.Visible = false;
txtProductionOrderNumber.Visible = false;
txtProductNumber.Visible = false;
show = "none";
}
else
{
show = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0306", "Add");
divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0306", "Delete");
divPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0306", "Delete");
//删除
if (ToolManager.CheckQueryString("ids"))
{
string temp = ProcessTestingTableManager.DeleteMarerialScrapLog(ToolManager.GetQueryString("ids"));
string ids = ToolManager.GetQueryString("ids");
bool restult = temp == "1" ? true : false;
if (restult)
{
Tool.WriteLog(Tool.LogType.Operating, "删除过程检验信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除成功");
Response.Write(temp);
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "删除过程检验信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除失败！原因" + temp);
Response.Write(temp);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPageOperate("btnSearch", "AddOrEditProcessTestingTable.aspx", "320", "600");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckQueryString("Id"))
{
string sql = string.Format(@" select * from ProcessTestingTable where Id='{0}' ", ToolManager.GetQueryString("Id"));
model = ProcessTestingTableManager.ConvertDataTableToModel(sql);
lbId.Text = model.Id;
lbProductionOrderNumber.Text = model.ProductionOrderNumber;
lbProductNumber.Text = model.ProductNumber;
lbVersion.Text = model.Version;
lbCustomerProductNumber.Text = model.CustomerProductNumber;
txtRemark.Text = model.Remark;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string fileName = this.fuFileUrl.FileName;
if (string.IsNullOrEmpty(fileName))
{
lbSubmit.Text = "请选择文件";
return;
}
string sql = string.Format(@" select * from ProcessTestingTable where Id='{0}' ", lbId.Text);
model = ProcessTestingTableManager.ConvertDataTableToModel(sql);
model.ImportTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.ImportPerson = ToolCode.Tool.GetUser().UserNumber;
string dataName = string.Concat(DateTime.Now.ToString("yyyyMMddHHmmss"), Path.GetExtension(fileName));
this.fuFileUrl.SaveAs(Server.MapPath(string.Concat("/UpLoadFileData/", dataName)));
model.ImgUrl = string.Concat("../UpLoadFileData/", dataName);
model.FileName = fileName;
string error = string.Empty;
bool result = ProcessTestingTableManager.EditProcessTestingTable(model, ref error);
lbSubmit.Text = result == true ? "修改成功！" : "修改失败：原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑过程检验信息" + model.Id, "编辑成功");
Response.Write(ToolManager.GetClosePageJS());
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑过程检验信息" + model.Id, error);
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string error = string.Empty;
Model.ProcessTestingTable processtestingtable = new ProcessTestingTable();
processtestingtable.ProductionOrderNumber = this.txtProductionOrderNumber.Text.Trim();
processtestingtable.ProductNumber = this.txtProductNumber.Text.Trim();
processtestingtable.CustomerProductNumber = this.txtCustomerProductNumber.Text.Trim();
processtestingtable.ImportTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
processtestingtable.ImportPerson = ToolCode.Tool.GetUser().UserNumber;
processtestingtable.Remark = this.txtRemark.Text.Trim();
processtestingtable.Version = txtVersion.Text.ToUpper().Trim();
bool result = false;
string sql = string.Empty;
DataTable dt;
if (btnSubmit.Text.Equals("添加"))
{
processtestingtable.Id = Guid.NewGuid().ToString();
if (string.IsNullOrEmpty(processtestingtable.ProductionOrderNumber) ||
string.IsNullOrEmpty(processtestingtable.ImportTime) || string.IsNullOrEmpty(processtestingtable.ImportPerson))
{
lbSubmit.Text = "请将带*号的内容填写完整！";
return;
}
sql = string.Format("select count(*) from ProductPlanDetail where PlanNumber='{0}'", processtestingtable.ProductionOrderNumber);
string num = SqlHelper.GetScalar(sql);
if (num == "0")
{
lbSubmit.Text = "未知的开工单编号！";
return;
}
sql = string.Format("select count(*) from ProductPlanDetail where CustomerProductNumber='{0}' and PlanNumber='{1}' and Version='{2}'",
processtestingtable.CustomerProductNumber, processtestingtable.ProductionOrderNumber, processtestingtable.Version);
num = SqlHelper.GetScalar(sql);
if (num == "0")
{
lbSubmit.Text = "未知的客户产成品编号！";
return;
}
sql = string.Format(@"select ProductNumber from ProductPlanDetail where CustomerProductNumber='{0}' and PlanNumber='{1}' and Version='{2}'",
processtestingtable.CustomerProductNumber, processtestingtable.ProductionOrderNumber, processtestingtable.Version);
dt = SqlHelper.GetTable(sql);
if (dt.Rows.Count > 0)
{
processtestingtable.ProductNumber = dt.Rows[0]["ProductNumber"].ToString();
}
else
{
lbSubmit.Text = "未知的客户产成品编号";
return;
}
string strFileName = this.fuFileUrl.FileName;
if (strFileName == "")
{
lbSubmit.Text = "请选择文件！";
return;
}
string dataName = string.Concat(DateTime.Now.ToString("yyyyMMddHHmmss"), Path.GetExtension(this.fuFileUrl.PostedFile.FileName));
this.fuFileUrl.SaveAs(Server.MapPath(string.Concat("/UpLoadFileData/", dataName)));
processtestingtable.ImgUrl = string.Concat("../UpLoadFileData/", dataName);
processtestingtable.FileName = strFileName;
result = ProcessTestingTableManager.AddProcessTestingTable(processtestingtable, ref error);
lbSubmit.Text = result == true ? "添加成功！" : "添加失败，原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "增加过程检验信息" + processtestingtable.Id, "增加成功");
ToolCode.Tool.ResetControl(this.Controls);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "增加过程检验信息" + processtestingtable.Id, "增加失败！原因" + error);
return;
}
}
else
{
processtestingtable.Id = ToolManager.GetQueryString("Id");
result = ProcessTestingTableManager.EditProcessTestingTable(processtestingtable, ref error);
lbSubmit.Text = result == true ? "修改成功！" : "修改失败：原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑过程检验信息" + processtestingtable.Id, "编辑成功");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑过程检验信息" + processtestingtable.Id, "编辑成功！原因" + error);
return;
}
}
}
