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