public int EditModel(IModel model)
{
KCWSB535 objModel = (KCWSB535)model;
//编写带参数的SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("Update KCWSB535 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,LightType=@LightType,");
sqlBuilder.Append("SSPType=@SSPType,Gutter=@Gutter,GutterWidth=@GutterWidth,ANSUL=@ANSUL,ANSide=@ANSide,");
sqlBuilder.Append("MARVEL=@MARVEL,Japan=@Japan where KCWSB535Id=@KCWSB535Id");
//定义参数数组
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("@DPSide", objModel.DPSide),
new SqlParameter("@LightType", objModel.LightType),
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("@KCWSB535Id", objModel.KCWSB535Id)
};
try
{
return(SQLHelper.Update(sqlBuilder.ToString(), param));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
public FrmKCWSB535(Drawing drawing, ModuleTree tree) : this()
{
objKCWSB535 = (KCWSB535)objKCWSB535Service.GetModelByModuleTreeId(tree.ModuleTreeId.ToString());
if (objKCWSB535 == 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 KCWSB535Id,ModuleTreeId,Length,ExRightDis,ExLength,ExWidth,ExHeight," +
"FCSide,FCSideLeft,FCSideRight,FCBlindNo,SidePanel,DPSide,LightType,SSPType,Gutter,GutterWidth," +
"ANSUL,ANSide,MARVEL,Japan from KCWSB535";
sql += whereSql;
SqlDataReader objReader = SQLHelper.GetReader(sql);
KCWSB535 objModel = null;
if (objReader.Read())
{
objModel = new KCWSB535()
{
KCWSB535Id = Convert.ToInt32(objReader["KCWSB535Id"]),
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(),
LightType = objReader["LightType"].ToString().Length == 0 ? "" : objReader["LightType"].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 (cobLightType.SelectedIndex == -1)
{
MessageBox.Show("请选择灯具类型", "提示信息");
cobLightType.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
//封装对象
KCWSB535 objKCWSB535 = new KCWSB535()
{
KCWSB535Id = 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,
LightType = cobLightType.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 (objKCWSB535Service.EditModel(objKCWSB535) == 1)
{
MessageBox.Show("制图数据修改成功", "提示信息");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}