/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.MultiOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MultiOperation("); strSql.Append("MultiUserID,CardID,CardSector,OperMoney,LastBalance,CurrentBalance,TotalMoney,OperType,InvoiceCode,OperDate,OperatorID,Remark,InvoiceID,InvoiceType)"); strSql.Append(" values ("); strSql.Append("@MultiUserID,@CardID,@CardSector,@OperMoney,@LastBalance,@CurrentBalance,@TotalMoney,@OperType,@InvoiceCode,@OperDate,@OperatorID,@Remark,@InvoiceID,@InvoiceType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MultiUserID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@CardSector", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastBalance", SqlDbType.Decimal, 9), new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@InvoiceID", SqlDbType.Int, 4), new SqlParameter("@InvoiceType", SqlDbType.Int, 4) }; parameters[0].Value = model.MultiUserID; parameters[1].Value = model.CardID; parameters[2].Value = model.CardSector; parameters[3].Value = model.OperMoney; parameters[4].Value = model.LastBalance; parameters[5].Value = model.CurrentBalance; parameters[6].Value = model.TotalMoney; parameters[7].Value = model.OperType; parameters[8].Value = model.InvoiceCode; parameters[9].Value = model.OperDate; parameters[10].Value = model.OperatorID; parameters[11].Value = model.Remark; parameters[12].Value = model.InvoiceID; parameters[13].Value = model.InvoiceType; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int OperID) { WebDemo.BLL.WebDemo.MultiOperation bll = new WebDemo.BLL.WebDemo.MultiOperation(); WebDemo.Model.WebDemo.MultiOperation model = bll.GetModel(OperID); this.lblOperID.Text = model.OperID.ToString(); this.lblMultiUserID.Text = model.MultiUserID.ToString(); this.lblCardID.Text = model.CardID.ToString(); this.lblCardSector.Text = model.CardSector.ToString(); this.lblOperMoney.Text = model.OperMoney.ToString(); this.lblLastBalance.Text = model.LastBalance.ToString(); this.lblCurrentBalance.Text = model.CurrentBalance.ToString(); this.lblTotalMoney.Text = model.TotalMoney.ToString(); this.lblOperType.Text = model.OperType.ToString(); this.lblInvoiceCode.Text = model.InvoiceCode; this.lblOperDate.Text = model.OperDate.ToString(); this.lblOperatorID.Text = model.OperatorID.ToString(); this.lblRemark.Text = model.Remark; this.lblInvoiceID.Text = model.InvoiceID.ToString(); this.lblInvoiceType.Text = model.InvoiceType.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MultiOperation GetModel(int OperID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,MultiUserID,CardID,CardSector,OperMoney,LastBalance,CurrentBalance,TotalMoney,OperType,InvoiceCode,OperDate,OperatorID,Remark,InvoiceID,InvoiceType from MultiOperation "); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMultiUserID.Text)) { strErr += "MultiUserID格式错误!\\n"; } if (!PageValidate.IsNumber(txtCardID.Text)) { strErr += "CardID格式错误!\\n"; } if (!PageValidate.IsNumber(txtCardSector.Text)) { strErr += "CardSector格式错误!\\n"; } if (!PageValidate.IsDecimal(txtOperMoney.Text)) { strErr += "OperMoney格式错误!\\n"; } if (!PageValidate.IsDecimal(txtLastBalance.Text)) { strErr += "LastBalance格式错误!\\n"; } if (!PageValidate.IsDecimal(txtCurrentBalance.Text)) { strErr += "CurrentBalance格式错误!\\n"; } if (!PageValidate.IsDecimal(txtTotalMoney.Text)) { strErr += "TotalMoney格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperType.Text)) { strErr += "OperType格式错误!\\n"; } if (this.txtInvoiceCode.Text.Trim().Length == 0) { strErr += "InvoiceCode不能为空!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "OperDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (!PageValidate.IsNumber(txtInvoiceID.Text)) { strErr += "InvoiceID格式错误!\\n"; } if (!PageValidate.IsNumber(txtInvoiceType.Text)) { strErr += "InvoiceType格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int MultiUserID = int.Parse(this.txtMultiUserID.Text); int CardID = int.Parse(this.txtCardID.Text); int CardSector = int.Parse(this.txtCardSector.Text); decimal OperMoney = decimal.Parse(this.txtOperMoney.Text); decimal LastBalance = decimal.Parse(this.txtLastBalance.Text); decimal CurrentBalance = decimal.Parse(this.txtCurrentBalance.Text); decimal TotalMoney = decimal.Parse(this.txtTotalMoney.Text); int OperType = int.Parse(this.txtOperType.Text); string InvoiceCode = this.txtInvoiceCode.Text; DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); int OperatorID = int.Parse(this.txtOperatorID.Text); string Remark = this.txtRemark.Text; int InvoiceID = int.Parse(this.txtInvoiceID.Text); int InvoiceType = int.Parse(this.txtInvoiceType.Text); WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation(); model.MultiUserID = MultiUserID; model.CardID = CardID; model.CardSector = CardSector; model.OperMoney = OperMoney; model.LastBalance = LastBalance; model.CurrentBalance = CurrentBalance; model.TotalMoney = TotalMoney; model.OperType = OperType; model.InvoiceCode = InvoiceCode; model.OperDate = OperDate; model.OperatorID = OperatorID; model.Remark = Remark; model.InvoiceID = InvoiceID; model.InvoiceType = InvoiceType; WebDemo.BLL.WebDemo.MultiOperation bll = new WebDemo.BLL.WebDemo.MultiOperation(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MultiOperation DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.MultiOperation model = new WebDemo.Model.WebDemo.MultiOperation(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["MultiUserID"] != null && row["MultiUserID"].ToString() != "") { model.MultiUserID = int.Parse(row["MultiUserID"].ToString()); } if (row["CardID"] != null && row["CardID"].ToString() != "") { model.CardID = int.Parse(row["CardID"].ToString()); } if (row["CardSector"] != null && row["CardSector"].ToString() != "") { model.CardSector = int.Parse(row["CardSector"].ToString()); } if (row["OperMoney"] != null && row["OperMoney"].ToString() != "") { model.OperMoney = decimal.Parse(row["OperMoney"].ToString()); } if (row["LastBalance"] != null && row["LastBalance"].ToString() != "") { model.LastBalance = decimal.Parse(row["LastBalance"].ToString()); } if (row["CurrentBalance"] != null && row["CurrentBalance"].ToString() != "") { model.CurrentBalance = decimal.Parse(row["CurrentBalance"].ToString()); } if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "") { model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString()); } if (row["OperType"] != null && row["OperType"].ToString() != "") { model.OperType = int.Parse(row["OperType"].ToString()); } if (row["InvoiceCode"] != null) { model.InvoiceCode = row["InvoiceCode"].ToString(); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["InvoiceID"] != null && row["InvoiceID"].ToString() != "") { model.InvoiceID = int.Parse(row["InvoiceID"].ToString()); } if (row["InvoiceType"] != null && row["InvoiceType"].ToString() != "") { model.InvoiceType = int.Parse(row["InvoiceType"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.MultiOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MultiOperation set "); strSql.Append("MultiUserID=@MultiUserID,"); strSql.Append("CardID=@CardID,"); strSql.Append("CardSector=@CardSector,"); strSql.Append("OperMoney=@OperMoney,"); strSql.Append("LastBalance=@LastBalance,"); strSql.Append("CurrentBalance=@CurrentBalance,"); strSql.Append("TotalMoney=@TotalMoney,"); strSql.Append("OperType=@OperType,"); strSql.Append("InvoiceCode=@InvoiceCode,"); strSql.Append("OperDate=@OperDate,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("Remark=@Remark,"); strSql.Append("InvoiceID=@InvoiceID,"); strSql.Append("InvoiceType=@InvoiceType"); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@MultiUserID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@CardSector", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastBalance", SqlDbType.Decimal, 9), new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@InvoiceID", SqlDbType.Int, 4), new SqlParameter("@InvoiceType", SqlDbType.Int, 4), new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = model.MultiUserID; parameters[1].Value = model.CardID; parameters[2].Value = model.CardSector; parameters[3].Value = model.OperMoney; parameters[4].Value = model.LastBalance; parameters[5].Value = model.CurrentBalance; parameters[6].Value = model.TotalMoney; parameters[7].Value = model.OperType; parameters[8].Value = model.InvoiceCode; parameters[9].Value = model.OperDate; parameters[10].Value = model.OperatorID; parameters[11].Value = model.Remark; parameters[12].Value = model.InvoiceID; parameters[13].Value = model.InvoiceType; parameters[14].Value = model.OperID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }