protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtFareID.Text)) { strErr += "FareID格式错误!\\n"; } if (!PageValidate.IsNumber(txtCycNumber.Text)) { strErr += "CycNumber格式错误!\\n"; } if (this.txtFareName.Text.Trim().Length == 0) { strErr += "FareName不能为空!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney.Text)) { strErr += "单价格式错误!\\n"; } if (this.txtFareMemo.Text.Trim().Length == 0) { strErr += "备注不能为空!\\n"; } if (!PageValidate.IsNumber(txtFareMark.Text)) { strErr += "是否启用 1启用 2不启用格式错误!\\n"; } if (this.txtPriceUnit.Text.Trim().Length == 0) { strErr += "单位不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int FareID = int.Parse(this.txtFareID.Text); int CycNumber = int.Parse(this.txtCycNumber.Text); string FareName = this.txtFareName.Text; decimal FareMoney = decimal.Parse(this.txtFareMoney.Text); string FareMemo = this.txtFareMemo.Text; int FareMark = int.Parse(this.txtFareMark.Text); string PriceUnit = this.txtPriceUnit.Text; WebDemo.Model.WebDemo.FareItem model = new WebDemo.Model.WebDemo.FareItem(); model.FareID = FareID; model.CycNumber = CycNumber; model.FareName = FareName; model.FareMoney = FareMoney; model.FareMemo = FareMemo; model.FareMark = FareMark; model.PriceUnit = PriceUnit; WebDemo.BLL.WebDemo.FareItem bll = new WebDemo.BLL.WebDemo.FareItem(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(int FareID) { WebDemo.BLL.WebDemo.FareItem bll = new WebDemo.BLL.WebDemo.FareItem(); WebDemo.Model.WebDemo.FareItem model = bll.GetModel(FareID); this.lblFareID.Text = model.FareID.ToString(); this.lblCycNumber.Text = model.CycNumber.ToString(); this.lblFareName.Text = model.FareName; this.lblFareMoney.Text = model.FareMoney.ToString(); this.lblFareMemo.Text = model.FareMemo; this.lblFareMark.Text = model.FareMark.ToString(); this.lblPriceUnit.Text = model.PriceUnit; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.FareItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FareItem set "); strSql.Append("CycNumber=@CycNumber,"); strSql.Append("FareName=@FareName,"); strSql.Append("FareMoney=@FareMoney,"); strSql.Append("FareMemo=@FareMemo,"); strSql.Append("FareMark=@FareMark,"); strSql.Append("PriceUnit=@PriceUnit"); strSql.Append(" where FareID=@FareID "); SqlParameter[] parameters = { new SqlParameter("@CycNumber", SqlDbType.Int, 4), new SqlParameter("@FareName", SqlDbType.VarChar, 100), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@FareMemo", SqlDbType.VarChar, 200), new SqlParameter("@FareMark", SqlDbType.Int, 4), new SqlParameter("@PriceUnit", SqlDbType.VarChar, 20), new SqlParameter("@FareID", SqlDbType.Int, 4) }; parameters[0].Value = model.CycNumber; parameters[1].Value = model.FareName; parameters[2].Value = model.FareMoney; parameters[3].Value = model.FareMemo; parameters[4].Value = model.FareMark; parameters[5].Value = model.PriceUnit; parameters[6].Value = model.FareID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.FareItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FareItem("); strSql.Append("FareID,CycNumber,FareName,FareMoney,FareMemo,FareMark,PriceUnit)"); strSql.Append(" values ("); strSql.Append("@FareID,@CycNumber,@FareName,@FareMoney,@FareMemo,@FareMark,@PriceUnit)"); SqlParameter[] parameters = { new SqlParameter("@FareID", SqlDbType.Int, 4), new SqlParameter("@CycNumber", SqlDbType.Int, 4), new SqlParameter("@FareName", SqlDbType.VarChar, 100), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@FareMemo", SqlDbType.VarChar, 200), new SqlParameter("@FareMark", SqlDbType.Int, 4), new SqlParameter("@PriceUnit", SqlDbType.VarChar, 20) }; parameters[0].Value = model.FareID; parameters[1].Value = model.CycNumber; parameters[2].Value = model.FareName; parameters[3].Value = model.FareMoney; parameters[4].Value = model.FareMemo; parameters[5].Value = model.FareMark; parameters[6].Value = model.PriceUnit; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.FareItem DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.FareItem model = new WebDemo.Model.WebDemo.FareItem(); if (row != null) { if (row["FareID"] != null && row["FareID"].ToString() != "") { model.FareID = int.Parse(row["FareID"].ToString()); } if (row["CycNumber"] != null && row["CycNumber"].ToString() != "") { model.CycNumber = int.Parse(row["CycNumber"].ToString()); } if (row["FareName"] != null) { model.FareName = row["FareName"].ToString(); } if (row["FareMoney"] != null && row["FareMoney"].ToString() != "") { model.FareMoney = decimal.Parse(row["FareMoney"].ToString()); } if (row["FareMemo"] != null) { model.FareMemo = row["FareMemo"].ToString(); } if (row["FareMark"] != null && row["FareMark"].ToString() != "") { model.FareMark = int.Parse(row["FareMark"].ToString()); } if (row["PriceUnit"] != null) { model.PriceUnit = row["PriceUnit"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.FareItem GetModel(int FareID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FareID,CycNumber,FareName,FareMoney,FareMemo,FareMark,PriceUnit from FareItem "); strSql.Append(" where FareID=@FareID "); SqlParameter[] parameters = { new SqlParameter("@FareID", SqlDbType.Int, 4) }; parameters[0].Value = FareID; WebDemo.Model.WebDemo.FareItem model = new WebDemo.Model.WebDemo.FareItem(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }