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);
}
}
