/// <summary> /// 更新一条数据 /// </summary> public void UpdateValenceInfo(ValenceInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbValenceInfo set "); strSql.Append("ProductsID=@ProductsID,"); strSql.Append("bDateTime=@bDateTime,"); strSql.Append("eDateTime=@eDateTime,"); strSql.Append("vPrice=@vPrice,"); strSql.Append("vAppendTime=@vAppendTime"); strSql.Append(" where ValenceID=@ValenceID "); SqlParameter[] parameters = { new SqlParameter("@ValenceID", SqlDbType.Int, 4), new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@bDateTime", SqlDbType.DateTime), new SqlParameter("@eDateTime", SqlDbType.DateTime), new SqlParameter("@vPrice", SqlDbType.Money, 8), new SqlParameter("@vAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ValenceID; parameters[1].Value = model.ProductsID; parameters[2].Value = model.bDateTime; parameters[3].Value = model.eDateTime; parameters[4].Value = model.vPrice; parameters[5].Value = model.vAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int AddValenceInfo(ValenceInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbValenceInfo("); strSql.Append("ProductsID,bDateTime,eDateTime,vPrice,vAppendTime)"); strSql.Append(" values ("); strSql.Append("@ProductsID,@bDateTime,@eDateTime,@vPrice,@vAppendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@bDateTime", SqlDbType.DateTime), new SqlParameter("@eDateTime", SqlDbType.DateTime), new SqlParameter("@vPrice", SqlDbType.Money, 8), new SqlParameter("@vAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsID; parameters[1].Value = model.bDateTime; parameters[2].Value = model.eDateTime; parameters[3].Value = model.vPrice; parameters[4].Value = model.vAppendTime; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ValenceInfo GetValenceInfoModel(int ValenceID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ValenceID,ProductsID,bDateTime,eDateTime,vPrice,vAppendTime,(select pName from tbProductsInfo where ProductsID=tbValenceInfo.[ProductsID]) as ProductsName from tbValenceInfo "); strSql.Append(" where ValenceID=@ValenceID "); SqlParameter[] parameters = { new SqlParameter("@ValenceID", SqlDbType.Int, 4) }; parameters[0].Value = ValenceID; ValenceInfo model = new ValenceInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ValenceID"].ToString() != "") { model.ValenceID = int.Parse(ds.Tables[0].Rows[0]["ValenceID"].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]["bDateTime"].ToString() != "") { model.bDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["bDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["eDateTime"].ToString() != "") { model.eDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["eDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["vPrice"].ToString() != "") { model.vPrice = decimal.Parse(ds.Tables[0].Rows[0]["vPrice"].ToString()); } if (ds.Tables[0].Rows[0]["vAppendTime"].ToString() != "") { model.vAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["vAppendTime"].ToString()); } model.ProductsName = ds.Tables[0].Rows[0]["ProductsName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static void UpdateValenceInfo(ValenceInfo model) { DatabaseProvider.GetInstance().UpdateValenceInfo(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int AddValenceInfo(ValenceInfo model) { return(DatabaseProvider.GetInstance().AddValenceInfo(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") { ValenceID = Utils.StrToInt(HTTPRequest.GetString("vid"), 0); vi = tbValenceInfo.GetValenceInfoModel(ValenceID); } if (ispost) { ProductsID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("ProductsID")), 0); vPrice = Utils.StrToFloat(Utils.ChkSQL(HTTPRequest.GetString("vPrice")), 0); bDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("bDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("bDateTime"))) : DateTime.Now; eDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("eDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("eDateTime"))) : DateTime.Now; vi.ProductsID = ProductsID; vi.vPrice = decimal.Parse(vPrice.ToString()); vi.bDateTime = bDateTime; vi.eDateTime = eDateTime; if (ProductsID > 0) { if (Act == "Add") { vi.vAppendTime = vAppendTime; if (tbValenceInfo.AddValenceInfo(vi) > 0) { AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("history.back(1);"); } } if (Act == "Edit") { try { tbValenceInfo.UpdateValenceInfo(vi); 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 { if (Act == "Del") { try { tbValenceInfo.DeleteValenceInfo(HTTPRequest.GetString("vid")); 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())); } }