/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.MeterImageData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MeterImageData("); strSql.Append("MeterID,ReadTime,Voltage,ValveState,LowVoltage,MagneticDisturb,ImageQuality,EnableUpload,MeterImage,InsertDate,FreezeNumber,LeftMeterImage,RightMeterImage)"); strSql.Append(" values ("); strSql.Append("@MeterID,@ReadTime,@Voltage,@ValveState,@LowVoltage,@MagneticDisturb,@ImageQuality,@EnableUpload,@MeterImage,@InsertDate,@FreezeNumber,@LeftMeterImage,@RightMeterImage)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@ReadTime", SqlDbType.DateTime), new SqlParameter("@Voltage", SqlDbType.Decimal, 9), new SqlParameter("@ValveState", SqlDbType.Int, 4), new SqlParameter("@LowVoltage", SqlDbType.Bit, 1), new SqlParameter("@MagneticDisturb", SqlDbType.Bit, 1), new SqlParameter("@ImageQuality", SqlDbType.Int, 4), new SqlParameter("@EnableUpload", SqlDbType.Bit, 1), new SqlParameter("@MeterImage", SqlDbType.VarBinary, -1), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@FreezeNumber", SqlDbType.Decimal, 9), new SqlParameter("@LeftMeterImage", SqlDbType.VarBinary, -1), new SqlParameter("@RightMeterImage", SqlDbType.VarBinary, -1) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.ReadTime; parameters[2].Value = model.Voltage; parameters[3].Value = model.ValveState; parameters[4].Value = model.LowVoltage; parameters[5].Value = model.MagneticDisturb; parameters[6].Value = model.ImageQuality; parameters[7].Value = model.EnableUpload; parameters[8].Value = model.MeterImage; parameters[9].Value = model.InsertDate; parameters[10].Value = model.FreezeNumber; parameters[11].Value = model.LeftMeterImage; parameters[12].Value = model.RightMeterImage; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int ID) { WebDemo.BLL.WebDemo.MeterImageData bll = new WebDemo.BLL.WebDemo.MeterImageData(); WebDemo.Model.WebDemo.MeterImageData model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.lblMeterID.Text = model.MeterID.ToString(); this.txtReadTime.Text = model.ReadTime.ToString(); this.txtVoltage.Text = model.Voltage.ToString(); this.txtValveState.Text = model.ValveState.ToString(); this.chkLowVoltage.Checked = model.LowVoltage; this.chkMagneticDisturb.Checked = model.MagneticDisturb; this.txtImageQuality.Text = model.ImageQuality.ToString(); this.chkEnableUpload.Checked = model.EnableUpload; this.txtMeterImage.Text = model.MeterImage.ToString(); this.txtInsertDate.Text = model.InsertDate.ToString(); this.txtFreezeNumber.Text = model.FreezeNumber.ToString(); this.txtLeftMeterImage.Text = model.LeftMeterImage.ToString(); this.txtRightMeterImage.Text = model.RightMeterImage.ToString(); }
private void ShowInfo(int ID) { WebDemo.BLL.WebDemo.MeterImageData bll = new WebDemo.BLL.WebDemo.MeterImageData(); WebDemo.Model.WebDemo.MeterImageData model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.lblMeterID.Text = model.MeterID.ToString(); this.lblReadTime.Text = model.ReadTime.ToString(); this.lblVoltage.Text = model.Voltage.ToString(); this.lblValveState.Text = model.ValveState.ToString(); this.lblLowVoltage.Text = model.LowVoltage?"是":"否"; this.lblMagneticDisturb.Text = model.MagneticDisturb?"是":"否"; this.lblImageQuality.Text = model.ImageQuality.ToString(); this.lblEnableUpload.Text = model.EnableUpload?"是":"否"; this.lblMeterImage.Text = model.MeterImage.ToString(); this.lblInsertDate.Text = model.InsertDate.ToString(); this.lblFreezeNumber.Text = model.FreezeNumber.ToString(); this.lblLeftMeterImage.Text = model.LeftMeterImage.ToString(); this.lblRightMeterImage.Text = model.RightMeterImage.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MeterImageData GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,MeterID,ReadTime,Voltage,ValveState,LowVoltage,MagneticDisturb,ImageQuality,EnableUpload,MeterImage,InsertDate,FreezeNumber,LeftMeterImage,RightMeterImage from MeterImageData "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; WebDemo.Model.WebDemo.MeterImageData model = new WebDemo.Model.WebDemo.MeterImageData(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtReadTime.Text)) { strErr += "ReadTime格式错误!\\n"; } if (!PageValidate.IsDecimal(txtVoltage.Text)) { strErr += "Voltage格式错误!\\n"; } if (!PageValidate.IsNumber(txtValveState.Text)) { strErr += "ValveState格式错误!\\n"; } if (!PageValidate.IsNumber(txtImageQuality.Text)) { strErr += "ImageQuality格式错误!\\n"; } if (!PageValidate.IsDateTime(txtInsertDate.Text)) { strErr += "InsertDate格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFreezeNumber.Text)) { strErr += "FreezeNumber格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ID = int.Parse(this.lblID.Text); int MeterID = int.Parse(this.lblMeterID.Text); DateTime ReadTime = DateTime.Parse(this.txtReadTime.Text); decimal Voltage = decimal.Parse(this.txtVoltage.Text); int ValveState = int.Parse(this.txtValveState.Text); bool LowVoltage = this.chkLowVoltage.Checked; bool MagneticDisturb = this.chkMagneticDisturb.Checked; int ImageQuality = int.Parse(this.txtImageQuality.Text); bool EnableUpload = this.chkEnableUpload.Checked; byte[] MeterImage = new UnicodeEncoding().GetBytes(this.txtMeterImage.Text); DateTime InsertDate = DateTime.Parse(this.txtInsertDate.Text); decimal FreezeNumber = decimal.Parse(this.txtFreezeNumber.Text); byte[] LeftMeterImage = new UnicodeEncoding().GetBytes(this.txtLeftMeterImage.Text); byte[] RightMeterImage = new UnicodeEncoding().GetBytes(this.txtRightMeterImage.Text); WebDemo.Model.WebDemo.MeterImageData model = new WebDemo.Model.WebDemo.MeterImageData(); model.ID = ID; model.MeterID = MeterID; model.ReadTime = ReadTime; model.Voltage = Voltage; model.ValveState = ValveState; model.LowVoltage = LowVoltage; model.MagneticDisturb = MagneticDisturb; model.ImageQuality = ImageQuality; model.EnableUpload = EnableUpload; model.MeterImage = MeterImage; model.InsertDate = InsertDate; model.FreezeNumber = FreezeNumber; model.LeftMeterImage = LeftMeterImage; model.RightMeterImage = RightMeterImage; WebDemo.BLL.WebDemo.MeterImageData bll = new WebDemo.BLL.WebDemo.MeterImageData(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MeterImageData DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.MeterImageData model = new WebDemo.Model.WebDemo.MeterImageData(); 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["ReadTime"] != null && row["ReadTime"].ToString() != "") { model.ReadTime = DateTime.Parse(row["ReadTime"].ToString()); } if (row["Voltage"] != null && row["Voltage"].ToString() != "") { model.Voltage = decimal.Parse(row["Voltage"].ToString()); } if (row["ValveState"] != null && row["ValveState"].ToString() != "") { model.ValveState = int.Parse(row["ValveState"].ToString()); } if (row["LowVoltage"] != null && row["LowVoltage"].ToString() != "") { if ((row["LowVoltage"].ToString() == "1") || (row["LowVoltage"].ToString().ToLower() == "true")) { model.LowVoltage = true; } else { model.LowVoltage = false; } } if (row["MagneticDisturb"] != null && row["MagneticDisturb"].ToString() != "") { if ((row["MagneticDisturb"].ToString() == "1") || (row["MagneticDisturb"].ToString().ToLower() == "true")) { model.MagneticDisturb = true; } else { model.MagneticDisturb = false; } } if (row["ImageQuality"] != null && row["ImageQuality"].ToString() != "") { model.ImageQuality = int.Parse(row["ImageQuality"].ToString()); } if (row["EnableUpload"] != null && row["EnableUpload"].ToString() != "") { if ((row["EnableUpload"].ToString() == "1") || (row["EnableUpload"].ToString().ToLower() == "true")) { model.EnableUpload = true; } else { model.EnableUpload = false; } } if (row["MeterImage"] != null && row["MeterImage"].ToString() != "") { model.MeterImage = (byte[])row["MeterImage"]; } if (row["InsertDate"] != null && row["InsertDate"].ToString() != "") { model.InsertDate = DateTime.Parse(row["InsertDate"].ToString()); } if (row["FreezeNumber"] != null && row["FreezeNumber"].ToString() != "") { model.FreezeNumber = decimal.Parse(row["FreezeNumber"].ToString()); } if (row["LeftMeterImage"] != null && row["LeftMeterImage"].ToString() != "") { model.LeftMeterImage = (byte[])row["LeftMeterImage"]; } if (row["RightMeterImage"] != null && row["RightMeterImage"].ToString() != "") { model.RightMeterImage = (byte[])row["RightMeterImage"]; } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.MeterImageData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MeterImageData set "); strSql.Append("ReadTime=@ReadTime,"); strSql.Append("Voltage=@Voltage,"); strSql.Append("ValveState=@ValveState,"); strSql.Append("LowVoltage=@LowVoltage,"); strSql.Append("MagneticDisturb=@MagneticDisturb,"); strSql.Append("ImageQuality=@ImageQuality,"); strSql.Append("EnableUpload=@EnableUpload,"); strSql.Append("MeterImage=@MeterImage,"); strSql.Append("InsertDate=@InsertDate,"); strSql.Append("FreezeNumber=@FreezeNumber,"); strSql.Append("LeftMeterImage=@LeftMeterImage,"); strSql.Append("RightMeterImage=@RightMeterImage"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ReadTime", SqlDbType.DateTime), new SqlParameter("@Voltage", SqlDbType.Decimal, 9), new SqlParameter("@ValveState", SqlDbType.Int, 4), new SqlParameter("@LowVoltage", SqlDbType.Bit, 1), new SqlParameter("@MagneticDisturb", SqlDbType.Bit, 1), new SqlParameter("@ImageQuality", SqlDbType.Int, 4), new SqlParameter("@EnableUpload", SqlDbType.Bit, 1), new SqlParameter("@MeterImage", SqlDbType.VarBinary, -1), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@FreezeNumber", SqlDbType.Decimal, 9), new SqlParameter("@LeftMeterImage", SqlDbType.VarBinary, -1), new SqlParameter("@RightMeterImage", SqlDbType.VarBinary, -1), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@MeterID", SqlDbType.Int, 4) }; parameters[0].Value = model.ReadTime; parameters[1].Value = model.Voltage; parameters[2].Value = model.ValveState; parameters[3].Value = model.LowVoltage; parameters[4].Value = model.MagneticDisturb; parameters[5].Value = model.ImageQuality; parameters[6].Value = model.EnableUpload; parameters[7].Value = model.MeterImage; parameters[8].Value = model.InsertDate; parameters[9].Value = model.FreezeNumber; parameters[10].Value = model.LeftMeterImage; parameters[11].Value = model.RightMeterImage; parameters[12].Value = model.ID; parameters[13].Value = model.MeterID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }