/// <summary> /// 更新一条数据 /// </summary> public void UpdateGiftsInfo(GiftsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbGiftsInfo set "); strSql.Append("ProductsID=@ProductsID,"); strSql.Append("StoresID=@StoresID,"); strSql.Append("gNum=@gNum,"); strSql.Append("gDateTime=@gDateTime,"); strSql.Append("gAppendTime=@gAppendTime"); strSql.Append(" where GiftsID=@GiftsID "); SqlParameter[] parameters = { new SqlParameter("@GiftsID", SqlDbType.Int, 4), new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@StoresID", SqlDbType.Int, 4), new SqlParameter("@gNum", SqlDbType.Int, 4), new SqlParameter("@gDateTime", SqlDbType.DateTime), new SqlParameter("@gAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.GiftsID; parameters[1].Value = model.ProductsID; parameters[2].Value = model.StoresID; parameters[3].Value = model.gNum; parameters[4].Value = model.gDateTime; parameters[5].Value = model.gAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int AddGiftsInfo(GiftsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbGiftsInfo("); strSql.Append("ProductsID,StoresID,gNum,gDateTime,gAppendTime)"); strSql.Append(" values ("); strSql.Append("@ProductsID,@StoresID,@gNum,@gDateTime,@gAppendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@StoresID", SqlDbType.Int, 4), new SqlParameter("@gNum", SqlDbType.Int, 4), new SqlParameter("@gDateTime", SqlDbType.DateTime), new SqlParameter("@gAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsID; parameters[1].Value = model.StoresID; parameters[2].Value = model.gNum; parameters[3].Value = model.gDateTime; parameters[4].Value = model.gAppendTime; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GiftsInfo GetGiftsInfoModel(int GiftsID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 GiftsID,ProductsID,StoresID,gNum,gDateTime,gAppendTime,(select sName from tbStoresInfo where StoresID=tbGiftsInfo.StoresID) as StoresName,(select pName from tbProductsInfo where ProductsID=tbGiftsInfo.ProductsID) as ProductsName from tbGiftsInfo "); strSql.Append(" where GiftsID=@GiftsID "); SqlParameter[] parameters = { new SqlParameter("@GiftsID", SqlDbType.Int, 4) }; parameters[0].Value = GiftsID; GiftsInfo model = new GiftsInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["GiftsID"].ToString() != "") { model.GiftsID = int.Parse(ds.Tables[0].Rows[0]["GiftsID"].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]["StoresID"].ToString() != "") { model.StoresID = int.Parse(ds.Tables[0].Rows[0]["StoresID"].ToString()); } if (ds.Tables[0].Rows[0]["gNum"].ToString() != "") { model.gNum = int.Parse(ds.Tables[0].Rows[0]["gNum"].ToString()); } if (ds.Tables[0].Rows[0]["gDateTime"].ToString() != "") { model.gDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["gDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["gAppendTime"].ToString() != "") { model.gAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["gAppendTime"].ToString()); } model.StoresName = ds.Tables[0].Rows[0]["StoresName"].ToString(); model.ProductsName = ds.Tables[0].Rows[0]["ProductsName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static void UpdateGiftsInfo(GiftsInfo model) { DatabaseProvider.GetInstance().UpdateGiftsInfo(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int AddGiftsInfo(GiftsInfo model) { return(DatabaseProvider.GetInstance().AddGiftsInfo(model)); }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("7")) { Act = HTTPRequest.GetString("Act"); if (Act == "Edit") { GiftsID = Utils.StrToInt(HTTPRequest.GetString("gid"), 0); gi = tbGiftsInfo.GetGiftsInfoModel(GiftsID); } if (ispost) { StoresID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("StoresID")), 0); ProductsID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("ProductsID")), 0); gNum = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("gNum")), 0); gDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("gDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("gDateTime"))) : DateTime.Now; gi.StoresID = StoresID; gi.ProductsID = ProductsID; gi.gNum = gNum; gi.gDateTime = gDateTime; if (StoresID > 0) { if (ProductsID > 0) { if (Act == "Add") { gi.gAppendTime = gAppendTime; if (tbGiftsInfo.AddGiftsInfo(gi) > 0) { AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("history.back(1);"); } } if (Act == "Edit") { try { tbGiftsInfo.UpdateGiftsInfo(gi); AddMsgLine("修改成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("修改失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } else { AddErrLine("产品不能为空!"); AddScript("history.back(1);"); } } else { AddErrLine("门店不能为空!"); AddScript("history.back(1);"); } } else { if (Act == "Del") { try { tbGiftsInfo.DeleteGiftsInfo(HTTPRequest.GetString("gid")); 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.parent.HidBox();"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }