private void ShowInfo(int Id)
{
WebDemo.BLL.WebDemo.MeterImageParam bll = new WebDemo.BLL.WebDemo.MeterImageParam();
WebDemo.Model.WebDemo.MeterImageParam model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblMeterId.Text = model.MeterId.ToString();
this.lblCameraNo.Text = model.CameraNo.ToString();
this.txtNumberCount.Text = model.NumberCount.ToString();
this.txtCaptureStartPixs.Text = model.CaptureStartPixs.ToString();
this.txtUpClipPixs.Text = model.UpClipPixs.ToString();
this.txtDownClipPixs.Text = model.DownClipPixs.ToString();
this.txtLeftClipPixs.Text = model.LeftClipPixs.ToString();
this.txtRightClipPixs.Text = model.RightClipPixs.ToString();
this.txtCircumgyrateDegree.Text = model.CircumgyrateDegree.ToString();
this.txtInclineDegree.Text = model.InclineDegree.ToString();
this.txtModelHeight.Text = model.ModelHeight.ToString();
this.txtModelWidth.Text = model.ModelWidth.ToString();
this.txtModelOneWidth.Text = model.ModelOneWidth.ToString();
this.txtNumberSpace.Text = model.NumberSpace.ToString();
this.txtBitValueLimen.Text = model.BitValueLimen.ToString();
this.txtBitValueRadius.Text = model.BitValueRadius.ToString();
this.txtBitValueBlackProportion.Text = model.BitValueBlackProportion.ToString();
this.txtMorphologicFilterParam.Text = model.MorphologicFilterParam.ToString();
this.txtSearchlimitParam.Text = model.SearchlimitParam.ToString();
this.txtWindowHeight.Text = model.WindowHeight.ToString();
this.txtLastOperDate.Text = model.LastOperDate.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MeterImageParam GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,MeterId,CameraNo,NumberCount,CaptureStartPixs,UpClipPixs,DownClipPixs,LeftClipPixs,RightClipPixs,CircumgyrateDegree,InclineDegree,ModelHeight,ModelWidth,ModelOneWidth,NumberSpace,BitValueLimen,BitValueRadius,BitValueBlackProportion,MorphologicFilterParam,SearchlimitParam,WindowHeight,LastOperDate from MeterImageParam ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
WebDemo.Model.WebDemo.MeterImageParam model = new WebDemo.Model.WebDemo.MeterImageParam();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtMeterId.Text))
{
strErr+="MeterId格式错误！\\n";
}
if(!PageValidate.IsNumber(txtCameraNo.Text))
{
strErr+="CameraNo格式错误！\\n";
}
if(!PageValidate.IsNumber(txtNumberCount.Text))
{
strErr+="NumberCount格式错误！\\n";
}
if(!PageValidate.IsNumber(txtCaptureStartPixs.Text))
{
strErr+="CaptureStartPixs格式错误！\\n";
}
if(!PageValidate.IsNumber(txtUpClipPixs.Text))
{
strErr+="UpClipPixs格式错误！\\n";
}
if(!PageValidate.IsNumber(txtDownClipPixs.Text))
{
strErr+="DownClipPixs格式错误！\\n";
}
if(!PageValidate.IsNumber(txtLeftClipPixs.Text))
{
strErr+="LeftClipPixs格式错误！\\n";
}
if(!PageValidate.IsNumber(txtRightClipPixs.Text))
{
strErr+="RightClipPixs格式错误！\\n";
}
if(!PageValidate.IsNumber(txtCircumgyrateDegree.Text))
{
strErr+="CircumgyrateDegree格式错误！\\n";
}
if(!PageValidate.IsNumber(txtInclineDegree.Text))
{
strErr+="InclineDegree格式错误！\\n";
}
if(!PageValidate.IsNumber(txtModelHeight.Text))
{
strErr+="ModelHeight格式错误！\\n";
}
if(!PageValidate.IsNumber(txtModelWidth.Text))
{
strErr+="ModelWidth格式错误！\\n";
}
if(!PageValidate.IsNumber(txtModelOneWidth.Text))
{
strErr+="ModelOneWidth格式错误！\\n";
}
if(!PageValidate.IsNumber(txtNumberSpace.Text))
{
strErr+="NumberSpace格式错误！\\n";
}
if(!PageValidate.IsNumber(txtBitValueLimen.Text))
{
strErr+="BitValueLimen格式错误！\\n";
}
if(!PageValidate.IsNumber(txtBitValueRadius.Text))
{
strErr+="BitValueRadius格式错误！\\n";
}
if(!PageValidate.IsNumber(txtBitValueBlackProportion.Text))
{
strErr+="BitValueBlackProportion格式错误！\\n";
}
if(!PageValidate.IsNumber(txtMorphologicFilterParam.Text))
{
strErr+="MorphologicFilterParam格式错误！\\n";
}
if(!PageValidate.IsNumber(txtSearchlimitParam.Text))
{
strErr+="SearchlimitParam格式错误！\\n";
}
if(!PageValidate.IsNumber(txtWindowHeight.Text))
{
strErr+="WindowHeight格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtLastOperDate.Text))
{
strErr+="LastOperDate格式错误！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int MeterId=int.Parse(this.txtMeterId.Text);
int CameraNo=int.Parse(this.txtCameraNo.Text);
int NumberCount=int.Parse(this.txtNumberCount.Text);
int CaptureStartPixs=int.Parse(this.txtCaptureStartPixs.Text);
int UpClipPixs=int.Parse(this.txtUpClipPixs.Text);
int DownClipPixs=int.Parse(this.txtDownClipPixs.Text);
int LeftClipPixs=int.Parse(this.txtLeftClipPixs.Text);
int RightClipPixs=int.Parse(this.txtRightClipPixs.Text);
int CircumgyrateDegree=int.Parse(this.txtCircumgyrateDegree.Text);
int InclineDegree=int.Parse(this.txtInclineDegree.Text);
int ModelHeight=int.Parse(this.txtModelHeight.Text);
int ModelWidth=int.Parse(this.txtModelWidth.Text);
int ModelOneWidth=int.Parse(this.txtModelOneWidth.Text);
int NumberSpace=int.Parse(this.txtNumberSpace.Text);
int BitValueLimen=int.Parse(this.txtBitValueLimen.Text);
int BitValueRadius=int.Parse(this.txtBitValueRadius.Text);
int BitValueBlackProportion=int.Parse(this.txtBitValueBlackProportion.Text);
int MorphologicFilterParam=int.Parse(this.txtMorphologicFilterParam.Text);
int SearchlimitParam=int.Parse(this.txtSearchlimitParam.Text);
int WindowHeight=int.Parse(this.txtWindowHeight.Text);
DateTime LastOperDate=DateTime.Parse(this.txtLastOperDate.Text);
WebDemo.Model.WebDemo.MeterImageParam model=new WebDemo.Model.WebDemo.MeterImageParam();
model.MeterId=MeterId;
model.CameraNo=CameraNo;
model.NumberCount=NumberCount;
model.CaptureStartPixs=CaptureStartPixs;
model.UpClipPixs=UpClipPixs;
model.DownClipPixs=DownClipPixs;
model.LeftClipPixs=LeftClipPixs;
model.RightClipPixs=RightClipPixs;
model.CircumgyrateDegree=CircumgyrateDegree;
model.InclineDegree=InclineDegree;
model.ModelHeight=ModelHeight;
model.ModelWidth=ModelWidth;
model.ModelOneWidth=ModelOneWidth;
model.NumberSpace=NumberSpace;
model.BitValueLimen=BitValueLimen;
model.BitValueRadius=BitValueRadius;
model.BitValueBlackProportion=BitValueBlackProportion;
model.MorphologicFilterParam=MorphologicFilterParam;
model.SearchlimitParam=SearchlimitParam;
model.WindowHeight=WindowHeight;
model.LastOperDate=LastOperDate;
WebDemo.BLL.WebDemo.MeterImageParam bll=new WebDemo.BLL.WebDemo.MeterImageParam();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.MeterImageParam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MeterImageParam(");
strSql.Append("MeterId,CameraNo,NumberCount,CaptureStartPixs,UpClipPixs,DownClipPixs,LeftClipPixs,RightClipPixs,CircumgyrateDegree,InclineDegree,ModelHeight,ModelWidth,ModelOneWidth,NumberSpace,BitValueLimen,BitValueRadius,BitValueBlackProportion,MorphologicFilterParam,SearchlimitParam,WindowHeight,LastOperDate)");
strSql.Append(" values (");
strSql.Append("@MeterId,@CameraNo,@NumberCount,@CaptureStartPixs,@UpClipPixs,@DownClipPixs,@LeftClipPixs,@RightClipPixs,@CircumgyrateDegree,@InclineDegree,@ModelHeight,@ModelWidth,@ModelOneWidth,@NumberSpace,@BitValueLimen,@BitValueRadius,@BitValueBlackProportion,@MorphologicFilterParam,@SearchlimitParam,@WindowHeight,@LastOperDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MeterId", SqlDbType.Int, 4),
new SqlParameter("@CameraNo", SqlDbType.Int, 4),
new SqlParameter("@NumberCount", SqlDbType.Int, 4),
new SqlParameter("@CaptureStartPixs", SqlDbType.Int, 4),
new SqlParameter("@UpClipPixs", SqlDbType.Int, 4),
new SqlParameter("@DownClipPixs", SqlDbType.Int, 4),
new SqlParameter("@LeftClipPixs", SqlDbType.Int, 4),
new SqlParameter("@RightClipPixs", SqlDbType.Int, 4),
new SqlParameter("@CircumgyrateDegree", SqlDbType.Int, 4),
new SqlParameter("@InclineDegree", SqlDbType.Int, 4),
new SqlParameter("@ModelHeight", SqlDbType.Int, 4),
new SqlParameter("@ModelWidth", SqlDbType.Int, 4),
new SqlParameter("@ModelOneWidth", SqlDbType.Int, 4),
new SqlParameter("@NumberSpace", SqlDbType.Int, 4),
new SqlParameter("@BitValueLimen", SqlDbType.Int, 4),
new SqlParameter("@BitValueRadius", SqlDbType.Int, 4),
new SqlParameter("@BitValueBlackProportion", SqlDbType.Int, 4),
new SqlParameter("@MorphologicFilterParam", SqlDbType.Int, 4),
new SqlParameter("@SearchlimitParam", SqlDbType.Int, 4),
new SqlParameter("@WindowHeight", SqlDbType.Int, 4),
new SqlParameter("@LastOperDate", SqlDbType.DateTime)
};
parameters[0].Value = model.MeterId;
parameters[1].Value = model.CameraNo;
parameters[2].Value = model.NumberCount;
parameters[3].Value = model.CaptureStartPixs;
parameters[4].Value = model.UpClipPixs;
parameters[5].Value = model.DownClipPixs;
parameters[6].Value = model.LeftClipPixs;
parameters[7].Value = model.RightClipPixs;
parameters[8].Value = model.CircumgyrateDegree;
parameters[9].Value = model.InclineDegree;
parameters[10].Value = model.ModelHeight;
parameters[11].Value = model.ModelWidth;
parameters[12].Value = model.ModelOneWidth;
parameters[13].Value = model.NumberSpace;
parameters[14].Value = model.BitValueLimen;
parameters[15].Value = model.BitValueRadius;
parameters[16].Value = model.BitValueBlackProportion;
parameters[17].Value = model.MorphologicFilterParam;
parameters[18].Value = model.SearchlimitParam;
parameters[19].Value = model.WindowHeight;
parameters[20].Value = model.LastOperDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MeterImageParam DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.MeterImageParam model = new WebDemo.Model.WebDemo.MeterImageParam();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["MeterId"] != null && row["MeterId"].ToString() != "")
{
model.MeterId = int.Parse(row["MeterId"].ToString());
}
if (row["CameraNo"] != null && row["CameraNo"].ToString() != "")
{
model.CameraNo = int.Parse(row["CameraNo"].ToString());
}
if (row["NumberCount"] != null && row["NumberCount"].ToString() != "")
{
model.NumberCount = int.Parse(row["NumberCount"].ToString());
}
if (row["CaptureStartPixs"] != null && row["CaptureStartPixs"].ToString() != "")
{
model.CaptureStartPixs = int.Parse(row["CaptureStartPixs"].ToString());
}
if (row["UpClipPixs"] != null && row["UpClipPixs"].ToString() != "")
{
model.UpClipPixs = int.Parse(row["UpClipPixs"].ToString());
}
if (row["DownClipPixs"] != null && row["DownClipPixs"].ToString() != "")
{
model.DownClipPixs = int.Parse(row["DownClipPixs"].ToString());
}
if (row["LeftClipPixs"] != null && row["LeftClipPixs"].ToString() != "")
{
model.LeftClipPixs = int.Parse(row["LeftClipPixs"].ToString());
}
if (row["RightClipPixs"] != null && row["RightClipPixs"].ToString() != "")
{
model.RightClipPixs = int.Parse(row["RightClipPixs"].ToString());
}
if (row["CircumgyrateDegree"] != null && row["CircumgyrateDegree"].ToString() != "")
{
model.CircumgyrateDegree = int.Parse(row["CircumgyrateDegree"].ToString());
}
if (row["InclineDegree"] != null && row["InclineDegree"].ToString() != "")
{
model.InclineDegree = int.Parse(row["InclineDegree"].ToString());
}
if (row["ModelHeight"] != null && row["ModelHeight"].ToString() != "")
{
model.ModelHeight = int.Parse(row["ModelHeight"].ToString());
}
if (row["ModelWidth"] != null && row["ModelWidth"].ToString() != "")
{
model.ModelWidth = int.Parse(row["ModelWidth"].ToString());
}
if (row["ModelOneWidth"] != null && row["ModelOneWidth"].ToString() != "")
{
model.ModelOneWidth = int.Parse(row["ModelOneWidth"].ToString());
}
if (row["NumberSpace"] != null && row["NumberSpace"].ToString() != "")
{
model.NumberSpace = int.Parse(row["NumberSpace"].ToString());
}
if (row["BitValueLimen"] != null && row["BitValueLimen"].ToString() != "")
{
model.BitValueLimen = int.Parse(row["BitValueLimen"].ToString());
}
if (row["BitValueRadius"] != null && row["BitValueRadius"].ToString() != "")
{
model.BitValueRadius = int.Parse(row["BitValueRadius"].ToString());
}
if (row["BitValueBlackProportion"] != null && row["BitValueBlackProportion"].ToString() != "")
{
model.BitValueBlackProportion = int.Parse(row["BitValueBlackProportion"].ToString());
}
if (row["MorphologicFilterParam"] != null && row["MorphologicFilterParam"].ToString() != "")
{
model.MorphologicFilterParam = int.Parse(row["MorphologicFilterParam"].ToString());
}
if (row["SearchlimitParam"] != null && row["SearchlimitParam"].ToString() != "")
{
model.SearchlimitParam = int.Parse(row["SearchlimitParam"].ToString());
}
if (row["WindowHeight"] != null && row["WindowHeight"].ToString() != "")
{
model.WindowHeight = int.Parse(row["WindowHeight"].ToString());
}
if (row["LastOperDate"] != null && row["LastOperDate"].ToString() != "")
{
model.LastOperDate = DateTime.Parse(row["LastOperDate"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.MeterImageParam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MeterImageParam set ");
strSql.Append("NumberCount=@NumberCount,");
strSql.Append("CaptureStartPixs=@CaptureStartPixs,");
strSql.Append("UpClipPixs=@UpClipPixs,");
strSql.Append("DownClipPixs=@DownClipPixs,");
strSql.Append("LeftClipPixs=@LeftClipPixs,");
strSql.Append("RightClipPixs=@RightClipPixs,");
strSql.Append("CircumgyrateDegree=@CircumgyrateDegree,");
strSql.Append("InclineDegree=@InclineDegree,");
strSql.Append("ModelHeight=@ModelHeight,");
strSql.Append("ModelWidth=@ModelWidth,");
strSql.Append("ModelOneWidth=@ModelOneWidth,");
strSql.Append("NumberSpace=@NumberSpace,");
strSql.Append("BitValueLimen=@BitValueLimen,");
strSql.Append("BitValueRadius=@BitValueRadius,");
strSql.Append("BitValueBlackProportion=@BitValueBlackProportion,");
strSql.Append("MorphologicFilterParam=@MorphologicFilterParam,");
strSql.Append("SearchlimitParam=@SearchlimitParam,");
strSql.Append("WindowHeight=@WindowHeight,");
strSql.Append("LastOperDate=@LastOperDate");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@NumberCount", SqlDbType.Int, 4),
new SqlParameter("@CaptureStartPixs", SqlDbType.Int, 4),
new SqlParameter("@UpClipPixs", SqlDbType.Int, 4),
new SqlParameter("@DownClipPixs", SqlDbType.Int, 4),
new SqlParameter("@LeftClipPixs", SqlDbType.Int, 4),
new SqlParameter("@RightClipPixs", SqlDbType.Int, 4),
new SqlParameter("@CircumgyrateDegree", SqlDbType.Int, 4),
new SqlParameter("@InclineDegree", SqlDbType.Int, 4),
new SqlParameter("@ModelHeight", SqlDbType.Int, 4),
new SqlParameter("@ModelWidth", SqlDbType.Int, 4),
new SqlParameter("@ModelOneWidth", SqlDbType.Int, 4),
new SqlParameter("@NumberSpace", SqlDbType.Int, 4),
new SqlParameter("@BitValueLimen", SqlDbType.Int, 4),
new SqlParameter("@BitValueRadius", SqlDbType.Int, 4),
new SqlParameter("@BitValueBlackProportion", SqlDbType.Int, 4),
new SqlParameter("@MorphologicFilterParam", SqlDbType.Int, 4),
new SqlParameter("@SearchlimitParam", SqlDbType.Int, 4),
new SqlParameter("@WindowHeight", SqlDbType.Int, 4),
new SqlParameter("@LastOperDate", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@MeterId", SqlDbType.Int, 4),
new SqlParameter("@CameraNo", SqlDbType.Int, 4)
};
parameters[0].Value = model.NumberCount;
parameters[1].Value = model.CaptureStartPixs;
parameters[2].Value = model.UpClipPixs;
parameters[3].Value = model.DownClipPixs;
parameters[4].Value = model.LeftClipPixs;
parameters[5].Value = model.RightClipPixs;
parameters[6].Value = model.CircumgyrateDegree;
parameters[7].Value = model.InclineDegree;
parameters[8].Value = model.ModelHeight;
parameters[9].Value = model.ModelWidth;
parameters[10].Value = model.ModelOneWidth;
parameters[11].Value = model.NumberSpace;
parameters[12].Value = model.BitValueLimen;
parameters[13].Value = model.BitValueRadius;
parameters[14].Value = model.BitValueBlackProportion;
parameters[15].Value = model.MorphologicFilterParam;
parameters[16].Value = model.SearchlimitParam;
parameters[17].Value = model.WindowHeight;
parameters[18].Value = model.LastOperDate;
parameters[19].Value = model.Id;
parameters[20].Value = model.MeterId;
parameters[21].Value = model.CameraNo;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
