/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.ManagePay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ManagePay set "); strSql.Append("UsersID=@UsersID,"); strSql.Append("OperMoney=@OperMoney,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("OperDate=@OperDate,"); strSql.Append("PayType=@PayType,"); strSql.Append("Flag=@Flag,"); strSql.Append("ThisReserve=@ThisReserve,"); strSql.Append("LastReserve=@LastReserve,"); strSql.Append("RedOperId=@RedOperId"); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@UsersID", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@ThisReserve", SqlDbType.Decimal, 9), new SqlParameter("@LastReserve", SqlDbType.Decimal, 9), new SqlParameter("@RedOperId", SqlDbType.Int, 4), new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = model.UsersID; parameters[1].Value = model.OperMoney; parameters[2].Value = model.OperatorID; parameters[3].Value = model.OperDate; parameters[4].Value = model.PayType; parameters[5].Value = model.Flag; parameters[6].Value = model.ThisReserve; parameters[7].Value = model.LastReserve; parameters[8].Value = model.RedOperId; parameters[9].Value = model.OperID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int OperID) { WebDemo.BLL.WebDemo.ManagePay bll = new WebDemo.BLL.WebDemo.ManagePay(); WebDemo.Model.WebDemo.ManagePay model = bll.GetModel(OperID); this.lblOperID.Text = model.OperID.ToString(); this.lblUsersID.Text = model.UsersID.ToString(); this.lblOperMoney.Text = model.OperMoney.ToString(); this.lblOperatorID.Text = model.OperatorID.ToString(); this.lblOperDate.Text = model.OperDate.ToString(); this.lblPayType.Text = model.PayType.ToString(); this.lblFlag.Text = model.Flag.ToString(); this.lblThisReserve.Text = model.ThisReserve.ToString(); this.lblLastReserve.Text = model.LastReserve.ToString(); this.lblRedOperId.Text = model.RedOperId.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.ManagePay DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.ManagePay model = new WebDemo.Model.WebDemo.ManagePay(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["UsersID"] != null && row["UsersID"].ToString() != "") { model.UsersID = int.Parse(row["UsersID"].ToString()); } if (row["OperMoney"] != null && row["OperMoney"].ToString() != "") { model.OperMoney = decimal.Parse(row["OperMoney"].ToString()); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["PayType"] != null && row["PayType"].ToString() != "") { model.PayType = int.Parse(row["PayType"].ToString()); } if (row["Flag"] != null && row["Flag"].ToString() != "") { model.Flag = int.Parse(row["Flag"].ToString()); } if (row["ThisReserve"] != null && row["ThisReserve"].ToString() != "") { model.ThisReserve = decimal.Parse(row["ThisReserve"].ToString()); } if (row["LastReserve"] != null && row["LastReserve"].ToString() != "") { model.LastReserve = decimal.Parse(row["LastReserve"].ToString()); } if (row["RedOperId"] != null && row["RedOperId"].ToString() != "") { model.RedOperId = int.Parse(row["RedOperId"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.ManagePay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ManagePay("); strSql.Append("UsersID,OperMoney,OperatorID,OperDate,PayType,Flag,ThisReserve,LastReserve,RedOperId)"); strSql.Append(" values ("); strSql.Append("@UsersID,@OperMoney,@OperatorID,@OperDate,@PayType,@Flag,@ThisReserve,@LastReserve,@RedOperId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UsersID", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@ThisReserve", SqlDbType.Decimal, 9), new SqlParameter("@LastReserve", SqlDbType.Decimal, 9), new SqlParameter("@RedOperId", SqlDbType.Int, 4) }; parameters[0].Value = model.UsersID; parameters[1].Value = model.OperMoney; parameters[2].Value = model.OperatorID; parameters[3].Value = model.OperDate; parameters[4].Value = model.PayType; parameters[5].Value = model.Flag; parameters[6].Value = model.ThisReserve; parameters[7].Value = model.LastReserve; parameters[8].Value = model.RedOperId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.ManagePay GetModel(int OperID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,UsersID,OperMoney,OperatorID,OperDate,PayType,Flag,ThisReserve,LastReserve,RedOperId from ManagePay "); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; WebDemo.Model.WebDemo.ManagePay model = new WebDemo.Model.WebDemo.ManagePay(); 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(txtUsersID.Text)) { strErr += "UsersID格式错误!\\n"; } if (!PageValidate.IsDecimal(txtOperMoney.Text)) { strErr += "OperMoney格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "OperDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayType.Text)) { strErr += "PayType格式错误!\\n"; } if (!PageValidate.IsNumber(txtFlag.Text)) { strErr += "Flag格式错误!\\n"; } if (!PageValidate.IsDecimal(txtThisReserve.Text)) { strErr += "ThisReserve格式错误!\\n"; } if (!PageValidate.IsDecimal(txtLastReserve.Text)) { strErr += "LastReserve格式错误!\\n"; } if (!PageValidate.IsNumber(txtRedOperId.Text)) { strErr += "RedOperId格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperID = int.Parse(this.lblOperID.Text); int UsersID = int.Parse(this.txtUsersID.Text); decimal OperMoney = decimal.Parse(this.txtOperMoney.Text); int OperatorID = int.Parse(this.txtOperatorID.Text); DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); int PayType = int.Parse(this.txtPayType.Text); int Flag = int.Parse(this.txtFlag.Text); decimal ThisReserve = decimal.Parse(this.txtThisReserve.Text); decimal LastReserve = decimal.Parse(this.txtLastReserve.Text); int RedOperId = int.Parse(this.txtRedOperId.Text); WebDemo.Model.WebDemo.ManagePay model = new WebDemo.Model.WebDemo.ManagePay(); model.OperID = OperID; model.UsersID = UsersID; model.OperMoney = OperMoney; model.OperatorID = OperatorID; model.OperDate = OperDate; model.PayType = PayType; model.Flag = Flag; model.ThisReserve = ThisReserve; model.LastReserve = LastReserve; model.RedOperId = RedOperId; WebDemo.BLL.WebDemo.ManagePay bll = new WebDemo.BLL.WebDemo.ManagePay(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }