public int EditModel(IModel model) { KCWSB265 objModel = (KCWSB265)model; //编写带参数的SQL语句 StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("Update KCWSB265 set Length=@Length,ExRightDis=@ExRightDis,ExLength=@ExLength,ExWidth=@ExWidth,ExHeight=@ExHeight,"); sqlBuilder.Append("FCSide=@FCSide,FCSideLeft=@FCSideLeft,FCSideRight=@FCSideRight,FCBlindNo=@FCBlindNo,"); sqlBuilder.Append("SidePanel=@SidePanel,DPSide=@DPSide,Inlet=@Inlet,"); sqlBuilder.Append("SSPType=@SSPType,Gutter=@Gutter,GutterWidth=@GutterWidth,ANSUL=@ANSUL,ANSide=@ANSide,"); sqlBuilder.Append("MARVEL=@MARVEL,Japan=@Japan where KCWSB265Id=@KCWSB265Id"); //定义参数数组 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Length", objModel.Length), new SqlParameter("@ExRightDis", objModel.ExRightDis), new SqlParameter("@ExLength", objModel.ExLength), new SqlParameter("@ExWidth", objModel.ExWidth), new SqlParameter("@ExHeight", objModel.ExHeight), new SqlParameter("@FCSide", objModel.FCSide), new SqlParameter("@FCSideLeft", objModel.FCSideLeft), new SqlParameter("@FCSideRight", objModel.FCSideRight), new SqlParameter("@FCBlindNo", objModel.FCBlindNo), new SqlParameter("@SidePanel", objModel.SidePanel), new SqlParameter("@Inlet", objModel.Inlet), new SqlParameter("@DPSide", objModel.DPSide), new SqlParameter("@SSPType", objModel.SSPType), new SqlParameter("@Gutter", objModel.Gutter), new SqlParameter("@GutterWidth", objModel.GutterWidth), new SqlParameter("@ANSUL", objModel.ANSUL), new SqlParameter("@ANSide", objModel.ANSide), new SqlParameter("@MARVEL", objModel.MARVEL), new SqlParameter("@Japan", objModel.Japan), new SqlParameter("@KCWSB265Id", objModel.KCWSB265Id) }; try { return(SQLHelper.Update(sqlBuilder.ToString(), param)); } catch (SqlException ex) { throw new Exception("数据库操作出现异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
public FrmKCWSB265(Drawing drawing, ModuleTree tree) : this() { objKCWSB265 = (KCWSB265)objKCWSB265Service.GetModelByModuleTreeId(tree.ModuleTreeId.ToString()); if (objKCWSB265 == null) { return; } this.Text = drawing.ODPNo + " / Item: " + drawing.Item + " / Module: " + tree.Module + " - " + tree.CategoryName; Category objCategory = objCategoryService.GetCategoryByCategoryId(tree.CategoryId.ToString()); pbModelImage.Image = objCategory.ModelImage.Length == 0 ? Image.FromFile("NoPic.png") : (Image) new SerializeObjectToString().DeserializeObject(objCategory.ModelImage); FillData(); }
public IModel GetModelByWhereSql(string whereSql) { string sql = "select KCWSB265Id,ModuleTreeId,Length,ExRightDis,ExLength,ExWidth,ExHeight," + "FCSide,FCSideLeft,FCSideRight,FCBlindNo,SidePanel,DPSide,Inlet,SSPType,Gutter,GutterWidth," + "ANSUL,ANSide,MARVEL,Japan from KCWSB265"; sql += whereSql; SqlDataReader objReader = SQLHelper.GetReader(sql); KCWSB265 objModel = null; if (objReader.Read()) { objModel = new KCWSB265() { KCWSB265Id = Convert.ToInt32(objReader["KCWSB265Id"]), ModuleTreeId = Convert.ToInt32(objReader["ModuleTreeId"]), //最好不要用=null去判断,提示类型转换错误 Length = objReader["Length"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["Length"]), ExRightDis = objReader["ExRightDis"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExRightDis"]), ExLength = objReader["ExLength"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExLength"]), ExWidth = objReader["ExWidth"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExWidth"]), ExHeight = objReader["ExHeight"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExHeight"]), FCSide = objReader["FCSide"].ToString().Length == 0 ? "" : objReader["FCSide"].ToString(), FCSideLeft = objReader["FCSideLeft"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["FCSideLeft"]), FCSideRight = objReader["FCSideRight"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["FCSideRight"]), FCBlindNo = objReader["FCBlindNo"].ToString().Length == 0 ? 0 : Convert.ToInt32(objReader["FCBlindNo"]), SidePanel = objReader["SidePanel"].ToString().Length == 0 ? "" : objReader["SidePanel"].ToString(), DPSide = objReader["DPSide"].ToString().Length == 0 ? "" : objReader["DPSide"].ToString(), Inlet = objReader["Inlet"].ToString().Length == 0 ? "" : objReader["Inlet"].ToString(), SSPType = objReader["SSPType"].ToString().Length == 0 ? "" : objReader["SSPType"].ToString(), Gutter = objReader["Gutter"].ToString().Length == 0 ? "" : objReader["Gutter"].ToString(), GutterWidth = objReader["GutterWidth"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["GutterWidth"]), ANSUL = objReader["ANSUL"].ToString().Length == 0 ? "" : objReader["ANSUL"].ToString(), ANSide = objReader["ANSide"].ToString().Length == 0 ? "" : objReader["ANSide"].ToString(), MARVEL = objReader["MARVEL"].ToString().Length == 0 ? "" : objReader["MARVEL"].ToString(), Japan = objReader["Japan"].ToString().Length == 0 ? "" : objReader["Japan"].ToString(), }; } objReader.Close(); return(objModel); }
private void btnEditData_Click(object sender, EventArgs e) { #region 数据验证 //必填项目 if (pbModelImage.Tag.ToString().Length == 0) { return; } if (!DataValidate.IsDecimal(txtLength.Text.Trim()) || Convert.ToDecimal(txtLength.Text.Trim()) < 100m) { MessageBox.Show("请认真检查烟罩长度", "提示信息"); txtLength.Focus(); txtLength.SelectAll(); return; } //排风腔位置 if (cobSidePanel.SelectedIndex == -1) { MessageBox.Show("请选择烟罩位置", "提示信息"); cobSidePanel.Focus(); return; } //ANSUL腔 if (cobGutter.SelectedIndex == -1) { MessageBox.Show("请选择是否右ANSUL腔", "提示信息"); cobGutter.Focus(); return; } else if (cobGutter.SelectedIndex == 0 && (!DataValidate.IsDecimal(txtGutterWidth.Text.Trim()) || Convert.ToDecimal(txtGutterWidth.Text.Trim()) < 30m)) { MessageBox.Show("请认真检查ANSUL腔宽度", "提示信息");//当脖颈大于2时需要填写脖颈间距 txtGutterWidth.Focus(); txtGutterWidth.SelectAll(); return; } //脖颈 if (!DataValidate.IsDecimal(txtExLength.Text.Trim()) || Convert.ToDecimal(txtExLength.Text.Trim()) < 50m) { MessageBox.Show("请填写脖颈长度", "提示信息"); txtExLength.Focus(); txtExLength.SelectAll(); return; } if (!DataValidate.IsDecimal(txtExWidth.Text.Trim()) || Convert.ToDecimal(txtExWidth.Text.Trim()) < 50m) { MessageBox.Show("请填写脖颈宽度", "提示信息"); txtExWidth.Focus(); txtExWidth.SelectAll(); return; } if (!DataValidate.IsDecimal(txtExHeight.Text.Trim()) || Convert.ToDecimal(txtExHeight.Text.Trim()) < 20m) { MessageBox.Show("请填写脖颈高度", "提示信息"); txtExHeight.Focus(); txtExHeight.SelectAll(); return; } //ANSUL if (cobANSUL.SelectedIndex == -1) { MessageBox.Show("是否带ANSUL", "提示信息"); cobANSUL.Focus(); return; } if (cobMARVEL.SelectedIndex == -1) { MessageBox.Show("是否带MARVEL", "提示信息"); cobMARVEL.Focus(); return; } if (cobANSUL.SelectedIndex == 0) { if (cobANSide.SelectedIndex == -1) { MessageBox.Show("请选择ANSUL侧喷位置", "提示信息"); cobANSide.Focus(); return; } } //其他配置 if (cobSSPType.SelectedIndex == -1) { MessageBox.Show("请选择SSP灯板类型", "提示信息"); cobSSPType.Focus(); return; } if (cobJapan.SelectedIndex == -1) { MessageBox.Show("请选择是否为日本项目", "提示信息"); cobJapan.Focus(); return; } //入水口方向 if (cobInlet.SelectedIndex == -1) { MessageBox.Show("请选择入水口方向", "提示信息"); cobInlet.Focus(); return; } //排水槽位置 if (cobDPSide.SelectedIndex == -1) { MessageBox.Show("请选择排水槽位置", "提示信息"); cobDPSide.Focus(); return; } //油网 if (cobFCSide.SelectedIndex == -1) { MessageBox.Show("请选择油网侧板", "提示信息"); cobFCSide.Focus(); return; } if ((cobFCSide.SelectedIndex == 0 || cobFCSide.SelectedIndex == 2) && (!DataValidate.IsDecimal(txtFCSideLeft.Text.Trim()) || Convert.ToDecimal(txtFCSideLeft.Text.Trim()) < 10m)) { MessageBox.Show("请认真检查左油网侧板长度", "提示信息");//当脖颈大于2时需要填写脖颈间距 txtFCSideLeft.Focus(); txtFCSideLeft.SelectAll(); return; } if ((cobFCSide.SelectedIndex == 1 || cobFCSide.SelectedIndex == 2) && (!DataValidate.IsDecimal(txtFCSideRight.Text.Trim()) || Convert.ToDecimal(txtFCSideRight.Text.Trim()) < 10m)) { MessageBox.Show("请认真检查右油网侧板长度", "提示信息");//当脖颈大于2时需要填写脖颈间距 txtFCSideRight.Focus(); txtFCSideRight.SelectAll(); return; } #endregion //封装对象 KCWSB265 objKCWSB265 = new KCWSB265() { KCWSB265Id = Convert.ToInt32(pbModelImage.Tag), ANSUL = cobANSUL.Text, ANSide = cobANSide.Text.Trim().Length == 0 ? "NO" : cobANSide.Text, MARVEL = cobMARVEL.Text, SSPType = cobSSPType.Text, Japan = cobJapan.Text, Gutter = cobGutter.Text, FCSide = cobFCSide.Text, FCBlindNo = Convert.ToInt32(cobFCBlindNo.Text.Trim()), SidePanel = cobSidePanel.Text, Inlet = cobInlet.Text, DPSide = cobDPSide.Text, Length = Convert.ToDecimal(txtLength.Text.Trim()), ExRightDis = Convert.ToDecimal(txtExRightDis.Text.Trim()), ExLength = Convert.ToDecimal(txtExLength.Text.Trim()), ExWidth = Convert.ToDecimal(txtExWidth.Text.Trim()), ExHeight = Convert.ToDecimal(txtExHeight.Text.Trim()), GutterWidth = Convert.ToDecimal(txtGutterWidth.Text.Trim()), FCSideLeft = Convert.ToDecimal(txtFCSideLeft.Text.Trim()), FCSideRight = Convert.ToDecimal(txtFCSideRight.Text.Trim()) }; //提交修改 try { if (objKCWSB265Service.EditModel(objKCWSB265) == 1) { MessageBox.Show("制图数据修改成功", "提示信息"); this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }