/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.PreOperationFare GetModel(int OperID, string FareTypeName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,FareID,FareTypeName,FarePrice,FareMoney,FareMoney1,FarePrice2,FareMoney2,FarePrice3,FareMoney3,TaxRate from PreOperationFare "); strSql.Append(" where OperID=@OperID and FareTypeName=@FareTypeName "); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@FareTypeName", SqlDbType.VarChar, 50) }; parameters[0].Value = OperID; parameters[1].Value = FareTypeName; WebDemo.Model.WebDemo.PreOperationFare model = new WebDemo.Model.WebDemo.PreOperationFare(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.PreOperationFare model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PreOperationFare set "); strSql.Append("FareID=@FareID,"); strSql.Append("FarePrice=@FarePrice,"); strSql.Append("FareMoney=@FareMoney,"); strSql.Append("FareMoney1=@FareMoney1,"); strSql.Append("FarePrice2=@FarePrice2,"); strSql.Append("FareMoney2=@FareMoney2,"); strSql.Append("FarePrice3=@FarePrice3,"); strSql.Append("FareMoney3=@FareMoney3,"); strSql.Append("TaxRate=@TaxRate"); strSql.Append(" where OperID=@OperID and FareTypeName=@FareTypeName "); SqlParameter[] parameters = { new SqlParameter("@FareID", SqlDbType.Int, 4), new SqlParameter("@FarePrice", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney1", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice2", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney2", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice3", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney3", SqlDbType.Decimal, 9), new SqlParameter("@TaxRate", SqlDbType.Decimal, 9), new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@FareTypeName", SqlDbType.VarChar, 50) }; parameters[0].Value = model.FareID; parameters[1].Value = model.FarePrice; parameters[2].Value = model.FareMoney; parameters[3].Value = model.FareMoney1; parameters[4].Value = model.FarePrice2; parameters[5].Value = model.FareMoney2; parameters[6].Value = model.FarePrice3; parameters[7].Value = model.FareMoney3; parameters[8].Value = model.TaxRate; parameters[9].Value = model.OperID; parameters[10].Value = model.FareTypeName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.PreOperationFare DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.PreOperationFare model = new WebDemo.Model.WebDemo.PreOperationFare(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["FareID"] != null && row["FareID"].ToString() != "") { model.FareID = int.Parse(row["FareID"].ToString()); } if (row["FareTypeName"] != null) { model.FareTypeName = row["FareTypeName"].ToString(); } if (row["FarePrice"] != null && row["FarePrice"].ToString() != "") { model.FarePrice = decimal.Parse(row["FarePrice"].ToString()); } if (row["FareMoney"] != null && row["FareMoney"].ToString() != "") { model.FareMoney = decimal.Parse(row["FareMoney"].ToString()); } if (row["FareMoney1"] != null && row["FareMoney1"].ToString() != "") { model.FareMoney1 = decimal.Parse(row["FareMoney1"].ToString()); } if (row["FarePrice2"] != null && row["FarePrice2"].ToString() != "") { model.FarePrice2 = decimal.Parse(row["FarePrice2"].ToString()); } if (row["FareMoney2"] != null && row["FareMoney2"].ToString() != "") { model.FareMoney2 = decimal.Parse(row["FareMoney2"].ToString()); } if (row["FarePrice3"] != null && row["FarePrice3"].ToString() != "") { model.FarePrice3 = decimal.Parse(row["FarePrice3"].ToString()); } if (row["FareMoney3"] != null && row["FareMoney3"].ToString() != "") { model.FareMoney3 = decimal.Parse(row["FareMoney3"].ToString()); } if (row["TaxRate"] != null && row["TaxRate"].ToString() != "") { model.TaxRate = decimal.Parse(row["TaxRate"].ToString()); } } return(model); }
private void ShowInfo(int OperID, string FareTypeName) { WebDemo.BLL.WebDemo.PreOperationFare bll = new WebDemo.BLL.WebDemo.PreOperationFare(); WebDemo.Model.WebDemo.PreOperationFare model = bll.GetModel(OperID, FareTypeName); this.lblOperID.Text = model.OperID.ToString(); this.txtFareID.Text = model.FareID.ToString(); this.lblFareTypeName.Text = model.FareTypeName; this.txtFarePrice.Text = model.FarePrice.ToString(); this.txtFareMoney.Text = model.FareMoney.ToString(); this.txtFareMoney1.Text = model.FareMoney1.ToString(); this.txtFarePrice2.Text = model.FarePrice2.ToString(); this.txtFareMoney2.Text = model.FareMoney2.ToString(); this.txtFarePrice3.Text = model.FarePrice3.ToString(); this.txtFareMoney3.Text = model.FareMoney3.ToString(); this.txtTaxRate.Text = model.TaxRate.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.PreOperationFare model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PreOperationFare("); strSql.Append("OperID,FareID,FareTypeName,FarePrice,FareMoney,FareMoney1,FarePrice2,FareMoney2,FarePrice3,FareMoney3,TaxRate)"); strSql.Append(" values ("); strSql.Append("@OperID,@FareID,@FareTypeName,@FarePrice,@FareMoney,@FareMoney1,@FarePrice2,@FareMoney2,@FarePrice3,@FareMoney3,@TaxRate)"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@FareID", SqlDbType.Int, 4), new SqlParameter("@FareTypeName", SqlDbType.VarChar, 50), new SqlParameter("@FarePrice", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney1", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice2", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney2", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice3", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney3", SqlDbType.Decimal, 9), new SqlParameter("@TaxRate", SqlDbType.Decimal, 9) }; parameters[0].Value = model.OperID; parameters[1].Value = model.FareID; parameters[2].Value = model.FareTypeName; parameters[3].Value = model.FarePrice; parameters[4].Value = model.FareMoney; parameters[5].Value = model.FareMoney1; parameters[6].Value = model.FarePrice2; parameters[7].Value = model.FareMoney2; parameters[8].Value = model.FarePrice3; parameters[9].Value = model.FareMoney3; parameters[10].Value = model.TaxRate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtOperID.Text)) { strErr += "业务编号格式错误!\\n"; } if (!PageValidate.IsNumber(txtFareID.Text)) { strErr += "FareID格式错误!\\n"; } if (this.txtFareTypeName.Text.Trim().Length == 0) { strErr += "费用名称不能为空!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice.Text)) { strErr += "单价格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney.Text)) { strErr += "金额格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney1.Text)) { strErr += "FareMoney1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice2.Text)) { strErr += "FarePrice2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney2.Text)) { strErr += "FareMoney2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice3.Text)) { strErr += "FarePrice3格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney3.Text)) { strErr += "FareMoney3格式错误!\\n"; } if (!PageValidate.IsDecimal(txtTaxRate.Text)) { strErr += "TaxRate格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperID = int.Parse(this.txtOperID.Text); int FareID = int.Parse(this.txtFareID.Text); string FareTypeName = this.txtFareTypeName.Text; decimal FarePrice = decimal.Parse(this.txtFarePrice.Text); decimal FareMoney = decimal.Parse(this.txtFareMoney.Text); decimal FareMoney1 = decimal.Parse(this.txtFareMoney1.Text); decimal FarePrice2 = decimal.Parse(this.txtFarePrice2.Text); decimal FareMoney2 = decimal.Parse(this.txtFareMoney2.Text); decimal FarePrice3 = decimal.Parse(this.txtFarePrice3.Text); decimal FareMoney3 = decimal.Parse(this.txtFareMoney3.Text); decimal TaxRate = decimal.Parse(this.txtTaxRate.Text); WebDemo.Model.WebDemo.PreOperationFare model = new WebDemo.Model.WebDemo.PreOperationFare(); model.OperID = OperID; model.FareID = FareID; model.FareTypeName = FareTypeName; model.FarePrice = FarePrice; model.FareMoney = FareMoney; model.FareMoney1 = FareMoney1; model.FarePrice2 = FarePrice2; model.FareMoney2 = FareMoney2; model.FarePrice3 = FarePrice3; model.FareMoney3 = FareMoney3; model.TaxRate = TaxRate; WebDemo.BLL.WebDemo.PreOperationFare bll = new WebDemo.BLL.WebDemo.PreOperationFare(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }