/// <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()));
}
}
