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); } }