public EdmGroupMgr(string connectionString)
{
_edmGroup = new EdmGroupDao(connectionString);
_ISerialImpl = new SerialDao(connectionString);
_IEdmGroupEmailMgr = new EdmGroupEmailDao(connectionString);
_mysql = new MySqlDao(connectionString);
}
public IpoNvdMgr(string connectionString)
{
_IpoNvdDao = new IpoNvdDao(connectionString);
myDao = new MySqlDao(connectionString);
_iinvdDao = new IinvdDao(connectionString);
istockchangeDao = new IstockChangeDao(connectionString);
}
public ProductSpecMgr(string connectionStr)
{
_specDao = new BLL.gigade.Dao.ProductSpecDao(connectionStr);
this.connectionStr = connectionStr;
_proMgr = new BLL.gigade.Mgr.ProductMgr(connectionStr);
_sqlDao = new Dao.MySqlDao(connectionStr);
}
public EdmContentNewMgr(string connectionString)
{
_edmContentNewDao = new EdmContentNewDao(connectionString);
_mySql = new MySqlDao(connectionString);
_emailGroup = new EmailGroupDao(connectionString);
_edmListConditionMgr = new EdmListConditionMainMgr(connectionString);
}
public OrderReturnMasterMgr(string connectionStr)
{
_orderReturnMaster = new OrderReturnMasterDao(connectionStr);
_serial = new SerialDao(connectionStr);
_mySqlDao = new MySqlDao(connectionStr);
_orderDetailDao = new OrderDetailDao(connectionStr);
}
public ProductCategorySetMgr(string conStr)
{
_categorySetDao = new ProductCategorySetDao(conStr);
_proMgr = new ProductMgr(conStr);
_sqlDao = new MySqlDao(conStr);
}
public bool Delete(int schedule, string ids, string item_type, string item_value)
{
try
{
ArrayList arrayList = new ArrayList();
//獲得供應商對應旗下的商品id集合
IProductImplDao _productDao = new ProductDao(conStr);
IScheduleRelationImplDao _scheduleDao = new ScheduleRelationDao(conStr);
List<Product> listProduct = _productDao.GetProductByVendor(Convert.ToInt32(item_value));
string id = "";
foreach (var item in listProduct) //連接id
{
id += item.Product_Id + ",";
}
id = id.Remove(id.Length - 1, 1);
arrayList.Add(_scheduleDao.Delete(item_type, id, schedule));
arrayList.Add(_scheduleItemDao.Delete(schedule, ids));
MySqlDao sqlDao = new MySqlDao(conStr);
return sqlDao.ExcuteSqls(arrayList);
}
catch (Exception ex)
{
throw new Exception("ScheduleItemMgr-->Delete" + ex.Message, ex); ;
}
}
public OrderSlaveMasterMgr(string connectionStr)
{
_orderSlaveMasterDao = new OrderSlaveMasterDao(connectionStr);
_serialDao = new SerialDao(connectionStr);
_mysqlDao = new MySqlDao(connectionStr);
_paraDao = new ParametersrcDao(connectionStr);
}
public PromotionBannerMgr(string connectionStr)
{
_promotionBannerDao = new PromotionBannerDao(connectionStr);
_promotionBannerRelationDao = new PromotionBannerRelationDao(connectionStr);
_mysqlDao = new MySqlDao(connectionStr);
_vendorBrandDao = new VendorBrandDao(connectionStr);
_accessMySql = DBFactory.getDBAccess(DBType.MySql, connectionStr);
}
public ProductItemMapMgr(string connectionString)
{
this.connectionString = connectionString;
_channelDao = new BLL.gigade.Dao.ChannelDao(connectionString);
_ProductItemMapDao = new Dao.ProductItemMapDao(connectionString);
_mySqlDao = new MySqlDao(connectionString);
_mapSetDao = new ProductMapSetDao(connectionString);
_channelorderDao = new ChannelOrderDao(connectionString);
_pricemasterDao = new PriceMasterDao(connectionString);
}
public ProductMgr(string connectionStr)
{
_productDao = new ProductDao(connectionStr);
_productPicDao = new ProductPictureDao(connectionStr);
pmDao = new PriceMasterDao(connectionStr);
pmTSDao = new PriceMasterTsDao(connectionStr);
puApplyDao = new PriceUpdateApplyDao(connectionStr);
this.connectionStr = connectionStr;
_mysqlDao = new MySqlDao(connectionStr);
productDao = new ProductDao(connectionStr);
_rProductAttribute = new RecommendedProductAttributeDao(connectionStr);
}
public OrderReturnStatusDao(string connectionstring)
{
_access = DBFactory.getDBAccess(DBType.MySql, connectionstring);
_ordermasterdao = new OrderMasterDao(connectionstring);
_orderDetailDao = new OrderDetailDao(connectionstring);
_orderMoneyReturnDao = new OrderMoneyReturnDao(connectionstring);
_vipuserGroupDao = new VipUserGroupDao(connectionstring);
_itemDao = new ProductItemDao(connectionstring);
_userRecommendDao = new UserRecommendDao(connectionstring);
_mySqlDao = new MySqlDao(connectionstring);
this.connStr = connectionstring;
}
/// <summary>
/// 有參構造函數
/// </summary>
/// <param name="connectionstring">數據庫連接字符串</param>
public PromotionsAmountDiscountDao(string connectionstring)
{
_access = DBFactory.getDBAccess(DBType.MySql, connectionstring);
this.connStr = connectionstring;
_prodpromoDao = new ProdPromoDao(connectionstring);
_proCateDao = new ProductCategoryDao(connectionstring);
_prodCategSet = new ProductCategorySetDao(connectionstring);
_proAllDao = new PromoAllDao(connectionstring);
_usconDao = new UserConditionDao(connectionstring);
_promoDisDao = new PromoDiscountDao(connectionstring);
_mySql = new MySqlDao(connectionstring);
}
public OrderMasterMgr(string connectionStr)
{
_orderMasterDao = new OrderMasterDao(connectionStr);
//orderMasterDao = new OrderMasterDao(connectionStr);
bonusMasterDao = new BonusMasterDao(connectionStr);
_bonusMasterMgr = new BonusMasterMgr(connectionStr);
_happyGoMgr = new HappyGoMgr(connectionStr);
_serialDao = new SerialDao(connectionStr);
_mysqlDao = new MySqlDao(connectionStr);
_orsDao = new OrderReturnStatusDao(connectionStr);
_parametersrcDao = new ParametersrcDao(connectionStr);
conn = connectionStr;
}
public OrderDetailMgr(string connectionStr)
{
_orderDetailDao = new OrderDetailDao(connectionStr);
_orderSlaveDao = new OrderSlaveDao(connectionStr);
_orderMaterDao = new OrderMasterDao(connectionStr);
_orderMaterStatusDao = new OrderMasterStatusDao(connectionStr);
_serial = new SerialDao(connectionStr);
_mySqlDao = new MySqlDao(connectionStr);
_productCategoryDao = new ProductCategoryDao(connectionStr);
_parametersrcDao = new ParametersrcDao(connectionStr);
//_siteDao = new SiteDao(connectionStr);
_channelDao = new ChannelDao(connectionStr);
}
public PromotionsAmountDiscountMgr(string connectionstring)
{
_mysqlDao = new MySqlDao(connectionstring);
_padDao = new PromotionsAmountDiscountDao(connectionstring);
_prodpromoDao = new ProdPromoDao(connectionstring);
_proCateDao = new ProductCategoryDao(connectionstring);
_prodCategSet = new ProductCategorySetDao(connectionstring);
_proAllDao = new PromoAllDao(connectionstring);
_usconDao = new UserConditionDao(connectionstring);
_promoDisDao = new PromoDiscountDao(connectionstring);
_promoMainDao = new PromotionsMaintainDao(connectionstring);
_prodDao = new ProductDao(connectionstring);
_vendorBrandDao = new VendorBrandDao(connectionstring);
connStr = connectionstring;
}
public bool UpdateCostMoney(List<Model.ProductItemTemp> productItemTemp)
{
try
{
ArrayList sqls = new ArrayList();
foreach (var item in productItemTemp)
{
sqls.Add(_productItemTempDao.UpdateCostMoney(item));
}
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(sqls);
}
catch (Exception ex)
{
throw new Exception("ProductItemTempMgr.UpdateCostMoney-->" + ex.Message, ex);
}
}
public bool insertPic(List<Model.Query.TrialPictureQuery> PicList)
{
ArrayList arrList = new ArrayList();
try
{
foreach (var item in PicList)
{
arrList.Add(_ITrialPictureDao.SavePic(item));
}
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(arrList);
}
catch (Exception ex)
{
throw new Exception("TrialPictureMgr.insertPic-->" + ex.Message, ex);
}
}
public bool Save(List<PriceUpdateApplyHistory> pHList)
{
try
{
ArrayList aList = new ArrayList();
foreach (var item in pHList)
{
aList.Add(_pHDao.Save(item));
}
MySqlDao mySqlDao = new MySqlDao(connectionString);
return mySqlDao.ExcuteSqls(aList);
}
catch (Exception ex)
{
throw new Exception("PriceUpdateApplyHistoryMgr-->SingleCompareSave-->" + ex.Message, ex);
}
}
public EdmTestMgr(string connectionString)
{
try
{
_mysqlDao = new MySqlDao(connectionString);
_etestDao = new EdmTestDao(connectionString);
_edmemailDao = new EdmEmailDao(connectionString);
id = 0;
largestid = 0;
name = string.Empty;
}
catch (Exception ex)
{
throw new Exception("EdmTestMgr-->EdmTestMgr-->", ex);
}
}
public bool SaveUserList(Model.Query.UsersListQuery usr, List<Model.UserLife> userLife)
{
try
{
ArrayList sqlList = new ArrayList();
sqlList.Add(_UserIplDao.SaveUserList(usr));
UserLifeDao _UserLifeDao = new UserLifeDao(conn);
sqlList.Add(_UserLifeDao.DeleteUserLife(usr.user_id));//刪除原有數據
foreach (Model.UserLife model in userLife)
{
sqlList.Add(_UserLifeDao.SaveUserLife(model));
}
List<Model.UserLife> old_user_life = _UserLifeDao.GetUserLife(usr.user_id);
var alist = old_user_life.Find(m => m.info_type == "cancel_info_time");
if (alist == null)
{
if (!usr.send_sms_ad)
{
sqlList.Add(_UserLifeDao.UpdateCancelTime(usr.user_id, (uint)Common.CommonFunction.GetPHPTime(), usr.update_user));
}
}
else
{
if (usr.send_sms_ad)
{
sqlList.Add(_UserLifeDao.UpdateCancelTime(usr.user_id, 0, usr.update_user));
}
}
MySqlDao _MySqlDao = new MySqlDao(conn);
return _MySqlDao.ExcuteSqls(sqlList);
}
catch (MySqlException ex)
{
throw new Exception(ex.Number.ToString() + ":UsersListMgr-->SaveUserList-->" + ex.Message, ex);
}
catch (Exception ex)
{
throw new Exception("UsersListMgr-->SaveUserList-->" + ex.Message, ex);
}
}
public bool Save(List<ProductPicture> PicList,int type=1)
{
try
{
ArrayList arrList = new ArrayList();
//先刪除商品說明圖記錄
arrList.Add(_productPicDao.Delete(PicList[0].product_id, type));
foreach (var item in PicList)
{
arrList.Add(_productPicDao.Save(item, type));
}
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(arrList);
}
catch (Exception ex)
{
throw new Exception("ProductPictureMgr-->SingleCompareSave-->" + ex.Message, ex);
}
}
public bool Update(List<Model.PriceMasterTemp> priceMasterTempList, List<ItemPrice> itemPrices)
{
ArrayList sqls = new ArrayList();
if (priceMasterTempList != null)
{
foreach (var item in priceMasterTempList)
{
sqls.Add(_priceMasterTempDao.Update(item));
}
}
if (itemPrices != null)
{
ItemPriceTempMgr itemPriceTempMgr = new ItemPriceTempMgr("");
foreach (var item in itemPrices)
{
sqls.Add(itemPriceTempMgr.Update(item));
}
}
MySqlDao mySqlDao = new MySqlDao(connctionString);
return mySqlDao.ExcuteSqls(sqls);
}
public bool UpdateActive(EventPromoAdditionalPrice model)
{
ArrayList _list = new ArrayList();
try
{
_list.Add(dao.UpdateActive(model));
//處理輔表活動商品設定
if (model.condition_type == 1)
{
EventPromoBrandDao _epbDao = new EventPromoBrandDao(conn);
_list.Add(_epbDao.UpdateActive(new EventPromoBrand { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 2)
{
EventPromoCategoryDao _epcateDao = new EventPromoCategoryDao(conn);
_list.Add(_epcateDao.UpdateActive(new EventPromoCategory { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 3)
{
EventPromoClassDao _epclassDao = new EventPromoClassDao(conn);
_list.Add(_epclassDao.UpdateActive(new EventPromoClass { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 4)
{
EventPromoProductDao _epproDao = new EventPromoProductDao(conn);
_list.Add(_epproDao.UpdateActive(new EventPromoProduct { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 5)
{
EventPromoShoppingcartDao _epcartDao = new EventPromoShoppingcartDao(conn);
_list.Add(_epcartDao.UpdateActive(new EventPromoShoppingcart { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 6)
{
EventPromoPaymentDao _eppayDao = new EventPromoPaymentDao(conn);
_list.Add(_eppayDao.UpdateActive(new EventPromoPayment { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
MySqlDao _mySqlDao = new MySqlDao(conn);
return _mySqlDao.ExcuteSqls(_list);
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceMgr-->UpdateActive" + ex.Message, ex);
}
}
public VoteMessageMgr(string connectionStr)
{
_voteMsgDao = new VoteMessageDao(connectionStr);
_mysqlDao = new MySqlDao(connectionStr);
}
public bool execInsertSql(ArrayList arrayList)
{
try
{
MySqlDao myDao = new MySqlDao(connStr);
return myDao.ExcuteSqls(arrayList);
}
catch (Exception ex)
{
throw new Exception(" EmsDao-->execInsertSql--> " + arrayList + ex.Message, ex);
}
}
/// <summary>
/// 批量對數據進行更改和添加操作
/// </summary>
public bool UpdateByBacth(List<ScheduleItem> lists)
{
ArrayList listStr = new ArrayList();
try
{
foreach(ScheduleItem s in lists)
{
switch(s.id)
{
case 0:
listStr.Add(Save(s));
break;
default:
listStr.Add(Update(s));
break;
}
}
MySqlDao mysql = new MySqlDao(conStr);
return mysql.ExcuteSqls(listStr);
}
catch (Exception ex)
{
throw new Exception("ScheduleItemMgr-->UpdateByBacth" + ex.Message,ex);
}
}
public bool UpdateByVendor(ArrayList exculsql)
{
try
{
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(exculsql);
}
catch (Exception ex)
{
throw new Exception("ItemPriceTempMgr.UpdateByVendor-->" + ex.Message, ex);
}
}
public PromoShareConditionMgr(string connectionStr)
{
_pscDao = new PromoShareConditionDao(connectionStr);
_mysqlDao = new MySqlDao(connectionStr);
}
public ParametersrcDao(string connectionString)
{
_accessMySql = DBFactory.getDBAccess(DBType.MySql, connectionString);
this.connStr = connectionString;
_mayDao = new MySqlDao(connectionString);
}