/// <summary> /// 编辑过程检验 /// </summary> /// <param name="user"></param> /// <param name="error"></param> /// <returns></returns> public static bool EditProcessTestingTable(ProcessTestingTable model, ref string error) { sql = string.Format(@" update ProcessTestingTable set Remark='{0}',ImgUrl='{2}',FileName='{3}',ImportTime='{4}',ImportPerson='{5}' where Id='{1}' ", model.Remark, model.Id, model.ImgUrl, model.FileName, model.ImportTime, model.ImportPerson); return(SqlHelper.ExecuteSql(sql, ref error)); }
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) { 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; } } }
/// <summary> /// DataTable 转对象 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static ProcessTestingTable ConvertDataTableToModel(string sql) { error = string.Empty; DataTable dt = SqlHelper.GetTable(sql, ref error); DataRow dr = dt.Rows[0]; ProcessTestingTable processtestingtable = new ProcessTestingTable(); processtestingtable.Id = dr["Id"] == null ? "" : dr["Id"].ToString(); processtestingtable.ProductionOrderNumber = dr["ProductionOrderNumber"] == null ? "" : dr["ProductionOrderNumber"].ToString(); processtestingtable.ProductNumber = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString(); processtestingtable.CustomerProductNumber = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString(); processtestingtable.ImportTime = dr["ImportTime"] == null ? "" : dr["ImportTime"].ToString(); processtestingtable.ImportPerson = dr["ImportPerson"] == null ? "" : dr["ImportPerson"].ToString(); processtestingtable.Remark = dr["Remark"] == null ? "" : dr["Remark"].ToString(); processtestingtable.FileName = dr["FileName"] == null ? "" : dr["FileName"].ToString(); processtestingtable.ImgUrl = dr["ImgUrl"] == null ? "" : dr["ImgUrl"].ToString(); processtestingtable.Version = dr["Version"] == null ? "" : dr["Version"].ToString(); return(processtestingtable); }
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; } } }