/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationFareDay GetModel(int OperID, int FareID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,FareID,FareTypeName,FarePrice,FareMoney,FarePrice2,FarePrice3,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2 from OperationFareDay "); strSql.Append(" where OperID=@OperID and FareID=@FareID "); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@FareID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; parameters[1].Value = FareID; WebDemo.Model.WebDemo.OperationFareDay model = new WebDemo.Model.WebDemo.OperationFareDay(); 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 Add(WebDemo.Model.WebDemo.OperationFareDay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OperationFareDay("); strSql.Append("OperID,FareID,FareTypeName,FarePrice,FareMoney,FarePrice2,FarePrice3,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2)"); strSql.Append(" values ("); strSql.Append("@OperID,@FareID,@FareTypeName,@FarePrice,@FareMoney,@FarePrice2,@FarePrice3,@Divid1,@Divid2,@UseNumber1,@UseNumber2,@UseNumber3,@ExtData1,@ExtData2)"); 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("@FarePrice2", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice3", SqlDbType.Decimal, 9), new SqlParameter("@Divid1", SqlDbType.Int, 4), new SqlParameter("@Divid2", SqlDbType.Int, 4), new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9), new SqlParameter("@ExtData1", SqlDbType.VarChar, 50), new SqlParameter("@ExtData2", SqlDbType.VarChar, 50) }; 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.FarePrice2; parameters[6].Value = model.FarePrice3; parameters[7].Value = model.Divid1; parameters[8].Value = model.Divid2; parameters[9].Value = model.UseNumber1; parameters[10].Value = model.UseNumber2; parameters[11].Value = model.UseNumber3; parameters[12].Value = model.ExtData1; parameters[13].Value = model.ExtData2; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int OperID, int FareID) { WebDemo.BLL.WebDemo.OperationFareDay bll = new WebDemo.BLL.WebDemo.OperationFareDay(); WebDemo.Model.WebDemo.OperationFareDay model = bll.GetModel(OperID, FareID); this.lblOperID.Text = model.OperID.ToString(); this.lblFareID.Text = model.FareID.ToString(); this.txtFareTypeName.Text = model.FareTypeName; this.txtFarePrice.Text = model.FarePrice.ToString(); this.txtFareMoney.Text = model.FareMoney.ToString(); this.txtFarePrice2.Text = model.FarePrice2.ToString(); this.txtFarePrice3.Text = model.FarePrice3.ToString(); this.txtDivid1.Text = model.Divid1.ToString(); this.txtDivid2.Text = model.Divid2.ToString(); this.txtUseNumber1.Text = model.UseNumber1.ToString(); this.txtUseNumber2.Text = model.UseNumber2.ToString(); this.txtUseNumber3.Text = model.UseNumber3.ToString(); this.txtExtData1.Text = model.ExtData1; this.txtExtData2.Text = model.ExtData2; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationFareDay DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.OperationFareDay model = new WebDemo.Model.WebDemo.OperationFareDay(); 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["FarePrice2"] != null && row["FarePrice2"].ToString() != "") { model.FarePrice2 = decimal.Parse(row["FarePrice2"].ToString()); } if (row["FarePrice3"] != null && row["FarePrice3"].ToString() != "") { model.FarePrice3 = decimal.Parse(row["FarePrice3"].ToString()); } if (row["Divid1"] != null && row["Divid1"].ToString() != "") { model.Divid1 = int.Parse(row["Divid1"].ToString()); } if (row["Divid2"] != null && row["Divid2"].ToString() != "") { model.Divid2 = int.Parse(row["Divid2"].ToString()); } if (row["UseNumber1"] != null && row["UseNumber1"].ToString() != "") { model.UseNumber1 = decimal.Parse(row["UseNumber1"].ToString()); } if (row["UseNumber2"] != null && row["UseNumber2"].ToString() != "") { model.UseNumber2 = decimal.Parse(row["UseNumber2"].ToString()); } if (row["UseNumber3"] != null && row["UseNumber3"].ToString() != "") { model.UseNumber3 = decimal.Parse(row["UseNumber3"].ToString()); } if (row["ExtData1"] != null) { model.ExtData1 = row["ExtData1"].ToString(); } if (row["ExtData2"] != null) { model.ExtData2 = row["ExtData2"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.OperationFareDay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OperationFareDay set "); strSql.Append("FareTypeName=@FareTypeName,"); strSql.Append("FarePrice=@FarePrice,"); strSql.Append("FareMoney=@FareMoney,"); strSql.Append("FarePrice2=@FarePrice2,"); strSql.Append("FarePrice3=@FarePrice3,"); strSql.Append("Divid1=@Divid1,"); strSql.Append("Divid2=@Divid2,"); strSql.Append("UseNumber1=@UseNumber1,"); strSql.Append("UseNumber2=@UseNumber2,"); strSql.Append("UseNumber3=@UseNumber3,"); strSql.Append("ExtData1=@ExtData1,"); strSql.Append("ExtData2=@ExtData2"); strSql.Append(" where OperID=@OperID and FareID=@FareID "); SqlParameter[] parameters = { new SqlParameter("@FareTypeName", SqlDbType.VarChar, 50), new SqlParameter("@FarePrice", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice2", SqlDbType.Decimal, 9), new SqlParameter("@FarePrice3", SqlDbType.Decimal, 9), new SqlParameter("@Divid1", SqlDbType.Int, 4), new SqlParameter("@Divid2", SqlDbType.Int, 4), new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9), new SqlParameter("@ExtData1", SqlDbType.VarChar, 50), new SqlParameter("@ExtData2", SqlDbType.VarChar, 50), new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@FareID", SqlDbType.Int, 4) }; parameters[0].Value = model.FareTypeName; parameters[1].Value = model.FarePrice; parameters[2].Value = model.FareMoney; parameters[3].Value = model.FarePrice2; parameters[4].Value = model.FarePrice3; parameters[5].Value = model.Divid1; parameters[6].Value = model.Divid2; parameters[7].Value = model.UseNumber1; parameters[8].Value = model.UseNumber2; parameters[9].Value = model.UseNumber3; parameters[10].Value = model.ExtData1; parameters[11].Value = model.ExtData2; parameters[12].Value = model.OperID; parameters[13].Value = model.FareID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtFareTypeName.Text.Trim().Length == 0) { strErr += "FareTypeName不能为空!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice.Text)) { strErr += "FarePrice格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney.Text)) { strErr += "FareMoney格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice2.Text)) { strErr += "FarePrice2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFarePrice3.Text)) { strErr += "FarePrice3格式错误!\\n"; } if (!PageValidate.IsNumber(txtDivid1.Text)) { strErr += "Divid1格式错误!\\n"; } if (!PageValidate.IsNumber(txtDivid2.Text)) { strErr += "Divid2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber1.Text)) { strErr += "UseNumber1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber2.Text)) { strErr += "UseNumber2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber3.Text)) { strErr += "UseNumber3格式错误!\\n"; } if (this.txtExtData1.Text.Trim().Length == 0) { strErr += "ExtData1不能为空!\\n"; } if (this.txtExtData2.Text.Trim().Length == 0) { strErr += "ExtData2不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperID = int.Parse(this.lblOperID.Text); int FareID = int.Parse(this.lblFareID.Text); string FareTypeName = this.txtFareTypeName.Text; decimal FarePrice = decimal.Parse(this.txtFarePrice.Text); decimal FareMoney = decimal.Parse(this.txtFareMoney.Text); decimal FarePrice2 = decimal.Parse(this.txtFarePrice2.Text); decimal FarePrice3 = decimal.Parse(this.txtFarePrice3.Text); int Divid1 = int.Parse(this.txtDivid1.Text); int Divid2 = int.Parse(this.txtDivid2.Text); decimal UseNumber1 = decimal.Parse(this.txtUseNumber1.Text); decimal UseNumber2 = decimal.Parse(this.txtUseNumber2.Text); decimal UseNumber3 = decimal.Parse(this.txtUseNumber3.Text); string ExtData1 = this.txtExtData1.Text; string ExtData2 = this.txtExtData2.Text; WebDemo.Model.WebDemo.OperationFareDay model = new WebDemo.Model.WebDemo.OperationFareDay(); model.OperID = OperID; model.FareID = FareID; model.FareTypeName = FareTypeName; model.FarePrice = FarePrice; model.FareMoney = FareMoney; model.FarePrice2 = FarePrice2; model.FarePrice3 = FarePrice3; model.Divid1 = Divid1; model.Divid2 = Divid2; model.UseNumber1 = UseNumber1; model.UseNumber2 = UseNumber2; model.UseNumber3 = UseNumber3; model.ExtData1 = ExtData1; model.ExtData2 = ExtData2; WebDemo.BLL.WebDemo.OperationFareDay bll = new WebDemo.BLL.WebDemo.OperationFareDay(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }