private void ShowInfo(int ID)
{
WebDemo.BLL.WebDemo.FreezeMonth bll = new WebDemo.BLL.WebDemo.FreezeMonth();
WebDemo.Model.WebDemo.FreezeMonth model = bll.GetModel(ID);
this.lblID.Text = model.ID.ToString();
this.lblMeterID.Text = model.MeterID.ToString();
this.lblFreezeMonth.Text = model.FreezeMonth;
this.lblFreezeNumber.Text = model.FreezeNumber.ToString();
this.lblReadDate.Text = model.ReadDate.ToString();
this.lblCalMark.Text = model.CalMark?"是":"否";
this.lblInstantNumber.Text = model.InstantNumber.ToString();
this.lblPileNumber.Text = model.PileNumber.ToString();
this.lblWatertemp.Text = model.Watertemp.ToString();
this.lblBackWatertemp.Text = model.BackWatertemp.ToString();
this.lblWorkDate.Text = model.WorkDate.ToString();
this.lblFactDate.Text = model.FactDate;
this.lblBatteryState.Text = model.BatteryState.ToString();
this.lblWarning.Text = model.Warning.ToString();
this.lblReadType.Text = model.ReadType.ToString();
this.lblOldFreezeNumber.Text = model.OldFreezeNumber.ToString();
this.lblMegabit.Text = model.Megabit.ToString();
this.lblAdditionNum.Text = model.AdditionNum.ToString();
this.lblSmallImagePath.Text = model.SmallImagePath;
this.lblBigImagePath.Text = model.BigImagePath;
this.lblLocationX.Text = model.LocationX.ToString();
this.lblLocationY.Text = model.LocationY.ToString();
this.lblRemark.Text = model.Remark;
this.lblTakePhotoDate.Text = model.TakePhotoDate.ToString();
this.lblSyncFlag.Text = model.SyncFlag.ToString();
this.lblPriceSetNo.Text = model.PriceSetNo.ToString();
this.lblCollectorReadDate.Text = model.CollectorReadDate.ToString();
this.lblActiveSharp.Text = model.ActiveSharp.ToString();
this.lblActivePeak.Text = model.ActivePeak.ToString();
this.lblActiveShoulder.Text = model.ActiveShoulder.ToString();
this.lblActiveOffPeak.Text = model.ActiveOffPeak.ToString();
this.lblMeterStatusString.Text = model.MeterStatusString;
this.lblVerifyValue.Text = model.VerifyValue.ToString();
this.lblRemnant.Text = model.Remnant.ToString();
this.lblValveState.Text = model.ValveState.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.FreezeMonth GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MeterID,FreezeMonth,FreezeNumber,ReadDate,CalMark,InstantNumber,PileNumber,Watertemp,BackWatertemp,WorkDate,FactDate,BatteryState,Warning,ReadType,OldFreezeNumber,Megabit,AdditionNum,SmallImagePath,BigImagePath,LocationX,LocationY,Remark,TakePhotoDate,SyncFlag,PriceSetNo,CollectorReadDate,ActiveSharp,ActivePeak,ActiveShoulder,ActiveOffPeak,MeterStatusString,VerifyValue,Remnant,ValveState from FreezeMonth ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
WebDemo.Model.WebDemo.FreezeMonth model = new WebDemo.Model.WebDemo.FreezeMonth();
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 += "表编号格式错误！\\n";
}
if (this.txtFreezeMonth.Text.Trim().Length == 0)
{
strErr += "冻结月不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtFreezeNumber.Text))
{
strErr += "日冻结读数格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtReadDate.Text))
{
strErr += "ReadDate格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtInstantNumber.Text))
{
strErr += "InstantNumber格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtPileNumber.Text))
{
strErr += "PileNumber格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtWatertemp.Text))
{
strErr += "Watertemp格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBackWatertemp.Text))
{
strErr += "BackWatertemp格式错误！\\n";
}
if (!PageValidate.IsNumber(txtWorkDate.Text))
{
strErr += "WorkDate格式错误！\\n";
}
if (this.txtFactDate.Text.Trim().Length == 0)
{
strErr += "FactDate不能为空！\\n";
}
if (!PageValidate.IsNumber(txtBatteryState.Text))
{
strErr += "BatteryState格式错误！\\n";
}
if (!PageValidate.IsNumber(txtWarning.Text))
{
strErr += "Warning格式错误！\\n";
}
if (!PageValidate.IsNumber(txtReadType.Text))
{
strErr += "抄表方式 1 自动抄表 2 手格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtOldFreezeNumber.Text))
{
strErr += "OldFreezeNumber格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMegabit.Text))
{
strErr += "Megabit格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtAdditionNum.Text))
{
strErr += "AdditionNum格式错误！\\n";
}
if (this.txtSmallImagePath.Text.Trim().Length == 0)
{
strErr += "SmallImagePath不能为空！\\n";
}
if (this.txtBigImagePath.Text.Trim().Length == 0)
{
strErr += "BigImagePath不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtLocationX.Text))
{
strErr += "LocationX格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtLocationY.Text))
{
strErr += "LocationY格式错误！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "Remark不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtTakePhotoDate.Text))
{
strErr += "TakePhotoDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtSyncFlag.Text))
{
strErr += "SyncFlag格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPriceSetNo.Text))
{
strErr += "PriceSetNo格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtCollectorReadDate.Text))
{
strErr += "CollectorReadDate格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtActiveSharp.Text))
{
strErr += "ActiveSharp格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtActivePeak.Text))
{
strErr += "ActivePeak格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtActiveShoulder.Text))
{
strErr += "ActiveShoulder格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtActiveOffPeak.Text))
{
strErr += "ActiveOffPeak格式错误！\\n";
}
if (this.txtMeterStatusString.Text.Trim().Length == 0)
{
strErr += "MeterStatusString不能为空！\\n";
}
if (!PageValidate.IsNumber(txtVerifyValue.Text))
{
strErr += "VerifyValue格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtRemnant.Text))
{
strErr += "Remnant格式错误！\\n";
}
if (!PageValidate.IsNumber(txtValveState.Text))
{
strErr += "ValveState格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int MeterID = int.Parse(this.txtMeterID.Text);
string FreezeMonth = this.txtFreezeMonth.Text;
decimal FreezeNumber = decimal.Parse(this.txtFreezeNumber.Text);
DateTime ReadDate = DateTime.Parse(this.txtReadDate.Text);
bool CalMark = this.chkCalMark.Checked;
decimal InstantNumber = decimal.Parse(this.txtInstantNumber.Text);
decimal PileNumber = decimal.Parse(this.txtPileNumber.Text);
decimal Watertemp = decimal.Parse(this.txtWatertemp.Text);
decimal BackWatertemp = decimal.Parse(this.txtBackWatertemp.Text);
int WorkDate = int.Parse(this.txtWorkDate.Text);
string FactDate = this.txtFactDate.Text;
int BatteryState = int.Parse(this.txtBatteryState.Text);
int Warning = int.Parse(this.txtWarning.Text);
int ReadType = int.Parse(this.txtReadType.Text);
decimal OldFreezeNumber = decimal.Parse(this.txtOldFreezeNumber.Text);
int Megabit = int.Parse(this.txtMegabit.Text);
decimal AdditionNum = decimal.Parse(this.txtAdditionNum.Text);
string SmallImagePath = this.txtSmallImagePath.Text;
string BigImagePath = this.txtBigImagePath.Text;
decimal LocationX = decimal.Parse(this.txtLocationX.Text);
decimal LocationY = decimal.Parse(this.txtLocationY.Text);
string Remark = this.txtRemark.Text;
DateTime TakePhotoDate = DateTime.Parse(this.txtTakePhotoDate.Text);
int SyncFlag = int.Parse(this.txtSyncFlag.Text);
int PriceSetNo = int.Parse(this.txtPriceSetNo.Text);
DateTime CollectorReadDate = DateTime.Parse(this.txtCollectorReadDate.Text);
decimal ActiveSharp = decimal.Parse(this.txtActiveSharp.Text);
decimal ActivePeak = decimal.Parse(this.txtActivePeak.Text);
decimal ActiveShoulder = decimal.Parse(this.txtActiveShoulder.Text);
decimal ActiveOffPeak = decimal.Parse(this.txtActiveOffPeak.Text);
string MeterStatusString = this.txtMeterStatusString.Text;
int VerifyValue = int.Parse(this.txtVerifyValue.Text);
decimal Remnant = decimal.Parse(this.txtRemnant.Text);
int ValveState = int.Parse(this.txtValveState.Text);
WebDemo.Model.WebDemo.FreezeMonth model = new WebDemo.Model.WebDemo.FreezeMonth();
model.MeterID = MeterID;
model.FreezeMonth = FreezeMonth;
model.FreezeNumber = FreezeNumber;
model.ReadDate = ReadDate;
model.CalMark = CalMark;
model.InstantNumber = InstantNumber;
model.PileNumber = PileNumber;
model.Watertemp = Watertemp;
model.BackWatertemp = BackWatertemp;
model.WorkDate = WorkDate;
model.FactDate = FactDate;
model.BatteryState = BatteryState;
model.Warning = Warning;
model.ReadType = ReadType;
model.OldFreezeNumber = OldFreezeNumber;
model.Megabit = Megabit;
model.AdditionNum = AdditionNum;
model.SmallImagePath = SmallImagePath;
model.BigImagePath = BigImagePath;
model.LocationX = LocationX;
model.LocationY = LocationY;
model.Remark = Remark;
model.TakePhotoDate = TakePhotoDate;
model.SyncFlag = SyncFlag;
model.PriceSetNo = PriceSetNo;
model.CollectorReadDate = CollectorReadDate;
model.ActiveSharp = ActiveSharp;
model.ActivePeak = ActivePeak;
model.ActiveShoulder = ActiveShoulder;
model.ActiveOffPeak = ActiveOffPeak;
model.MeterStatusString = MeterStatusString;
model.VerifyValue = VerifyValue;
model.Remnant = Remnant;
model.ValveState = ValveState;
WebDemo.BLL.WebDemo.FreezeMonth bll = new WebDemo.BLL.WebDemo.FreezeMonth();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.FreezeMonth model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FreezeMonth(");
strSql.Append("MeterID,FreezeMonth,FreezeNumber,ReadDate,CalMark,InstantNumber,PileNumber,Watertemp,BackWatertemp,WorkDate,FactDate,BatteryState,Warning,ReadType,OldFreezeNumber,Megabit,AdditionNum,SmallImagePath,BigImagePath,LocationX,LocationY,Remark,TakePhotoDate,SyncFlag,PriceSetNo,CollectorReadDate,ActiveSharp,ActivePeak,ActiveShoulder,ActiveOffPeak,MeterStatusString,VerifyValue,Remnant,ValveState)");
strSql.Append(" values (");
strSql.Append("@MeterID,@FreezeMonth,@FreezeNumber,@ReadDate,@CalMark,@InstantNumber,@PileNumber,@Watertemp,@BackWatertemp,@WorkDate,@FactDate,@BatteryState,@Warning,@ReadType,@OldFreezeNumber,@Megabit,@AdditionNum,@SmallImagePath,@BigImagePath,@LocationX,@LocationY,@Remark,@TakePhotoDate,@SyncFlag,@PriceSetNo,@CollectorReadDate,@ActiveSharp,@ActivePeak,@ActiveShoulder,@ActiveOffPeak,@MeterStatusString,@VerifyValue,@Remnant,@ValveState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@FreezeMonth", SqlDbType.Char, 7),
new SqlParameter("@FreezeNumber", SqlDbType.Decimal, 9),
new SqlParameter("@ReadDate", SqlDbType.DateTime),
new SqlParameter("@CalMark", SqlDbType.Bit, 1),
new SqlParameter("@InstantNumber", SqlDbType.Decimal, 9),
new SqlParameter("@PileNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Watertemp", SqlDbType.Decimal, 9),
new SqlParameter("@BackWatertemp", SqlDbType.Decimal, 9),
new SqlParameter("@WorkDate", SqlDbType.Int, 4),
new SqlParameter("@FactDate", SqlDbType.VarChar, 50),
new SqlParameter("@BatteryState", SqlDbType.Int, 4),
new SqlParameter("@Warning", SqlDbType.Int, 4),
new SqlParameter("@ReadType", SqlDbType.Int, 4),
new SqlParameter("@OldFreezeNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Megabit", SqlDbType.Int, 4),
new SqlParameter("@AdditionNum", SqlDbType.Decimal, 9),
new SqlParameter("@SmallImagePath", SqlDbType.VarChar, 500),
new SqlParameter("@BigImagePath", SqlDbType.VarChar, 500),
new SqlParameter("@LocationX", SqlDbType.Decimal, 9),
new SqlParameter("@LocationY", SqlDbType.Decimal, 9),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@TakePhotoDate", SqlDbType.DateTime),
new SqlParameter("@SyncFlag", SqlDbType.Int, 4),
new SqlParameter("@PriceSetNo", SqlDbType.Int, 4),
new SqlParameter("@CollectorReadDate", SqlDbType.DateTime),
new SqlParameter("@ActiveSharp", SqlDbType.Decimal, 9),
new SqlParameter("@ActivePeak", SqlDbType.Decimal, 9),
new SqlParameter("@ActiveShoulder", SqlDbType.Decimal, 9),
new SqlParameter("@ActiveOffPeak", SqlDbType.Decimal, 9),
new SqlParameter("@MeterStatusString", SqlDbType.VarChar, 1000),
new SqlParameter("@VerifyValue", SqlDbType.Int, 4),
new SqlParameter("@Remnant", SqlDbType.Decimal, 9),
new SqlParameter("@ValveState", SqlDbType.Int, 4)
};
parameters[0].Value = model.MeterID;
parameters[1].Value = model.FreezeMonth;
parameters[2].Value = model.FreezeNumber;
parameters[3].Value = model.ReadDate;
parameters[4].Value = model.CalMark;
parameters[5].Value = model.InstantNumber;
parameters[6].Value = model.PileNumber;
parameters[7].Value = model.Watertemp;
parameters[8].Value = model.BackWatertemp;
parameters[9].Value = model.WorkDate;
parameters[10].Value = model.FactDate;
parameters[11].Value = model.BatteryState;
parameters[12].Value = model.Warning;
parameters[13].Value = model.ReadType;
parameters[14].Value = model.OldFreezeNumber;
parameters[15].Value = model.Megabit;
parameters[16].Value = model.AdditionNum;
parameters[17].Value = model.SmallImagePath;
parameters[18].Value = model.BigImagePath;
parameters[19].Value = model.LocationX;
parameters[20].Value = model.LocationY;
parameters[21].Value = model.Remark;
parameters[22].Value = model.TakePhotoDate;
parameters[23].Value = model.SyncFlag;
parameters[24].Value = model.PriceSetNo;
parameters[25].Value = model.CollectorReadDate;
parameters[26].Value = model.ActiveSharp;
parameters[27].Value = model.ActivePeak;
parameters[28].Value = model.ActiveShoulder;
parameters[29].Value = model.ActiveOffPeak;
parameters[30].Value = model.MeterStatusString;
parameters[31].Value = model.VerifyValue;
parameters[32].Value = model.Remnant;
parameters[33].Value = model.ValveState;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.FreezeMonth DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.FreezeMonth model = new WebDemo.Model.WebDemo.FreezeMonth();
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["FreezeMonth"] != null)
{
model.FreezeMonth = row["FreezeMonth"].ToString();
}
if (row["FreezeNumber"] != null && row["FreezeNumber"].ToString() != "")
{
model.FreezeNumber = decimal.Parse(row["FreezeNumber"].ToString());
}
if (row["ReadDate"] != null && row["ReadDate"].ToString() != "")
{
model.ReadDate = DateTime.Parse(row["ReadDate"].ToString());
}
if (row["CalMark"] != null && row["CalMark"].ToString() != "")
{
if ((row["CalMark"].ToString() == "1") || (row["CalMark"].ToString().ToLower() == "true"))
{
model.CalMark = true;
}
else
{
model.CalMark = false;
}
}
if (row["InstantNumber"] != null && row["InstantNumber"].ToString() != "")
{
model.InstantNumber = decimal.Parse(row["InstantNumber"].ToString());
}
if (row["PileNumber"] != null && row["PileNumber"].ToString() != "")
{
model.PileNumber = decimal.Parse(row["PileNumber"].ToString());
}
if (row["Watertemp"] != null && row["Watertemp"].ToString() != "")
{
model.Watertemp = decimal.Parse(row["Watertemp"].ToString());
}
if (row["BackWatertemp"] != null && row["BackWatertemp"].ToString() != "")
{
model.BackWatertemp = decimal.Parse(row["BackWatertemp"].ToString());
}
if (row["WorkDate"] != null && row["WorkDate"].ToString() != "")
{
model.WorkDate = int.Parse(row["WorkDate"].ToString());
}
if (row["FactDate"] != null)
{
model.FactDate = row["FactDate"].ToString();
}
if (row["BatteryState"] != null && row["BatteryState"].ToString() != "")
{
model.BatteryState = int.Parse(row["BatteryState"].ToString());
}
if (row["Warning"] != null && row["Warning"].ToString() != "")
{
model.Warning = int.Parse(row["Warning"].ToString());
}
if (row["ReadType"] != null && row["ReadType"].ToString() != "")
{
model.ReadType = int.Parse(row["ReadType"].ToString());
}
if (row["OldFreezeNumber"] != null && row["OldFreezeNumber"].ToString() != "")
{
model.OldFreezeNumber = decimal.Parse(row["OldFreezeNumber"].ToString());
}
if (row["Megabit"] != null && row["Megabit"].ToString() != "")
{
model.Megabit = int.Parse(row["Megabit"].ToString());
}
if (row["AdditionNum"] != null && row["AdditionNum"].ToString() != "")
{
model.AdditionNum = decimal.Parse(row["AdditionNum"].ToString());
}
if (row["SmallImagePath"] != null)
{
model.SmallImagePath = row["SmallImagePath"].ToString();
}
if (row["BigImagePath"] != null)
{
model.BigImagePath = row["BigImagePath"].ToString();
}
if (row["LocationX"] != null && row["LocationX"].ToString() != "")
{
model.LocationX = decimal.Parse(row["LocationX"].ToString());
}
if (row["LocationY"] != null && row["LocationY"].ToString() != "")
{
model.LocationY = decimal.Parse(row["LocationY"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["TakePhotoDate"] != null && row["TakePhotoDate"].ToString() != "")
{
model.TakePhotoDate = DateTime.Parse(row["TakePhotoDate"].ToString());
}
if (row["SyncFlag"] != null && row["SyncFlag"].ToString() != "")
{
model.SyncFlag = int.Parse(row["SyncFlag"].ToString());
}
if (row["PriceSetNo"] != null && row["PriceSetNo"].ToString() != "")
{
model.PriceSetNo = int.Parse(row["PriceSetNo"].ToString());
}
if (row["CollectorReadDate"] != null && row["CollectorReadDate"].ToString() != "")
{
model.CollectorReadDate = DateTime.Parse(row["CollectorReadDate"].ToString());
}
if (row["ActiveSharp"] != null && row["ActiveSharp"].ToString() != "")
{
model.ActiveSharp = decimal.Parse(row["ActiveSharp"].ToString());
}
if (row["ActivePeak"] != null && row["ActivePeak"].ToString() != "")
{
model.ActivePeak = decimal.Parse(row["ActivePeak"].ToString());
}
if (row["ActiveShoulder"] != null && row["ActiveShoulder"].ToString() != "")
{
model.ActiveShoulder = decimal.Parse(row["ActiveShoulder"].ToString());
}
if (row["ActiveOffPeak"] != null && row["ActiveOffPeak"].ToString() != "")
{
model.ActiveOffPeak = decimal.Parse(row["ActiveOffPeak"].ToString());
}
if (row["MeterStatusString"] != null)
{
model.MeterStatusString = row["MeterStatusString"].ToString();
}
if (row["VerifyValue"] != null && row["VerifyValue"].ToString() != "")
{
model.VerifyValue = int.Parse(row["VerifyValue"].ToString());
}
if (row["Remnant"] != null && row["Remnant"].ToString() != "")
{
model.Remnant = decimal.Parse(row["Remnant"].ToString());
}
if (row["ValveState"] != null && row["ValveState"].ToString() != "")
{
model.ValveState = int.Parse(row["ValveState"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.FreezeMonth model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FreezeMonth set ");
strSql.Append("FreezeNumber=@FreezeNumber,");
strSql.Append("CalMark=@CalMark,");
strSql.Append("InstantNumber=@InstantNumber,");
strSql.Append("PileNumber=@PileNumber,");
strSql.Append("Watertemp=@Watertemp,");
strSql.Append("BackWatertemp=@BackWatertemp,");
strSql.Append("WorkDate=@WorkDate,");
strSql.Append("FactDate=@FactDate,");
strSql.Append("BatteryState=@BatteryState,");
strSql.Append("Warning=@Warning,");
strSql.Append("ReadType=@ReadType,");
strSql.Append("OldFreezeNumber=@OldFreezeNumber,");
strSql.Append("Megabit=@Megabit,");
strSql.Append("AdditionNum=@AdditionNum,");
strSql.Append("SmallImagePath=@SmallImagePath,");
strSql.Append("BigImagePath=@BigImagePath,");
strSql.Append("LocationX=@LocationX,");
strSql.Append("LocationY=@LocationY,");
strSql.Append("Remark=@Remark,");
strSql.Append("TakePhotoDate=@TakePhotoDate,");
strSql.Append("SyncFlag=@SyncFlag,");
strSql.Append("PriceSetNo=@PriceSetNo,");
strSql.Append("CollectorReadDate=@CollectorReadDate,");
strSql.Append("ActiveSharp=@ActiveSharp,");
strSql.Append("ActivePeak=@ActivePeak,");
strSql.Append("ActiveShoulder=@ActiveShoulder,");
strSql.Append("ActiveOffPeak=@ActiveOffPeak,");
strSql.Append("MeterStatusString=@MeterStatusString,");
strSql.Append("VerifyValue=@VerifyValue,");
strSql.Append("Remnant=@Remnant,");
strSql.Append("ValveState=@ValveState");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@FreezeNumber", SqlDbType.Decimal, 9),
new SqlParameter("@CalMark", SqlDbType.Bit, 1),
new SqlParameter("@InstantNumber", SqlDbType.Decimal, 9),
new SqlParameter("@PileNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Watertemp", SqlDbType.Decimal, 9),
new SqlParameter("@BackWatertemp", SqlDbType.Decimal, 9),
new SqlParameter("@WorkDate", SqlDbType.Int, 4),
new SqlParameter("@FactDate", SqlDbType.VarChar, 50),
new SqlParameter("@BatteryState", SqlDbType.Int, 4),
new SqlParameter("@Warning", SqlDbType.Int, 4),
new SqlParameter("@ReadType", SqlDbType.Int, 4),
new SqlParameter("@OldFreezeNumber", SqlDbType.Decimal, 9),
new SqlParameter("@Megabit", SqlDbType.Int, 4),
new SqlParameter("@AdditionNum", SqlDbType.Decimal, 9),
new SqlParameter("@SmallImagePath", SqlDbType.VarChar, 500),
new SqlParameter("@BigImagePath", SqlDbType.VarChar, 500),
new SqlParameter("@LocationX", SqlDbType.Decimal, 9),
new SqlParameter("@LocationY", SqlDbType.Decimal, 9),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@TakePhotoDate", SqlDbType.DateTime),
new SqlParameter("@SyncFlag", SqlDbType.Int, 4),
new SqlParameter("@PriceSetNo", SqlDbType.Int, 4),
new SqlParameter("@CollectorReadDate", SqlDbType.DateTime),
new SqlParameter("@ActiveSharp", SqlDbType.Decimal, 9),
new SqlParameter("@ActivePeak", SqlDbType.Decimal, 9),
new SqlParameter("@ActiveShoulder", SqlDbType.Decimal, 9),
new SqlParameter("@ActiveOffPeak", SqlDbType.Decimal, 9),
new SqlParameter("@MeterStatusString", SqlDbType.VarChar, 1000),
new SqlParameter("@VerifyValue", SqlDbType.Int, 4),
new SqlParameter("@Remnant", SqlDbType.Decimal, 9),
new SqlParameter("@ValveState", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@FreezeMonth", SqlDbType.Char, 7),
new SqlParameter("@ReadDate", SqlDbType.DateTime)
};
parameters[0].Value = model.FreezeNumber;
parameters[1].Value = model.CalMark;
parameters[2].Value = model.InstantNumber;
parameters[3].Value = model.PileNumber;
parameters[4].Value = model.Watertemp;
parameters[5].Value = model.BackWatertemp;
parameters[6].Value = model.WorkDate;
parameters[7].Value = model.FactDate;
parameters[8].Value = model.BatteryState;
parameters[9].Value = model.Warning;
parameters[10].Value = model.ReadType;
parameters[11].Value = model.OldFreezeNumber;
parameters[12].Value = model.Megabit;
parameters[13].Value = model.AdditionNum;
parameters[14].Value = model.SmallImagePath;
parameters[15].Value = model.BigImagePath;
parameters[16].Value = model.LocationX;
parameters[17].Value = model.LocationY;
parameters[18].Value = model.Remark;
parameters[19].Value = model.TakePhotoDate;
parameters[20].Value = model.SyncFlag;
parameters[21].Value = model.PriceSetNo;
parameters[22].Value = model.CollectorReadDate;
parameters[23].Value = model.ActiveSharp;
parameters[24].Value = model.ActivePeak;
parameters[25].Value = model.ActiveShoulder;
parameters[26].Value = model.ActiveOffPeak;
parameters[27].Value = model.MeterStatusString;
parameters[28].Value = model.VerifyValue;
parameters[29].Value = model.Remnant;
parameters[30].Value = model.ValveState;
parameters[31].Value = model.ID;
parameters[32].Value = model.MeterID;
parameters[33].Value = model.FreezeMonth;
parameters[34].Value = model.ReadDate;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
