private void ShowInfo(int id)
{
WebDemo.BLL.WebDemo.FreezeDayDosage bll = new WebDemo.BLL.WebDemo.FreezeDayDosage();
WebDemo.Model.WebDemo.FreezeDayDosage model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.txtMeterID.Text = model.MeterID.ToString();
this.txtFreezeDate.Text = model.FreezeDate;
this.txtUseNumber.Text = model.UseNumber.ToString();
this.txtDosageType.Text = model.DosageType.ToString();
this.txtInsertDate.Text = model.InsertDate.ToString();
this.txtBeginDate.Text = model.BeginDate;
this.txtBeginNumber.Text = model.BeginNumber.ToString();
this.txtEndNumber.Text = model.EndNumber.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.FreezeDayDosage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FreezeDayDosage set ");
strSql.Append("MeterID=@MeterID,");
strSql.Append("FreezeDate=@FreezeDate,");
strSql.Append("UseNumber=@UseNumber,");
strSql.Append("DosageType=@DosageType,");
strSql.Append("InsertDate=@InsertDate,");
strSql.Append("BeginDate=@BeginDate,");
strSql.Append("BeginNumber=@BeginNumber,");
strSql.Append("EndNumber=@EndNumber");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@FreezeDate", SqlDbType.VarChar, 10),
new SqlParameter("@UseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@DosageType", SqlDbType.Int, 4),
new SqlParameter("@InsertDate", SqlDbType.DateTime),
new SqlParameter("@BeginDate", SqlDbType.VarChar, 10),
new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9),
new SqlParameter("@EndNumber", SqlDbType.Decimal, 9),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.MeterID;
parameters[1].Value = model.FreezeDate;
parameters[2].Value = model.UseNumber;
parameters[3].Value = model.DosageType;
parameters[4].Value = model.InsertDate;
parameters[5].Value = model.BeginDate;
parameters[6].Value = model.BeginNumber;
parameters[7].Value = model.EndNumber;
parameters[8].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.FreezeDayDosage DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.FreezeDayDosage model = new WebDemo.Model.WebDemo.FreezeDayDosage();
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["FreezeDate"] != null)
{
model.FreezeDate = row["FreezeDate"].ToString();
}
if (row["UseNumber"] != null && row["UseNumber"].ToString() != "")
{
model.UseNumber = decimal.Parse(row["UseNumber"].ToString());
}
if (row["DosageType"] != null && row["DosageType"].ToString() != "")
{
model.DosageType = int.Parse(row["DosageType"].ToString());
}
if (row["InsertDate"] != null && row["InsertDate"].ToString() != "")
{
model.InsertDate = DateTime.Parse(row["InsertDate"].ToString());
}
if (row["BeginDate"] != null)
{
model.BeginDate = row["BeginDate"].ToString();
}
if (row["BeginNumber"] != null && row["BeginNumber"].ToString() != "")
{
model.BeginNumber = decimal.Parse(row["BeginNumber"].ToString());
}
if (row["EndNumber"] != null && row["EndNumber"].ToString() != "")
{
model.EndNumber = decimal.Parse(row["EndNumber"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.FreezeDayDosage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FreezeDayDosage(");
strSql.Append("MeterID,FreezeDate,UseNumber,DosageType,InsertDate,BeginDate,BeginNumber,EndNumber)");
strSql.Append(" values (");
strSql.Append("@MeterID,@FreezeDate,@UseNumber,@DosageType,@InsertDate,@BeginDate,@BeginNumber,@EndNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@FreezeDate", SqlDbType.VarChar, 10),
new SqlParameter("@UseNumber", SqlDbType.Decimal, 9),
new SqlParameter("@DosageType", SqlDbType.Int, 4),
new SqlParameter("@InsertDate", SqlDbType.DateTime),
new SqlParameter("@BeginDate", SqlDbType.VarChar, 10),
new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9),
new SqlParameter("@EndNumber", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MeterID;
parameters[1].Value = model.FreezeDate;
parameters[2].Value = model.UseNumber;
parameters[3].Value = model.DosageType;
parameters[4].Value = model.InsertDate;
parameters[5].Value = model.BeginDate;
parameters[6].Value = model.BeginNumber;
parameters[7].Value = model.EndNumber;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.FreezeDayDosage GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,MeterID,FreezeDate,UseNumber,DosageType,InsertDate,BeginDate,BeginNumber,EndNumber from FreezeDayDosage ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
WebDemo.Model.WebDemo.FreezeDayDosage model = new WebDemo.Model.WebDemo.FreezeDayDosage();
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.IsNumber(txtMeterID.Text))
{
strErr += "MeterID格式错误！\\n";
}
if (this.txtFreezeDate.Text.Trim().Length == 0)
{
strErr += "FreezeDate不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtUseNumber.Text))
{
strErr += "UseNumber格式错误！\\n";
}
if (!PageValidate.IsNumber(txtDosageType.Text))
{
strErr += "DosageType格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtInsertDate.Text))
{
strErr += "InsertDate格式错误！\\n";
}
if (this.txtBeginDate.Text.Trim().Length == 0)
{
strErr += "BeginDate不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtBeginNumber.Text))
{
strErr += "BeginNumber格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtEndNumber.Text))
{
strErr += "EndNumber格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int id = int.Parse(this.lblid.Text);
int MeterID = int.Parse(this.txtMeterID.Text);
string FreezeDate = this.txtFreezeDate.Text;
decimal UseNumber = decimal.Parse(this.txtUseNumber.Text);
int DosageType = int.Parse(this.txtDosageType.Text);
DateTime InsertDate = DateTime.Parse(this.txtInsertDate.Text);
string BeginDate = this.txtBeginDate.Text;
decimal BeginNumber = decimal.Parse(this.txtBeginNumber.Text);
decimal EndNumber = decimal.Parse(this.txtEndNumber.Text);
WebDemo.Model.WebDemo.FreezeDayDosage model = new WebDemo.Model.WebDemo.FreezeDayDosage();
model.id = id;
model.MeterID = MeterID;
model.FreezeDate = FreezeDate;
model.UseNumber = UseNumber;
model.DosageType = DosageType;
model.InsertDate = InsertDate;
model.BeginDate = BeginDate;
model.BeginNumber = BeginNumber;
model.EndNumber = EndNumber;
WebDemo.BLL.WebDemo.FreezeDayDosage bll = new WebDemo.BLL.WebDemo.FreezeDayDosage();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
