/// <summary> /// 更新一条数据 /// </summary> public bool Update(DNSABC.Model.DNSABC_ProductInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DNSABC_ProductInfo set "); strSql.Append("ProductType=@ProductType,"); strSql.Append("ProductName=@ProductName,"); strSql.Append("ProductPic=@ProductPic,"); strSql.Append("ProductDescription=@ProductDescription,"); strSql.Append("ProductTableName=@ProductTableName,"); strSql.Append("MONTH=@MONTH,"); strSql.Append("State=@State,"); strSql.Append("isOrder=@isOrder,"); strSql.Append("Remark=@Remark,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@ProductType", SqlDbType.Int, 4), new SqlParameter("@ProductName", SqlDbType.VarChar, 100), new SqlParameter("@ProductPic", SqlDbType.VarChar, 4000), new SqlParameter("@ProductDescription", SqlDbType.VarChar, 8000), new SqlParameter("@ProductTableName", SqlDbType.VarChar, 100), new SqlParameter("@MONTH", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@isOrder", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.ProductType; parameters[1].Value = model.ProductName; parameters[2].Value = model.ProductPic; parameters[3].Value = model.ProductDescription; parameters[4].Value = model.ProductTableName; parameters[5].Value = model.MONTH; parameters[6].Value = model.State; parameters[7].Value = model.isOrder; parameters[8].Value = model.Remark; parameters[9].Value = model.UpdateTime; parameters[10].Value = model.CreateTime; parameters[11].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DNSABC.Model.DNSABC_ProductInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DNSABC_ProductInfo("); strSql.Append("ProductType,ProductName,ProductPic,ProductDescription,ProductTableName,MONTH,State,isOrder,Remark,UpdateTime,CreateTime)"); strSql.Append(" values ("); strSql.Append("@ProductType,@ProductName,@ProductPic,@ProductDescription,@ProductTableName,@MONTH,@State,@isOrder,@Remark,@UpdateTime,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductType", SqlDbType.Int, 4), new SqlParameter("@ProductName", SqlDbType.VarChar, 100), new SqlParameter("@ProductPic", SqlDbType.VarChar, 4000), new SqlParameter("@ProductDescription", SqlDbType.VarChar, 8000), new SqlParameter("@ProductTableName", SqlDbType.VarChar, 100), new SqlParameter("@MONTH", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@isOrder", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductType; parameters[1].Value = model.ProductName; parameters[2].Value = model.ProductPic; parameters[3].Value = model.ProductDescription; parameters[4].Value = model.ProductTableName; parameters[5].Value = model.MONTH; parameters[6].Value = model.State; parameters[7].Value = model.isOrder; parameters[8].Value = model.Remark; parameters[9].Value = model.UpdateTime; parameters[10].Value = model.CreateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int Id) { DNSABC.BLL.DNSABC_ProductInfo bll = new DNSABC.BLL.DNSABC_ProductInfo(); DNSABC.Model.DNSABC_ProductInfo model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.txtProductType.Text = model.ProductType.ToString(); this.txtProductName.Text = model.ProductName; this.txtProductPic.Text = model.ProductPic; this.txtProductDescription.Text = model.ProductDescription; this.txtProductTableName.Text = model.ProductTableName; this.txtMONTH.Text = model.MONTH.ToString(); this.txtState.Text = model.State.ToString(); this.txtisOrder.Text = model.isOrder.ToString(); this.txtRemark.Text = model.Remark; this.txtUpdateTime.Text = model.UpdateTime.ToString(); this.txtCreateTime.Text = model.CreateTime.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public DNSABC.Model.DNSABC_ProductInfo GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,ProductType,ProductName,ProductPic,ProductDescription,ProductTableName,MONTH,State,isOrder,Remark,UpdateTime,CreateTime from DNSABC_ProductInfo "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DNSABC.Model.DNSABC_ProductInfo model = new DNSABC.Model.DNSABC_ProductInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["ProductType"] != null && ds.Tables[0].Rows[0]["ProductType"].ToString() != "") { model.ProductType = int.Parse(ds.Tables[0].Rows[0]["ProductType"].ToString()); } if (ds.Tables[0].Rows[0]["ProductName"] != null && ds.Tables[0].Rows[0]["ProductName"].ToString() != "") { model.ProductName = ds.Tables[0].Rows[0]["ProductName"].ToString(); } if (ds.Tables[0].Rows[0]["ProductPic"] != null && ds.Tables[0].Rows[0]["ProductPic"].ToString() != "") { model.ProductPic = ds.Tables[0].Rows[0]["ProductPic"].ToString(); } if (ds.Tables[0].Rows[0]["ProductDescription"] != null && ds.Tables[0].Rows[0]["ProductDescription"].ToString() != "") { model.ProductDescription = ds.Tables[0].Rows[0]["ProductDescription"].ToString(); } if (ds.Tables[0].Rows[0]["ProductTableName"] != null && ds.Tables[0].Rows[0]["ProductTableName"].ToString() != "") { model.ProductTableName = ds.Tables[0].Rows[0]["ProductTableName"].ToString(); } if (ds.Tables[0].Rows[0]["MONTH"] != null && ds.Tables[0].Rows[0]["MONTH"].ToString() != "") { model.MONTH = int.Parse(ds.Tables[0].Rows[0]["MONTH"].ToString()); } if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "") { model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString()); } if (ds.Tables[0].Rows[0]["isOrder"] != null && ds.Tables[0].Rows[0]["isOrder"].ToString() != "") { model.isOrder = int.Parse(ds.Tables[0].Rows[0]["isOrder"].ToString()); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["UpdateTime"] != null && ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } return(model); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtProductType.Text)) { strErr += "产品类型 1格式错误!\\n"; } if (this.txtProductName.Text.Trim().Length == 0) { strErr += "名称不能为空!\\n"; } if (this.txtProductPic.Text.Trim().Length == 0) { strErr += "产品图片不能为空!\\n"; } if (this.txtProductDescription.Text.Trim().Length == 0) { strErr += "产品描述 编辑器区域不能为空!\\n"; } if (this.txtProductTableName.Text.Trim().Length == 0) { strErr += "模型的表格名称 Product不能为空!\\n"; } if (!PageValidate.IsNumber(txtMONTH.Text)) { strErr += "月数 产品默认订购时限格式错误!\\n"; } if (!PageValidate.IsNumber(txtState.Text)) { strErr += "产品状态 0为停用格式错误!\\n"; } if (!PageValidate.IsNumber(txtisOrder.Text)) { strErr += "权重格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "备注不能为空!\\n"; } if (!PageValidate.IsDateTime(txtUpdateTime.Text)) { strErr += "更新时间格式错误!\\n"; } if (!PageValidate.IsDateTime(txtCreateTime.Text)) { strErr += "创建时间格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Id = int.Parse(this.lblId.Text); int ProductType = int.Parse(this.txtProductType.Text); string ProductName = this.txtProductName.Text; string ProductPic = this.txtProductPic.Text; string ProductDescription = this.txtProductDescription.Text; string ProductTableName = this.txtProductTableName.Text; int MONTH = int.Parse(this.txtMONTH.Text); int State = int.Parse(this.txtState.Text); int isOrder = int.Parse(this.txtisOrder.Text); string Remark = this.txtRemark.Text; DateTime UpdateTime = DateTime.Parse(this.txtUpdateTime.Text); DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text); DNSABC.Model.DNSABC_ProductInfo model = new DNSABC.Model.DNSABC_ProductInfo(); model.Id = Id; model.ProductType = ProductType; model.ProductName = ProductName; model.ProductPic = ProductPic; model.ProductDescription = ProductDescription; model.ProductTableName = ProductTableName; model.MONTH = MONTH; model.State = State; model.isOrder = isOrder; model.Remark = Remark; model.UpdateTime = UpdateTime; model.CreateTime = CreateTime; DNSABC.BLL.DNSABC_ProductInfo bll = new DNSABC.BLL.DNSABC_ProductInfo(); bll.Update(model); ROYcms.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }