protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtCardId.Text))
{
strErr += "CardId格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtLostFreeNum.Text))
{
strErr += "LostFreeNum格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtSurplusMoney.Text))
{
strErr += "SurplusMoney格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtConsumeTime.Text))
{
strErr += "ConsumeTime格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterid.Text))
{
strErr += "Meterid格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtUseMoney.Text))
{
strErr += "UseMoney格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtInsDate.Text))
{
strErr += "InsDate格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int CardId = int.Parse(this.txtCardId.Text);
decimal LostFreeNum = decimal.Parse(this.txtLostFreeNum.Text);
decimal SurplusMoney = decimal.Parse(this.txtSurplusMoney.Text);
DateTime ConsumeTime = DateTime.Parse(this.txtConsumeTime.Text);
int Meterid = int.Parse(this.txtMeterid.Text);
decimal UseMoney = decimal.Parse(this.txtUseMoney.Text);
DateTime InsDate = DateTime.Parse(this.txtInsDate.Text);
WebDemo.Model.WebDemo.UpConsume model = new WebDemo.Model.WebDemo.UpConsume();
model.CardId = CardId;
model.LostFreeNum = LostFreeNum;
model.SurplusMoney = SurplusMoney;
model.ConsumeTime = ConsumeTime;
model.Meterid = Meterid;
model.UseMoney = UseMoney;
model.InsDate = InsDate;
WebDemo.BLL.WebDemo.UpConsume bll = new WebDemo.BLL.WebDemo.UpConsume();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
private void ShowInfo(int UpId)
{
WebDemo.BLL.WebDemo.UpConsume bll = new WebDemo.BLL.WebDemo.UpConsume();
WebDemo.Model.WebDemo.UpConsume model = bll.GetModel(UpId);
this.lblUpId.Text = model.UpId.ToString();
this.txtCardId.Text = model.CardId.ToString();
this.txtLostFreeNum.Text = model.LostFreeNum.ToString();
this.txtSurplusMoney.Text = model.SurplusMoney.ToString();
this.txtConsumeTime.Text = model.ConsumeTime.ToString();
this.txtMeterid.Text = model.Meterid.ToString();
this.txtUseMoney.Text = model.UseMoney.ToString();
this.txtInsDate.Text = model.InsDate.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.UpConsume model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UpConsume set ");
strSql.Append("CardId=@CardId,");
strSql.Append("LostFreeNum=@LostFreeNum,");
strSql.Append("SurplusMoney=@SurplusMoney,");
strSql.Append("ConsumeTime=@ConsumeTime,");
strSql.Append("Meterid=@Meterid,");
strSql.Append("UseMoney=@UseMoney,");
strSql.Append("InsDate=@InsDate");
strSql.Append(" where UpId=@UpId");
SqlParameter[] parameters =
{
new SqlParameter("@CardId", SqlDbType.Int, 4),
new SqlParameter("@LostFreeNum", SqlDbType.Decimal, 9),
new SqlParameter("@SurplusMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ConsumeTime", SqlDbType.DateTime),
new SqlParameter("@Meterid", SqlDbType.Int, 4),
new SqlParameter("@UseMoney", SqlDbType.Decimal, 9),
new SqlParameter("@InsDate", SqlDbType.DateTime),
new SqlParameter("@UpId", SqlDbType.Int, 4)
};
parameters[0].Value = model.CardId;
parameters[1].Value = model.LostFreeNum;
parameters[2].Value = model.SurplusMoney;
parameters[3].Value = model.ConsumeTime;
parameters[4].Value = model.Meterid;
parameters[5].Value = model.UseMoney;
parameters[6].Value = model.InsDate;
parameters[7].Value = model.UpId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.UpConsume DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.UpConsume model = new WebDemo.Model.WebDemo.UpConsume();
if (row != null)
{
if (row["UpId"] != null && row["UpId"].ToString() != "")
{
model.UpId = int.Parse(row["UpId"].ToString());
}
if (row["CardId"] != null && row["CardId"].ToString() != "")
{
model.CardId = int.Parse(row["CardId"].ToString());
}
if (row["LostFreeNum"] != null && row["LostFreeNum"].ToString() != "")
{
model.LostFreeNum = decimal.Parse(row["LostFreeNum"].ToString());
}
if (row["SurplusMoney"] != null && row["SurplusMoney"].ToString() != "")
{
model.SurplusMoney = decimal.Parse(row["SurplusMoney"].ToString());
}
if (row["ConsumeTime"] != null && row["ConsumeTime"].ToString() != "")
{
model.ConsumeTime = DateTime.Parse(row["ConsumeTime"].ToString());
}
if (row["Meterid"] != null && row["Meterid"].ToString() != "")
{
model.Meterid = int.Parse(row["Meterid"].ToString());
}
if (row["UseMoney"] != null && row["UseMoney"].ToString() != "")
{
model.UseMoney = decimal.Parse(row["UseMoney"].ToString());
}
if (row["InsDate"] != null && row["InsDate"].ToString() != "")
{
model.InsDate = DateTime.Parse(row["InsDate"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.UpConsume model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UpConsume(");
strSql.Append("CardId,LostFreeNum,SurplusMoney,ConsumeTime,Meterid,UseMoney,InsDate)");
strSql.Append(" values (");
strSql.Append("@CardId,@LostFreeNum,@SurplusMoney,@ConsumeTime,@Meterid,@UseMoney,@InsDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CardId", SqlDbType.Int, 4),
new SqlParameter("@LostFreeNum", SqlDbType.Decimal, 9),
new SqlParameter("@SurplusMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ConsumeTime", SqlDbType.DateTime),
new SqlParameter("@Meterid", SqlDbType.Int, 4),
new SqlParameter("@UseMoney", SqlDbType.Decimal, 9),
new SqlParameter("@InsDate", SqlDbType.DateTime)
};
parameters[0].Value = model.CardId;
parameters[1].Value = model.LostFreeNum;
parameters[2].Value = model.SurplusMoney;
parameters[3].Value = model.ConsumeTime;
parameters[4].Value = model.Meterid;
parameters[5].Value = model.UseMoney;
parameters[6].Value = model.InsDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.UpConsume GetModel(int UpId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UpId,CardId,LostFreeNum,SurplusMoney,ConsumeTime,Meterid,UseMoney,InsDate from UpConsume ");
strSql.Append(" where UpId=@UpId");
SqlParameter[] parameters =
{
new SqlParameter("@UpId", SqlDbType.Int, 4)
};
parameters[0].Value = UpId;
WebDemo.Model.WebDemo.UpConsume model = new WebDemo.Model.WebDemo.UpConsume();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
