/// <summary> /// 更新一条数据 /// </summary> public void UpdateProductPool(ProductPoolInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbProductPoolInfo set "); strSql.Append("ProductsID=@ProductsID,"); strSql.Append("pDateTime=@pDateTime,"); strSql.Append("pType=@pType,"); strSql.Append("pAppendTime=@pAppendTime"); strSql.Append(" where ProductPoolID=@ProductPoolID "); SqlParameter[] parameters = { new SqlParameter("@ProductPoolID", SqlDbType.Int, 4), new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@pDateTime", SqlDbType.DateTime), new SqlParameter("@pType", SqlDbType.Int, 4), new SqlParameter("@pAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductPoolID; parameters[1].Value = model.ProductsID; parameters[2].Value = model.pDateTime; parameters[3].Value = model.pType; parameters[4].Value = model.pAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int AddProductPool(ProductPoolInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbProductPoolInfo("); strSql.Append("ProductsID,pDateTime,pType,pAppendTime)"); strSql.Append(" values ("); strSql.Append("@ProductsID,@pDateTime,@pType,@pAppendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@pDateTime", SqlDbType.DateTime), new SqlParameter("@pType", SqlDbType.Int, 4), new SqlParameter("@pAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsID; parameters[1].Value = model.pDateTime; parameters[2].Value = model.pType; parameters[3].Value = model.pAppendTime; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ProductPoolInfo GetProductPoolModel(int ProductPoolID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ProductPoolID,ProductsID,pDateTime,pType,pAppendTime,(select pName from tbProductsInfo where tbProductsInfo.ProductsID=tbProductPoolInfo.ProductsID) as ProductsName from tbProductPoolInfo "); strSql.Append(" where ProductPoolID=@ProductPoolID "); SqlParameter[] parameters = { new SqlParameter("@ProductPoolID", SqlDbType.Int, 4) }; parameters[0].Value = ProductPoolID; ProductPoolInfo model = new ProductPoolInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ProductsName = ds.Tables[0].Rows[0]["ProductsName"].ToString(); if (ds.Tables[0].Rows[0]["ProductPoolID"].ToString() != "") { model.ProductPoolID = int.Parse(ds.Tables[0].Rows[0]["ProductPoolID"].ToString()); } if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "") { model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString()); } if (ds.Tables[0].Rows[0]["pDateTime"].ToString() != "") { model.pDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["pDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["pType"].ToString() != "") { model.pType = int.Parse(ds.Tables[0].Rows[0]["pType"].ToString()); } if (ds.Tables[0].Rows[0]["pAppendTime"].ToString() != "") { model.pAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["pAppendTime"].ToString()); } return(model); } else { return(null); } }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("5-3")) { Act = HTTPRequest.GetString("Act"); if (Act == "Edit") { ProductPoolID = Utils.StrToInt(HTTPRequest.GetString("pid"), 0); pi = tbProductPoolInfo.GetProductPoolModel(ProductPoolID); } if (ispost) { ProductsID = Utils.StrToInt(HTTPRequest.GetString("ProductsID"), 0); pType = Utils.StrToInt(HTTPRequest.GetString("pType"), 0); pDateTime = Utils.IsDateString(HTTPRequest.GetString("pDateTime")) ? DateTime.Parse(HTTPRequest.GetString("pDateTime")) : DateTime.Now; if (ProductsID > 0) { pi.ProductsID = ProductsID; pi.pDateTime = pDateTime; pi.pType = pType; if (Act == "Add") { pi.pAppendTime = DateTime.Now; if (tbProductPoolInfo.AddProductPool(pi) > 0) { AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("history.back(1);"); } } if (Act == "Edit") { try { tbProductPoolInfo.UpdateProductPool(pi); AddMsgLine("修改成功!"); AddScript("window.setTimeout('window.parent.HidBox();',2000);"); } catch (Exception ex) { AddErrLine("修改失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',2000);"); } } } else { AddErrLine("参数错误!<br/>"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { if (Act == "Add") { } if (Act == "Del") { try { tbProductPoolInfo.DeleteProductPool(HTTPRequest.GetString("pid")); AddMsgLine("删除成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("创建失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } } else { AddErrLine("权限不足!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }
/// <summary> /// 更新一条数据 /// </summary> public static void UpdateProductPool(ProductPoolInfo model) { DatabaseProvider.GetInstance().UpdateProductPool(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int AddProductPool(ProductPoolInfo model) { return(DatabaseProvider.GetInstance().AddProductPool(model)); }