/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.Otherfare model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Otherfare("); strSql.Append("MeterID,FareID,FareNum,Remark,Flag)"); strSql.Append(" values ("); strSql.Append("@MeterID,@FareID,@FareNum,@Remark,@Flag)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@FareID", SqlDbType.Int, 4), new SqlParameter("@FareNum", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@Flag", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.FareID; parameters[2].Value = model.FareNum; parameters[3].Value = model.Remark; parameters[4].Value = model.Flag; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Otherfare DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.Otherfare model = new WebDemo.Model.WebDemo.Otherfare(); if (row != null) { if (row["OtherID"] != null && row["OtherID"].ToString() != "") { model.OtherID = int.Parse(row["OtherID"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["FareID"] != null && row["FareID"].ToString() != "") { model.FareID = int.Parse(row["FareID"].ToString()); } if (row["FareNum"] != null && row["FareNum"].ToString() != "") { model.FareNum = int.Parse(row["FareNum"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["Flag"] != null && row["Flag"].ToString() != "") { model.Flag = int.Parse(row["Flag"].ToString()); } } return(model); }
private void ShowInfo(int OtherID) { WebDemo.BLL.WebDemo.Otherfare bll = new WebDemo.BLL.WebDemo.Otherfare(); WebDemo.Model.WebDemo.Otherfare model = bll.GetModel(OtherID); this.lblOtherID.Text = model.OtherID.ToString(); this.txtMeterID.Text = model.MeterID.ToString(); this.txtFareID.Text = model.FareID.ToString(); this.txtFareNum.Text = model.FareNum.ToString(); this.txtRemark.Text = model.Remark; this.txtFlag.Text = model.Flag.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "MeterID格式错误!\\n"; } if (!PageValidate.IsNumber(txtFareID.Text)) { strErr += "FareID格式错误!\\n"; } if (!PageValidate.IsNumber(txtFareNum.Text)) { strErr += "FareNum格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (!PageValidate.IsNumber(txtFlag.Text)) { strErr += "Flag格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OtherID = int.Parse(this.lblOtherID.Text); int MeterID = int.Parse(this.txtMeterID.Text); int FareID = int.Parse(this.txtFareID.Text); int FareNum = int.Parse(this.txtFareNum.Text); string Remark = this.txtRemark.Text; int Flag = int.Parse(this.txtFlag.Text); WebDemo.Model.WebDemo.Otherfare model = new WebDemo.Model.WebDemo.Otherfare(); model.OtherID = OtherID; model.MeterID = MeterID; model.FareID = FareID; model.FareNum = FareNum; model.Remark = Remark; model.Flag = Flag; WebDemo.BLL.WebDemo.Otherfare bll = new WebDemo.BLL.WebDemo.Otherfare(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.Otherfare model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Otherfare set "); strSql.Append("MeterID=@MeterID,"); strSql.Append("FareID=@FareID,"); strSql.Append("FareNum=@FareNum,"); strSql.Append("Remark=@Remark,"); strSql.Append("Flag=@Flag"); strSql.Append(" where OtherID=@OtherID"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@FareID", SqlDbType.Int, 4), new SqlParameter("@FareNum", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@OtherID", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.FareID; parameters[2].Value = model.FareNum; parameters[3].Value = model.Remark; parameters[4].Value = model.Flag; parameters[5].Value = model.OtherID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Otherfare GetModel(int OtherID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OtherID,MeterID,FareID,FareNum,Remark,Flag from Otherfare "); strSql.Append(" where OtherID=@OtherID"); SqlParameter[] parameters = { new SqlParameter("@OtherID", SqlDbType.Int, 4) }; parameters[0].Value = OtherID; WebDemo.Model.WebDemo.Otherfare model = new WebDemo.Model.WebDemo.Otherfare(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }