public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtUserID.Text.Trim().Length == 0) { strErr += "UserID不能为空!\\n"; } if (this.txtCommodityID.Text.Trim().Length == 0) { strErr += "CommodityID不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string AppriseID = this.lblAppriseID.Text; string UserID = this.txtUserID.Text; string CommodityID = this.txtCommodityID.Text; Maticsoft.Model.Appraise model = new Maticsoft.Model.Appraise(); model.AppriseID = AppriseID; model.UserID = UserID; model.CommodityID = CommodityID; Maticsoft.BLL.Appraise bll = new Maticsoft.BLL.Appraise(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(string AppriseID) { Maticsoft.BLL.Appraise bll = new Maticsoft.BLL.Appraise(); Maticsoft.Model.Appraise model = bll.GetModel(AppriseID); this.lblAppriseID.Text = model.AppriseID; this.txtUserID.Text = model.UserID; this.txtCommodityID.Text = model.CommodityID; }
protected void RadLV_splb_ItemDataBound(object sender, Telerik.Web.UI.RadListViewItemEventArgs e) { string id = e.Item.OwnerListView.DataKeyValues[e.Item.OwnerListView.DataKeyValues.Count - 1]["AppriseID"].ToString(); LinkButton LinkButton1 = e.Item.FindControl("LinkButton1") as LinkButton; if (LinkButton1 != null) { Appraise_Mol = Appraise_Bll.GetModel(id); Commodity_Mol = Commodity_Bll.GetModel(Appraise_Mol.CommodityID); if (Commodity_Mol.Stock == 0 || Commodity_Mol.CommodityState == "下架") { LinkButton1.Visible = false; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Appraise DataRowToModel(DataRow row) { Maticsoft.Model.Appraise model = new Maticsoft.Model.Appraise(); if (row != null) { if (row["AppriseID"] != null) { model.AppriseID = row["AppriseID"].ToString(); } if (row["UserID"] != null) { model.UserID = row["UserID"].ToString(); } if (row["CommodityID"] != null) { model.CommodityID = row["CommodityID"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Appraise GetModel(string AppriseID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" AppriseID,UserID,CommodityID "); strSql.Append(" from Appraise "); strSql.Append(" where AppriseID='" + AppriseID + "' "); Maticsoft.Model.Appraise model = new Maticsoft.Model.Appraise(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Appraise model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.AppriseID != null) { strSql1.Append("AppriseID,"); strSql2.Append("'" + model.AppriseID + "',"); } if (model.UserID != null) { strSql1.Append("UserID,"); strSql2.Append("'" + model.UserID + "',"); } if (model.CommodityID != null) { strSql1.Append("CommodityID,"); strSql2.Append("'" + model.CommodityID + "',"); } strSql.Append("insert into Appraise("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Appraise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Appraise set "); if (model.UserID != null) { strSql.Append("UserID='" + model.UserID + "',"); } else { strSql.Append("UserID= null ,"); } if (model.CommodityID != null) { strSql.Append("CommodityID='" + model.CommodityID + "',"); } else { strSql.Append("CommodityID= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where AppriseID='" + model.AppriseID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }