/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.FreezeMonthDosage DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.FreezeMonthDosage model = new WebDemo.Model.WebDemo.FreezeMonthDosage(); 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["BeginMonth"] != null) { model.BeginMonth = row["BeginMonth"].ToString(); } if (row["BeginNumber"] != null && row["BeginNumber"].ToString() != "") { model.BeginNumber = decimal.Parse(row["BeginNumber"].ToString()); } if (row["FreezeMonth"] != null) { model.FreezeMonth = row["FreezeMonth"].ToString(); } if (row["EndNumber"] != null && row["EndNumber"].ToString() != "") { model.EndNumber = decimal.Parse(row["EndNumber"].ToString()); } if (row["UseNumber"] != null && row["UseNumber"].ToString() != "") { model.UseNumber = decimal.Parse(row["UseNumber"].ToString()); } if (row["InsertDate"] != null && row["InsertDate"].ToString() != "") { model.InsertDate = DateTime.Parse(row["InsertDate"].ToString()); } if (row["UseActiveSharp"] != null && row["UseActiveSharp"].ToString() != "") { model.UseActiveSharp = decimal.Parse(row["UseActiveSharp"].ToString()); } if (row["UseActivePeak"] != null && row["UseActivePeak"].ToString() != "") { model.UseActivePeak = decimal.Parse(row["UseActivePeak"].ToString()); } if (row["UseActiveShoulder"] != null && row["UseActiveShoulder"].ToString() != "") { model.UseActiveShoulder = decimal.Parse(row["UseActiveShoulder"].ToString()); } if (row["UseActiveOffPeak"] != null && row["UseActiveOffPeak"].ToString() != "") { model.UseActiveOffPeak = decimal.Parse(row["UseActiveOffPeak"].ToString()); } if (row["SyncFlag"] != null && row["SyncFlag"].ToString() != "") { model.SyncFlag = int.Parse(row["SyncFlag"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.FreezeMonthDosage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FreezeMonthDosage set "); strSql.Append("BeginMonth=@BeginMonth,"); strSql.Append("BeginNumber=@BeginNumber,"); strSql.Append("EndNumber=@EndNumber,"); strSql.Append("UseNumber=@UseNumber,"); strSql.Append("InsertDate=@InsertDate,"); strSql.Append("UseActiveSharp=@UseActiveSharp,"); strSql.Append("UseActivePeak=@UseActivePeak,"); strSql.Append("UseActiveShoulder=@UseActiveShoulder,"); strSql.Append("UseActiveOffPeak=@UseActiveOffPeak,"); strSql.Append("SyncFlag=@SyncFlag"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@BeginMonth", SqlDbType.VarChar, 7), new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9), new SqlParameter("@EndNumber", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber", SqlDbType.Decimal, 9), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@UseActiveSharp", SqlDbType.Decimal, 9), new SqlParameter("@UseActivePeak", SqlDbType.Decimal, 9), new SqlParameter("@UseActiveShoulder", SqlDbType.Decimal, 9), new SqlParameter("@UseActiveOffPeak", SqlDbType.Decimal, 9), new SqlParameter("@SyncFlag", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@FreezeMonth", SqlDbType.VarChar, 7) }; parameters[0].Value = model.BeginMonth; parameters[1].Value = model.BeginNumber; parameters[2].Value = model.EndNumber; parameters[3].Value = model.UseNumber; parameters[4].Value = model.InsertDate; parameters[5].Value = model.UseActiveSharp; parameters[6].Value = model.UseActivePeak; parameters[7].Value = model.UseActiveShoulder; parameters[8].Value = model.UseActiveOffPeak; parameters[9].Value = model.SyncFlag; parameters[10].Value = model.id; parameters[11].Value = model.MeterID; parameters[12].Value = model.FreezeMonth; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.FreezeMonthDosage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FreezeMonthDosage("); strSql.Append("MeterID,BeginMonth,BeginNumber,FreezeMonth,EndNumber,UseNumber,InsertDate,UseActiveSharp,UseActivePeak,UseActiveShoulder,UseActiveOffPeak,SyncFlag)"); strSql.Append(" values ("); strSql.Append("@MeterID,@BeginMonth,@BeginNumber,@FreezeMonth,@EndNumber,@UseNumber,@InsertDate,@UseActiveSharp,@UseActivePeak,@UseActiveShoulder,@UseActiveOffPeak,@SyncFlag)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@BeginMonth", SqlDbType.VarChar, 7), new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9), new SqlParameter("@FreezeMonth", SqlDbType.VarChar, 7), new SqlParameter("@EndNumber", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber", SqlDbType.Decimal, 9), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@UseActiveSharp", SqlDbType.Decimal, 9), new SqlParameter("@UseActivePeak", SqlDbType.Decimal, 9), new SqlParameter("@UseActiveShoulder", SqlDbType.Decimal, 9), new SqlParameter("@UseActiveOffPeak", SqlDbType.Decimal, 9), new SqlParameter("@SyncFlag", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.BeginMonth; parameters[2].Value = model.BeginNumber; parameters[3].Value = model.FreezeMonth; parameters[4].Value = model.EndNumber; parameters[5].Value = model.UseNumber; parameters[6].Value = model.InsertDate; parameters[7].Value = model.UseActiveSharp; parameters[8].Value = model.UseActivePeak; parameters[9].Value = model.UseActiveShoulder; parameters[10].Value = model.UseActiveOffPeak; parameters[11].Value = model.SyncFlag; 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.FreezeMonthDosage bll = new WebDemo.BLL.WebDemo.FreezeMonthDosage(); WebDemo.Model.WebDemo.FreezeMonthDosage model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblMeterID.Text = model.MeterID.ToString(); this.lblBeginMonth.Text = model.BeginMonth; this.lblBeginNumber.Text = model.BeginNumber.ToString(); this.lblFreezeMonth.Text = model.FreezeMonth; this.lblEndNumber.Text = model.EndNumber.ToString(); this.lblUseNumber.Text = model.UseNumber.ToString(); this.lblInsertDate.Text = model.InsertDate.ToString(); this.lblUseActiveSharp.Text = model.UseActiveSharp.ToString(); this.lblUseActivePeak.Text = model.UseActivePeak.ToString(); this.lblUseActiveShoulder.Text = model.UseActiveShoulder.ToString(); this.lblUseActiveOffPeak.Text = model.UseActiveOffPeak.ToString(); this.lblSyncFlag.Text = model.SyncFlag.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.FreezeMonthDosage GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,MeterID,BeginMonth,BeginNumber,FreezeMonth,EndNumber,UseNumber,InsertDate,UseActiveSharp,UseActivePeak,UseActiveShoulder,UseActiveOffPeak,SyncFlag from FreezeMonthDosage "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; WebDemo.Model.WebDemo.FreezeMonthDosage model = new WebDemo.Model.WebDemo.FreezeMonthDosage(); 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 (this.txtBeginMonth.Text.Trim().Length == 0) { strErr += "BeginMonth不能为空!\\n"; } if (!PageValidate.IsDecimal(txtBeginNumber.Text)) { strErr += "BeginNumber格式错误!\\n"; } if (!PageValidate.IsDecimal(txtEndNumber.Text)) { strErr += "EndNumber格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber.Text)) { strErr += "UseNumber格式错误!\\n"; } if (!PageValidate.IsDateTime(txtInsertDate.Text)) { strErr += "InsertDate格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseActiveSharp.Text)) { strErr += "UseActiveSharp格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseActivePeak.Text)) { strErr += "UseActivePeak格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseActiveShoulder.Text)) { strErr += "UseActiveShoulder格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseActiveOffPeak.Text)) { strErr += "UseActiveOffPeak格式错误!\\n"; } if (!PageValidate.IsNumber(txtSyncFlag.Text)) { strErr += "SyncFlag格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int id = int.Parse(this.lblid.Text); int MeterID = int.Parse(this.lblMeterID.Text); string BeginMonth = this.txtBeginMonth.Text; decimal BeginNumber = decimal.Parse(this.txtBeginNumber.Text); string FreezeMonth = this.lblFreezeMonth.Text; decimal EndNumber = decimal.Parse(this.txtEndNumber.Text); decimal UseNumber = decimal.Parse(this.txtUseNumber.Text); DateTime InsertDate = DateTime.Parse(this.txtInsertDate.Text); decimal UseActiveSharp = decimal.Parse(this.txtUseActiveSharp.Text); decimal UseActivePeak = decimal.Parse(this.txtUseActivePeak.Text); decimal UseActiveShoulder = decimal.Parse(this.txtUseActiveShoulder.Text); decimal UseActiveOffPeak = decimal.Parse(this.txtUseActiveOffPeak.Text); int SyncFlag = int.Parse(this.txtSyncFlag.Text); WebDemo.Model.WebDemo.FreezeMonthDosage model = new WebDemo.Model.WebDemo.FreezeMonthDosage(); model.id = id; model.MeterID = MeterID; model.BeginMonth = BeginMonth; model.BeginNumber = BeginNumber; model.FreezeMonth = FreezeMonth; model.EndNumber = EndNumber; model.UseNumber = UseNumber; model.InsertDate = InsertDate; model.UseActiveSharp = UseActiveSharp; model.UseActivePeak = UseActivePeak; model.UseActiveShoulder = UseActiveShoulder; model.UseActiveOffPeak = UseActiveOffPeak; model.SyncFlag = SyncFlag; WebDemo.BLL.WebDemo.FreezeMonthDosage bll = new WebDemo.BLL.WebDemo.FreezeMonthDosage(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }