/// <summary> /// 更新一条数据 /// </summary> public string CheckToUpdate(Maticsoft.Model.Product model, List <Model.ProductPriceColorShip> delList, List <Model.ProductPriceColorShip> insert, List <Model.ProductPriceColorShip> updateList, string picFile, string id) { if (dal.GetDS(id).Tables[0].Rows[0]["Name"].ToString() != model.Name) { if (dal.exists(" where Name='" + model.Name + "'")) { return("名称已存在,更新失败!"); } else { if (dal.Update(model, delList, insert, updateList, picFile, id) > 0) { return("success"); } else { return("更新失败!"); } } } else { if (dal.Update(model, delList, insert, updateList, picFile, id) > 0) { return("success"); } else { return("更新失败!"); } } }
/// <summary> /// 获得数据列表 /// </summary> public List <Maticsoft.Model.Product> DataTableToList(DataTable dt) { List <Maticsoft.Model.Product> modelList = new List <Maticsoft.Model.Product>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Maticsoft.Model.Product model; for (int n = 0; n < rowsCount; n++) { model = new Maticsoft.Model.Product(); if (dt.Rows[n]["ProID"].ToString() != "") { model.ProID = int.Parse(dt.Rows[n]["ProID"].ToString()); } model.ProName = dt.Rows[n]["ProName"].ToString(); if (dt.Rows[n]["ProTypeID"].ToString() != "") { model.ProTypeID = int.Parse(dt.Rows[n]["ProTypeID"].ToString()); } model.ImageURL = dt.Rows[n]["ImageURL"].ToString(); if (dt.Rows[n]["ProXingID"].ToString() != "") { model.ProXingID = int.Parse(dt.Rows[n]["ProXingID"].ToString()); } if (dt.Rows[n]["Prochutime"].ToString() != "") { model.Prochutime = DateTime.Parse(dt.Rows[n]["Prochutime"].ToString()); } if (dt.Rows[n]["Fatime"].ToString() != "") { model.Fatime = DateTime.Parse(dt.Rows[n]["Fatime"].ToString()); } if (dt.Rows[n]["Toujian"].ToString() != "") { model.Toujian = int.Parse(dt.Rows[n]["Toujian"].ToString()); } if (dt.Rows[n]["HitNum"].ToString() != "") { model.HitNum = int.Parse(dt.Rows[n]["HitNum"].ToString()); } model.Procontent = dt.Rows[n]["Procontent"].ToString(); model.ProMonery = dt.Rows[n]["ProMonery"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod public long CheckToAdd(Maticsoft.Model.Product model, List <Model.ProductPriceColorShip> insertList, string picFile) { if (dal.exists(" where Name='" + model.Name + "'")) { return(-2); } long returnID = dal.Add(model, insertList, picFile); if (returnID > 0) { return(returnID); } else { return(-3); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Maticsoft.Model.Product model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Maticsoft.Model.Product model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Product model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Product model) { return(dal.Add(model)); }