/// <summary>
/// 修改KVI555的制图参数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditModel(IModel model)
{
KVI555 objModel = (KVI555)model;
//编写带参数的SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("Update KVI555 set Length=@Length,Deepth=@Deepth,ExRightDis=@ExRightDis,ExNo=@ExNo,EXDis=@EXDis,ExLength=@ExLength,ExWidth=@ExWidth,ExHeight=@ExHeight,SidePanel=@SidePanel,");
sqlBuilder.Append("Outlet=@Outlet,LEDlogo=@LEDlogo,BackToBack=@BackToBack,WaterCollection=@WaterCollection,LEDSpotNo=@LEDSpotNo,LEDSpotDis=@LEDSpotDis,LightType=@LightType,");
sqlBuilder.Append("ANSUL=@ANSUL,ANSide=@ANSide,ANDetector=@ANDetector,ANYDis=@ANYDis,ANDropNo=@ANDropNo,ANDropDis1=@ANDropDis1,ANDropDis2=@ANDropDis2,ANDropDis3=@ANDropDis3,ANDropDis4=@ANDropDis4,ANDropDis5=@ANDropDis5,");
sqlBuilder.Append("MARVEL=@MARVEL,IRNo=@IRNo,IRDis1=@IRDis1,IRDis2=@IRDis2,IRDis3=@IRDis3 where KVI555Id=@KVI555Id");
//定义参数数组
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Length", objModel.Length),
new SqlParameter("@Deepth", objModel.Deepth),
new SqlParameter("@ExRightDis", objModel.ExRightDis),
new SqlParameter("@ExNo", objModel.ExNo),
new SqlParameter("@EXDis", objModel.ExDis),
new SqlParameter("@ExLength", objModel.ExLength),
new SqlParameter("@ExWidth", objModel.ExWidth),
new SqlParameter("@ExHeight", objModel.ExHeight),
new SqlParameter("@SidePanel", objModel.SidePanel),
new SqlParameter("@Outlet", objModel.Outlet),
new SqlParameter("@LEDlogo", objModel.LEDlogo),
new SqlParameter("@BackToBack", objModel.BackToBack),
new SqlParameter("@WaterCollection", objModel.WaterCollection),
new SqlParameter("@LEDSpotNo", objModel.LEDSpotNo),
new SqlParameter("@LEDSpotDis", objModel.LEDSpotDis),
new SqlParameter("@LightType", objModel.LightType),
new SqlParameter("@ANSUL", objModel.ANSUL),
new SqlParameter("@ANSide", objModel.ANSide),
new SqlParameter("@ANDetector", objModel.ANDetector),
new SqlParameter("@ANYDis", objModel.ANYDis),
new SqlParameter("@ANDropNo", objModel.ANDropNo),
new SqlParameter("@ANDropDis1", objModel.ANDropDis1),
new SqlParameter("@ANDropDis2", objModel.ANDropDis2),
new SqlParameter("@ANDropDis3", objModel.ANDropDis3),
new SqlParameter("@ANDropDis4", objModel.ANDropDis4),
new SqlParameter("@ANDropDis5", objModel.ANDropDis5),
new SqlParameter("@MARVEL", objModel.MARVEL),
new SqlParameter("@IRNo", objModel.IRNo),
new SqlParameter("@IRDis1", objModel.IRDis1),
new SqlParameter("@IRDis2", objModel.IRDis2),
new SqlParameter("@IRDis3", objModel.IRDis3),
new SqlParameter("@KVI555Id", objModel.KVI555Id)
};
try
{
return(SQLHelper.Update(sqlBuilder.ToString(), param));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
public FrmKVI555(Drawing drawing, ModuleTree tree) : this()
{
objKvi555 = (KVI555)objKvi555Service.GetModelByModuleTreeId(tree.ModuleTreeId.ToString());
if (objKvi555 == 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();
}
/// <summary>
/// 根据条件查找KVI555
/// </summary>
/// <param name="whereSql"></param>
/// <returns></returns>
public IModel GetModelByWhereSql(string whereSql)
{
string sql =
"select KVI555Id,ModuleTreeId,Length,Deepth,ExRightDis,ExNo,EXDis,ExLength,ExWidth,ExHeight,SidePanel," +
"Outlet,LEDlogo,BackToBack,WaterCollection,LEDSpotNo,LEDSpotDis,LightType," +
"ANSUL,ANSide,ANDetector,ANYDis,ANDropNo,ANDropDis1,ANDropDis2,ANDropDis3,ANDropDis4,ANDropDis5," +
"MARVEL,IRNo,IRDis1,IRDis2,IRDis3 from KVI555";
sql += whereSql;
SqlDataReader objReader = SQLHelper.GetReader(sql);
KVI555 objModel = null;
if (objReader.Read())
{
objModel = new KVI555()
{
KVI555Id = Convert.ToInt32(objReader["KVI555Id"]),
ModuleTreeId = Convert.ToInt32(objReader["ModuleTreeId"]),
//最好不要用=null去判断，提示类型转换错误
Length = objReader["Length"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["Length"]),
Deepth = objReader["Deepth"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["Deepth"]),
ExRightDis = objReader["ExRightDis"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExRightDis"]),
ExNo = objReader["ExNo"].ToString().Length == 0 ? 0 : Convert.ToInt32(objReader["ExNo"]),
ExDis = objReader["ExDis"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ExDis"]),
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"]),
SidePanel = objReader["SidePanel"].ToString().Length == 0 ? "" : objReader["SidePanel"].ToString(),
Outlet = objReader["Outlet"].ToString().Length == 0 ? "" : objReader["Outlet"].ToString(),
LEDlogo = objReader["LEDlogo"].ToString().Length == 0 ? "" : objReader["LEDlogo"].ToString(),
BackToBack = objReader["BackToBack"].ToString().Length == 0 ? "" : objReader["BackToBack"].ToString(),
WaterCollection = objReader["WaterCollection"].ToString().Length == 0 ? "" : objReader["WaterCollection"].ToString(),
LEDSpotNo = objReader["LEDSpotNo"].ToString().Length == 0 ? 0 : Convert.ToInt32(objReader["LEDSpotNo"]),
LEDSpotDis = objReader["LEDSpotDis"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["LEDSpotDis"]),
LightType = objReader["LightType"].ToString().Length == 0 ? "" : objReader["LightType"].ToString(),
ANSUL = objReader["ANSUL"].ToString().Length == 0 ? "" : objReader["ANSUL"].ToString(),
ANSide = objReader["ANSide"].ToString().Length == 0 ? "" : objReader["ANSide"].ToString(),
ANDetector = objReader["ANDetector"].ToString().Length == 0 ? "" : objReader["ANDetector"].ToString(),
ANYDis = objReader["ANYDis"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANYDis"]),
ANDropNo = objReader["ANDropNo"].ToString().Length == 0 ? 0 : Convert.ToInt32(objReader["ANDropNo"]),
ANDropDis1 = objReader["ANDropDis1"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANDropDis1"]),
ANDropDis2 = objReader["ANDropDis2"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANDropDis2"]),
ANDropDis3 = objReader["ANDropDis3"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANDropDis3"]),
ANDropDis4 = objReader["ANDropDis4"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANDropDis4"]),
ANDropDis5 = objReader["ANDropDis5"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["ANDropDis5"]),
MARVEL = objReader["MARVEL"].ToString().Length == 0 ? "" : objReader["MARVEL"].ToString(),
IRNo = objReader["IRNo"].ToString().Length == 0 ? 0 : Convert.ToInt32(objReader["IRNo"]),
IRDis1 = objReader["IRDis1"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["IRDis1"]),
IRDis2 = objReader["IRDis2"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["IRDis2"]),
IRDis3 = objReader["IRDis3"].ToString().Length == 0 ? 0 : Convert.ToDecimal(objReader["IRDis3"])
};
}
objReader.Close();
return(objModel);
}
/// <summary>
/// 修改参数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
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()) < 500m)
{
MessageBox.Show("请认真检查烟罩长度", "提示信息");
txtLength.Focus();
txtLength.SelectAll();
return;
}
if (!DataValidate.IsDecimal(txtDeepth.Text.Trim()) || Convert.ToDecimal(txtDeepth.Text.Trim()) < 500m)
{
MessageBox.Show("请认真检查烟罩深度", "提示信息");
txtDeepth.Focus();
txtDeepth.SelectAll();
return;
}
if (cobSidePanel.SelectedIndex == -1)
{
MessageBox.Show("请选择烟罩大侧板", "提示信息");
cobSidePanel.Focus();
return;
}
if (cobExNo.SelectedIndex == -1)
{
MessageBox.Show("请选择排风脖颈数量", "提示信息");
cobExNo.Focus();
return;
}
else if (cobExNo.SelectedIndex > 0 && (!DataValidate.IsDecimal(txtExDis.Text.Trim()) || Convert.ToDecimal(txtExDis.Text.Trim()) < 40m))
{
MessageBox.Show("请认真检查排风脖颈间距", "提示信息");//当脖颈大于2时需要填写脖颈间距
txtExDis.Focus();
txtExDis.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;
}
if (cobLightType.SelectedIndex == -1)
{
MessageBox.Show("请选择灯具类型", "提示信息");
cobLightType.Focus();
return;
}
if (cobANSUL.SelectedIndex == -1)
{
MessageBox.Show("是否带ANSUL", "提示信息");
cobANSUL.Focus();
return;
}
if (cobMARVEL.SelectedIndex == -1)
{
MessageBox.Show("是否带MARVEL", "提示信息");
cobMARVEL.Focus();
return;
}
if (cobLightType.SelectedIndex == 2 || cobLightType.SelectedIndex == 3)
{
if (cobLEDSpotNo.SelectedIndex == -1)
{
MessageBox.Show("请检查筒灯数量", "提示信息");
cobLEDSpotNo.Focus();
return;
}
if (!DataValidate.IsDecimal(txtLEDSpotDis.Text.Trim()) || Convert.ToDecimal(txtLEDSpotDis.Text.Trim()) < 60m)
{
MessageBox.Show("请填写筒灯间距", "提示信息");
txtLEDSpotDis.Focus();
txtLEDSpotDis.SelectAll();
return;
}
}
if (cobANSUL.SelectedIndex == 0)
{
if (cobANSide.SelectedIndex == -1)
{
MessageBox.Show("请选择ANSUL侧喷位置", "提示信息");
cobANSide.Focus();
return;
}
if (cobANDetector.SelectedIndex == -1)
{
MessageBox.Show("请选择ANSUL探测器进出口位置", "提示信息");
cobANDetector.Focus();
return;
}
if (cobANDropNo.SelectedIndex == -1)
{
MessageBox.Show("请检查下喷数量", "提示信息");
cobANDropNo.Focus();
return;
}
if (cobANDropNo.SelectedIndex > 0)
{
if (!DataValidate.IsDecimal(txtANYDis.Text.Trim()) || Convert.ToDecimal(txtANYDis.Text.Trim()) < 200m)
{
MessageBox.Show("请检查ANSUL下喷距离烟罩前端距离", "提示信息");
txtANYDis.Focus();
txtANYDis.SelectAll();
return;
}
if (!DataValidate.IsDecimal(txtDropDis1.Text.Trim()) || Convert.ToDecimal(txtDropDis1.Text.Trim()) < 30m)
{
MessageBox.Show("请检查下喷间距1", "提示信息");
txtDropDis1.Focus();
txtDropDis1.SelectAll();
return;
}
}
if (cobANDropNo.SelectedIndex > 1)
{
if (!DataValidate.IsDecimal(txtDropDis2.Text.Trim()) || Convert.ToDecimal(txtDropDis2.Text.Trim()) < 30m)
{
MessageBox.Show("请检查下喷间距2", "提示信息");
txtDropDis2.Focus();
txtDropDis2.SelectAll();
return;
}
}
if (cobANDropNo.SelectedIndex > 2)
{
if (!DataValidate.IsDecimal(txtDropDis3.Text.Trim()) || Convert.ToDecimal(txtDropDis3.Text.Trim()) < 30m)
{
MessageBox.Show("请检查下喷间距3", "提示信息");
txtDropDis3.Focus();
txtDropDis3.SelectAll();
return;
}
}
if (cobANDropNo.SelectedIndex > 3)
{
if (!DataValidate.IsDecimal(txtDropDis4.Text.Trim()) || Convert.ToDecimal(txtDropDis4.Text.Trim()) < 30m)
{
MessageBox.Show("请检查下喷间距4", "提示信息");
txtDropDis4.Focus();
txtDropDis4.SelectAll();
return;
}
}
if (cobANDropNo.SelectedIndex > 4)
{
if (!DataValidate.IsDecimal(txtDropDis5.Text.Trim()) || Convert.ToDecimal(txtDropDis5.Text.Trim()) < 30m)
{
MessageBox.Show("请检查下喷间距5", "提示信息");
txtDropDis5.Focus();
txtDropDis5.SelectAll();
return;
}
}
}
if (cobMARVEL.SelectedIndex == 0)
{
if (cobIRNo.SelectedIndex == -1)
{
MessageBox.Show("请检查IR数量", "提示信息");
cobIRNo.Focus();
return;
}
if (cobIRNo.SelectedIndex > 0)
{
if (!DataValidate.IsDecimal(txtIRDis1.Text.Trim()) || Convert.ToDecimal(txtIRDis1.Text.Trim()) < 30m)
{
MessageBox.Show("请检查IR间距1", "提示信息");
txtIRDis1.Focus();
txtIRDis1.SelectAll();
return;
}
}
if (cobIRNo.SelectedIndex > 1)
{
if (!DataValidate.IsDecimal(txtIRDis2.Text.Trim()) || Convert.ToDecimal(txtIRDis2.Text.Trim()) < 30m)
{
MessageBox.Show("请检查IR间距2", "提示信息");
txtIRDis2.Focus();
txtIRDis2.SelectAll();
return;
}
}
if (cobIRNo.SelectedIndex > 2)
{
if (!DataValidate.IsDecimal(txtIRDis3.Text.Trim()) || Convert.ToDecimal(txtIRDis3.Text.Trim()) < 30m)
{
MessageBox.Show("请检查IR间距3", "提示信息");
txtIRDis3.Focus();
txtIRDis3.SelectAll();
return;
}
}
}
if (cobLEDLogo.SelectedIndex == -1)
{
MessageBox.Show("请检查是否带LOGO", "提示信息");
cobLEDLogo.Focus();
return;
}
if (cobOutlet.SelectedIndex == -1)
{
MessageBox.Show("请检查油塞位置", "提示信息");
cobOutlet.Focus();
return;
}
if (cobWaterCollection.SelectedIndex == -1)
{
MessageBox.Show("请检查是否带集水翻遍", "提示信息");
cobWaterCollection.Focus();
return;
}
if (cobBackToBack.SelectedIndex == -1)
{
MessageBox.Show("请检查是否背靠背", "提示信息");
cobBackToBack.Focus();
return;
}
#endregion
//封装对象
KVI555 objKvi555 = new KVI555()
{
KVI555Id = Convert.ToInt32(pbModelImage.Tag),
SidePanel = cobSidePanel.Text,
ExNo = Convert.ToInt32(cobExNo.Text),
LightType = cobLightType.Text,
LEDSpotNo = cobLEDSpotNo.Text.Trim().Length == 0 ? 0 : Convert.ToInt32(cobLEDSpotNo.Text),
ANSUL = cobANSUL.Text,
ANSide = cobANSide.Text.Trim().Length == 0 ? "NO" : cobANSide.Text,
ANDetector = cobANDetector.Text.Trim().Length == 0 ? "NO" : cobANDetector.Text,
ANDropNo = cobANDropNo.Text.Trim().Length == 0 ? 0 : Convert.ToInt32(cobANDropNo.Text),
MARVEL = cobMARVEL.Text,
IRNo = cobIRNo.Text.Trim().Length == 0 ? 0 : Convert.ToInt32(cobIRNo.Text),
LEDlogo = cobLEDLogo.Text,
Outlet = cobOutlet.Text,
WaterCollection = cobWaterCollection.Text,
BackToBack = cobBackToBack.Text,
Length = Convert.ToDecimal(txtLength.Text.Trim()),
Deepth = Convert.ToDecimal(txtDeepth.Text.Trim()),
ExRightDis = Convert.ToDecimal(txtExRightDis.Text.Trim()),
ExDis = Convert.ToDecimal(txtExDis.Text.Trim()),
ExLength = Convert.ToDecimal(txtExLength.Text.Trim()),
ExWidth = Convert.ToDecimal(txtExWidth.Text.Trim()),
ExHeight = Convert.ToDecimal(txtExHeight.Text.Trim()),
LEDSpotDis = Convert.ToDecimal(txtLEDSpotDis.Text.Trim()),
ANYDis = Convert.ToDecimal(txtANYDis.Text.Trim()),
ANDropDis1 = Convert.ToDecimal(txtDropDis1.Text.Trim()),
ANDropDis2 = Convert.ToDecimal(txtDropDis2.Text.Trim()),
ANDropDis3 = Convert.ToDecimal(txtDropDis3.Text.Trim()),
ANDropDis4 = Convert.ToDecimal(txtDropDis4.Text.Trim()),
ANDropDis5 = Convert.ToDecimal(txtDropDis5.Text.Trim()),
IRDis1 = Convert.ToDecimal(txtIRDis1.Text.Trim()),
IRDis2 = Convert.ToDecimal(txtIRDis2.Text.Trim()),
IRDis3 = Convert.ToDecimal(txtIRDis3.Text.Trim())
};
//提交修改
try
{
if (objKvi555Service.EditModel(objKvi555) == 1)
{
MessageBox.Show("制图数据修改成功", "提示信息");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}