protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
id = Request.QueryString["id"] == null ? "" : Request.QueryString["id"].Trim();
if (id != "")
{
model = new DAL.v_ProductColorShip().GetModel(long.Parse(id));
}
//code.Text = model.Code;
//name.Text = model.Name;
}
catch
{
}
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "ProductItem";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
///
/// </summary>
/// <param name="insertList"></param>
/// <param name="updateList"></param>
/// <param name="delList"></param>
/// <param name="sequenceList"></param>
/// <param name="UserID">用户ID</param>
/// <param name="id">ProductID</param>
/// <returns></returns>
public bool Edit(List <Model.ProductPriceColorShip> insertList, List <Model.ProductPriceColorShip> updateList, List <Model.v_ProductColorShip> delList, List <Model.ProductPriceColorShip> sequenceList, long UserID, long id)
{
ArrayList arr = new ArrayList();
StringBuilder sbSql = new StringBuilder();
for (int i = 0; i < delList.Count; i++)
{
sbSql = new StringBuilder();
Model.v_ProductColorShip model = delList[i];
sbSql.Append("delete from ProductItem where ID=" + model.ID);
arr.Add(sbSql.ToString());
}
for (int i = 0; i < updateList.Count; i++)
{
sbSql = new StringBuilder();
Model.ProductPriceColorShip model = updateList[i];
sbSql.Append("update ProductItem set ProductID='" + id + "',Corlor='" + model.Corlor + "',Code='" + model.Code + "',Size='" + model.Size + "',Quality='" + model.Quality + "'");
sbSql.Append(",Brand='" + model.Brand + "',NFK='" + model.NFK + "',Attribute='" + model.Attribute + "',BarginPriceOut='" + model.BarginPriceOut + "',ReferencePriceOut='" + model.ReferencePriceOut + "'");
sbSql.Append(",StandardPriceIn='" + model.StandardPriceIn + "',MinPriceOut='" + model.MinPriceOut + "',Profit='" + model.Profit + "',TagPrice='" + model.TagPrice + "',MaxStock='" + model.MaxStock + "'");
sbSql.Append(",MinStock='" + model.MinStock + "',ReferencePriceA='" + model.ReferencePriceA + "',ReferencePriceB='" + model.ReferencePriceB + "',ReferencePriceC='" + model.ReferencePriceC + "',ReferencePriceD='" + model.ReferencePriceD + "'");
sbSql.Append(",ReferencePriceE='" + model.ReferencePriceE + "',ReferencePriceF='" + model.ReferencePriceF + "',value0='" + model.value0 + "',value1='" + model.value1 + "'");
sbSql.Append(" where ID=" + model.ID);
arr.Add(sbSql.ToString());
}
for (int i = 0; i < insertList.Count; i++)
{
sbSql = new StringBuilder();
Model.ProductPriceColorShip model = insertList[i];
//sbSql.Append("insert into ProductColor (ParentID,Code,Name,Enabled,Status,Remark,Value0,Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,CreateUser,CreateDate,UpdateUser,UpdateDate) ");
sbSql.Append("insert into ProductItem (ProductID,ColorID,Corlor,Size,MaxStock,MinStock,Brand,ReferencePriceOut,StandardPriceIn,ReferencePriceA,ReferencePriceB,ReferencePriceC,ReferencePriceD,ReferencePriceE,ReferencePriceF) ");
sbSql.Append(" values ( ");
sbSql.Append("'" + id + "',0,'" + model.Corlor + "','" + model.Size + "','" + model.MaxStock + "','" + model.MinStock + "','" + model.Brand + "','" + model.ReferencePriceOut + "','" + model.StandardPriceIn + "','" + model.ReferencePriceA + "','" + model.ReferencePriceB + "','" + model.ReferencePriceC + "','" + model.ReferencePriceD + "','" + model.ReferencePriceE + "','" + model.ReferencePriceF + "'");
sbSql.Append(" ) ");
arr.Add(sbSql.ToString());
}
DbHelperSQL.ExecuteSqlTran(arr);
return(true);
}
