/// <summary>
/// 获取省
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <returns></returns>
public IList <CityInfo> GetProvinceList(cPos.Model.LoggingSessionInfo loggingSessionInfo)
{
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <CityInfo>("City.SelectProvince", ""));
}
/// <summary>
/// 获取未打包的商品类别数量
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <returns></returns>
public int GetItemCategoryNotPackagedCount(LoggingSessionInfo loggingSessionInfo)
{
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForObject <int>("ItemCategory.SelectUnDownloadCount", ""));
}
/// <summary>
/// Mobile CCOrder保存
/// </summary>
/// <param name="orders">models</param>
/// <param name="IsTrans">是否批处理</param>
/// <returns>Hashtable:
/// status(成功：true, 失败：false)
/// error(错误描述)
/// </returns>
public Hashtable SaveMobileCCOrderList(bool IsTrans, IList <CCInfo> orders, string userId)
{
Hashtable ht = new Hashtable();
ht["status"] = false;
try
{
string error = string.Empty;
SkuService skuService = new SkuService();
ItemService itemService = new ItemService();
InoutService inoutService = new InoutService();
StockBalanceOrderService stockService = new StockBalanceOrderService();
UnitService unitService = new UnitService();
cPos.Model.LoggingSessionInfo loggingSessionInfo = new cPos.Model.LoggingSessionInfo();
loggingSessionInfo.CurrentUser = new cPos.Model.User.UserInfo();
loggingSessionInfo.CurrentUser.User_Id = userId;
if (IsTrans)
{
MSSqlMapper.Instance().BeginTransaction();
}
// 处理SKU
bool exsitBarcode = false;
cPos.Model.SkuInfo skuInfo = null;
foreach (var order in orders)
{
order.order_type_id = "5F11A199E3CD42DE9CAE70442FC3D991"; // AJ
var unitInfo = unitService.GetUnitById(loggingSessionInfo, order.unit_id);
order.customer_id = unitInfo.customer_id;
if (order.CCDetailInfoList == null)
{
continue;
}
foreach (var orderDetail in order.CCDetailInfoList)
{
exsitBarcode = skuService.CheckBarcode(orderDetail.barcode, null);
if (!exsitBarcode)
{
cPos.Model.ItemInfo itemInfo = new cPos.Model.ItemInfo();
itemInfo.SkuList = new List <cPos.Model.SkuInfo>();
cPos.Model.SkuInfo newSkuInfo = new cPos.Model.SkuInfo();
newSkuInfo.sku_id = orderDetail.sku_id;
newSkuInfo.barcode = orderDetail.barcode;
newSkuInfo.status = "1";
newSkuInfo.create_user_id = orderDetail.create_user_id;
newSkuInfo.create_time = orderDetail.create_time;
newSkuInfo.modify_user_id = orderDetail.modify_user_id;
newSkuInfo.modify_time = orderDetail.modify_time;
newSkuInfo.prop_1_detail_id = orderDetail.sku_prop_1_name;
newSkuInfo.prop_2_detail_id = orderDetail.sku_prop_2_name;
newSkuInfo.prop_3_detail_id = orderDetail.sku_prop_3_name;
newSkuInfo.prop_4_detail_id = orderDetail.sku_prop_4_name;
newSkuInfo.prop_5_detail_id = orderDetail.sku_prop_5_name;
// 商品
var itemListObj = itemService.GetItemByCode(orderDetail.item_code);
cPos.Model.ItemInfo itemObj = new cPos.Model.ItemInfo();
if (itemListObj != null && itemListObj.Count > 0)
{
itemObj = itemListObj[0];
newSkuInfo.item_id = itemObj.Item_Id;
if (itemObj.SkuList == null)
{
itemObj.SkuList = new List <cPos.Model.SkuInfo>();
}
itemObj.SkuList.Add(newSkuInfo);
skuService.SetSkuInfo(itemObj, out error);
}
else
{
itemObj = new cPos.Model.ItemInfo();
itemObj.Item_Category_Id = "10e1e76ced9b45e1ac722d3e8b193419";
itemObj.Item_Id = NewGUID();
itemObj.Item_Code = orderDetail.item_code;
itemObj.Item_Name = orderDetail.item_name;
itemObj.ifgifts = 0;
itemObj.ifoften = 0;
itemObj.ifservice = 0;
itemObj.isGB = 1;
itemObj.data_from = "1";
// 价格
var skuPriceService = new SkuPriceService();
var skuUnitPriceInfo = new cPos.Model.SkuUnitPriceInfo();
skuUnitPriceInfo.SkuUnitPriceInfoList = new List <cPos.Model.SkuUnitPriceInfo>();
if (orderDetail.enter_price != null &&
orderDetail.enter_price.Trim().Length > 0)
{
cPos.Model.SkuUnitPriceInfo unitPriceInfo = new cPos.Model.SkuUnitPriceInfo();
unitPriceInfo.item_price_type_id = "12EDF2F0C5BE4FB2B4FE3ECE870FF723";
unitPriceInfo.price = Decimal.Parse(orderDetail.enter_price.Trim());
unitPriceInfo.sku_unit_price_id = NewGuid();
unitPriceInfo.sku_id = orderDetail.sku_id;
unitPriceInfo.unit_id = order.unit_id;
unitPriceInfo.status = "1";
unitPriceInfo.start_date = "1900-01-01";
unitPriceInfo.end_date = "9999-12-31";
unitPriceInfo.create_user_id = userId;
unitPriceInfo.create_time = GetNow();
skuUnitPriceInfo.SkuUnitPriceInfoList.Add(unitPriceInfo);
}
if (orderDetail.sales_price != null &&
orderDetail.sales_price.Trim().Length > 0)
{
cPos.Model.SkuUnitPriceInfo unitPriceInfo = new cPos.Model.SkuUnitPriceInfo();
unitPriceInfo.item_price_type_id = "75412168A16C4D2296B92CA0E596A188";
unitPriceInfo.price = Decimal.Parse(orderDetail.sales_price.Trim());
unitPriceInfo.sku_unit_price_id = NewGuid();
unitPriceInfo.sku_id = orderDetail.sku_id;
unitPriceInfo.unit_id = order.unit_id;
unitPriceInfo.status = "1";
unitPriceInfo.start_date = "1900-01-01";
unitPriceInfo.end_date = "9999-12-31";
unitPriceInfo.create_user_id = userId;
unitPriceInfo.create_time = GetNow();
skuUnitPriceInfo.SkuUnitPriceInfoList.Add(unitPriceInfo);
}
skuPriceService.InsertOrUpdateSkuUnitPrice(false, skuUnitPriceInfo);
itemObj.SkuList = new List <cPos.Model.SkuInfo>();
newSkuInfo.item_id = itemObj.Item_Id;
itemObj.SkuList.Add(newSkuInfo);
itemService.SetItemInfo(false, loggingSessionInfo, itemObj, out error);
orderDetail.sku_id = newSkuInfo.sku_id;
}
}
else
{
skuInfo = skuService.GetSkuByBarcode(orderDetail.barcode);
orderDetail.sku_id = skuInfo.sku_id;
}
}
}
// 处理Order
foreach (var order in orders)
{
if (!CheckIsEndMobileCCOrder(order))
{
MSSqlMapper.Instance().Insert("CC.InsertAndUpdateMobileCCOrder", order);
}
// 获取仓库
var warehouseObj = (new UnitService()).GetDefaultWarehouse(order.unit_id);
string warehouseId = warehouseObj == null ? "" : warehouseObj.warehouse_id;
Hashtable htStockId = new Hashtable();
string tmpStockId;
// 保存库存
foreach (var orderDetail in order.CCDetailInfoList)
{
cPos.Model.StockBalanceInfo stockInfo = new cPos.Model.StockBalanceInfo();
htStockId["unit_id"] = order.unit_id;
htStockId["warehouse_id"] = warehouseId;
htStockId["sku_id"] = orderDetail.sku_id;
tmpStockId = stockService.GetStockBalanceIdBySkuId(htStockId);
if (tmpStockId == null || tmpStockId.Trim().Length == 0)
{
tmpStockId = NewGUID();
}
stockInfo.stock_balance_id = tmpStockId;
stockInfo.unit_id = order.unit_id;
stockInfo.warehouse_id = warehouseId;
stockInfo.sku_id = orderDetail.sku_id;
stockInfo.begin_qty = orderDetail.end_qty;
stockInfo.end_qty = orderDetail.end_qty;
stockInfo.price = orderDetail.enter_price == null ? 0 : Convert.ToDecimal(orderDetail.enter_price);
stockInfo.item_label_type_id = "522B623A30C243F2853AA34CD01B510B";
stockInfo.status = "1";
stockInfo.create_time = GetNow();
stockInfo.create_user_id = order.create_user_id;
stockService.SaveStockBalance(stockInfo);
}
}
if (IsTrans)
{
MSSqlMapper.Instance().CommitTransaction();
}
ht["status"] = true;
}
catch (Exception ex)
{
if (IsTrans)
{
MSSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
return(ht);
}
/// <summary>
/// 获取城市信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <returns></returns>
public IList <CityInfo> GetCityInfoList(cPos.Model.LoggingSessionInfo loggingSessionInfo)
{
Hashtable _ht = new Hashtable();
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <CityInfo>("City.Select", _ht));
}
/// <summary>
/// 检查Mobile CCOrderDetail是否已存在
/// </summary>
public bool CheckExistMobileCCOrderDetail(CCDetailInfo model)
{
int count = MSSqlMapper.Instance().QueryForObject <int>("CC.CheckExistMobileCCOrderDetail", model);
return(count > 0 ? true : false);
}
/// <summary>
/// 检查CCOrder是否已存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckExistCCOrder(CCInfo model)
{
int count = MSSqlMapper.Instance().QueryForObject <int>("CCOrder.CheckExistCCOrder", model);
return(count > 0 ? true : false);
}
public IList <MenuInfo> GetFirstLevelMenuListByAppID(string appID)
{
return(MSSqlMapper.Instance().QueryForList <MenuInfo>("Right.Menu.GetFirstLevelMenuListByAppID", appID));
}
public IList <MenuInfo> GetSubMenuListByMenuID(string menuID)
{
return(MSSqlMapper.Instance().QueryForList <MenuInfo>("Right.Menu.GetSubMenuListByMenuID", menuID));
}
/// <summary>
/// 根据ID获取行业版本对应的菜单信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MenuInfo GetVocationVersionMenuMappingByID(Guid id)
{
return(MSSqlMapper.Instance().QueryForObject <MenuInfo>("Right.Menu.GetVocationVersionMenuMappingByID", id));
}
public IList <MenuInfo> GetAllMenuListByAppCode(string appID)
{
return(MSSqlMapper.Instance().QueryForList <MenuInfo>("Right.Menu.GetAllMenuListByAppCode", appID));
}
//public IList<AppInfo> GetCustomerVisibleAppList()
//{
// return MSSqlMapper.Instance().QueryForList<AppInfo>("Right.App.GetCustomerVisibleAppList", null);
//}
#endregion
#region 菜单
public IList <MenuInfo> GetAllMenuListByCustomer(string customerID)
{
return(MSSqlMapper.Instance().QueryForList <MenuInfo>("Right.Menu.GetAllMenuListByCustomer", customerID));
}
public IList <VersionInfo> GetAllVersionList()
{
return(MSSqlMapper.Instance().QueryForList <VersionInfo>("Right.App.GetAllVersionList", null));
}
/// <summary>
/// 同步行业版本菜单
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="status">修改值</param>
/// <returns></returns>
public string SyncCustomerVersionMenu(cPos.Model.LoggingSessionInfo loggingSessionInfo, string vocaVerMappingID, string appID)
{
string strResult = string.Empty;
var sync_customermenu_startdate = System.Configuration.ConfigurationManager.AppSettings["sync_customermenu_startdate"];
try
{
//
var tmpLoggingSessionInfo = loggingSessionInfo;
//tmpLoggingSessionInfo.CurrentLoggingManager.Connection_String
var service = new CustomerService();
var customerList = service.SelectCustomerByVersionID(vocaVerMappingID);
var versionMenus = GetMenuListByAppIDAndVersion(appID, vocaVerMappingID).OrderBy(obj => obj.DisplayIndex).ToArray();
foreach (var customerinfo in customerList)
{
if (!string.IsNullOrEmpty(sync_customermenu_startdate) && Convert.ToDateTime(sync_customermenu_startdate) > customerinfo.CreateTime)
{
continue;
}
//if (customerinfo.ID != "eb17cc2569c74ab7888b1f403972d37d")//测试
//{
// continue;
//}
var tmpSession = this.GetLoggingSessionInfoByCustomerId(customerinfo.ID);
if (tmpSession == null)
{
strResult += "商户：" + customerinfo.ID + "数据源无效；\n";
continue;
}
var ht_select = new Hashtable();
ht_select.Add("CustomerID", customerinfo.ID);
ht_select.Add("AppID", appID);
var tran = MSSqlMapper.Instance(tmpSession.CurrentLoggingManager); //访问商户库
var customer_menulist = tran.QueryForList <MenuInfo>("Right.Menu.GetMenuListByAppIDAndCustomerID", ht_select); //
try
{
tran.BeginTransaction();
foreach (var menuitem in versionMenus)
{
var tempmenu = customer_menulist.Where(t => t.ApplicationID == menuitem.ApplicationID && t.Code == menuitem.Code && t.CustomerID == customerinfo.ID && t.Status == 1).ToArray();
//test
//var test = customer_menulist.Where(t => t.ID == "7d021667cb7544c2b059c1c86c47cb65e9f21f7e022d4c72baf64c668b709f0e" && t.CustomerID == "e9f21f7e022d4c72baf64c668b709f0e").ToArray();
//if (test.Length >0)
//{
// //continue;
//}
var _menu_id = menuitem.ID + customerinfo.ID;
var _parent_menu_id = menuitem.ParentMenuID != "--" ? menuitem.ParentMenuID + customerinfo.ID : menuitem.ParentMenuID;
Hashtable ht_menu = new Hashtable();
ht_menu.Add("menu_id", _menu_id);
ht_menu.Add("reg_app_id", menuitem.ApplicationID);
ht_menu.Add("menu_code", menuitem.Code);
ht_menu.Add("parent_menu_id", _parent_menu_id);
ht_menu.Add("menu_level", menuitem.Level);
ht_menu.Add("url_path", menuitem.URLPath);
ht_menu.Add("icon_path", menuitem.IconPath);
ht_menu.Add("display_index", menuitem.DisplayIndex);
ht_menu.Add("menu_name", menuitem.Name);
ht_menu.Add("user_flag", menuitem.CustomerVisible);
ht_menu.Add("menu_eng_name", menuitem.EnglishName);
ht_menu.Add("IsCanAccess", menuitem.IsCanAccess);//菜单是否可操作
ht_menu.Add("status", menuitem.Status);
ht_menu.Add("create_user_id", loggingSessionInfo.CurrentLoggingManager.User_Id);
ht_menu.Add("create_time", GetDateTime(DateTime.Now));
ht_menu.Add("modify_user_id", loggingSessionInfo.CurrentLoggingManager.User_Id);
ht_menu.Add("modify_time", GetDateTime(DateTime.Now));
ht_menu.Add("customer_id", customerinfo.ID);
//插入
if (tempmenu.Length == 0)
{
var tempmenuinfo = customer_menulist.Where(t => t.ID == menuitem.ID + customerinfo.ID).ToArray().FirstOrDefault();
//根据菜单ID更新数据
if (tempmenuinfo != null)
{
if (menuitem.Code != tempmenuinfo.Code || _parent_menu_id != tempmenuinfo.ParentMenuID || menuitem.ApplicationID != tempmenuinfo.ApplicationID ||
menuitem.Name != tempmenuinfo.Name || menuitem.URLPath != tempmenuinfo.URLPath || menuitem.Status != tempmenuinfo.Status || menuitem.IsCanAccess != tempmenuinfo.IsCanAccess)
{
tran.Update("Right.Menu.UpdateCustomerMenuByMenuID", ht_menu);
}
}
else
{
tran.Insert("Right.Menu.InsertCustomerMenu", ht_menu);
}
}
else
{
//更新
if (tempmenu.Length > 1)
{
MSSqlMapper.Instance(new cPos.Model.LoggingManager());
return(customerinfo.Name + "(" + customerinfo.ID + ")，找到" + tempmenu.Length + "条编码为(" + menuitem.Code + ")的菜单记录，请联系管理员修正后再进行同步。\n");
}
//相同数据不用更新
var tempmenuinfo = tempmenu.ToArray().FirstOrDefault();
if (menuitem.Code != tempmenuinfo.Code || _parent_menu_id != tempmenuinfo.ParentMenuID || menuitem.ApplicationID != tempmenuinfo.ApplicationID ||
menuitem.Name != tempmenuinfo.Name || menuitem.URLPath != tempmenuinfo.URLPath || menuitem.Status != tempmenuinfo.Status || menuitem.IsCanAccess != tempmenuinfo.IsCanAccess)
{
tran.Update("Right.Menu.UpdateCustomerMenu", ht_menu);
}
}
//禁用其他菜单
}
tran.CommitTransaction();
}
catch (Exception ex)
{
tran.RollBackTransaction();
MSSqlMapper.Instance(new cPos.Model.LoggingManager());
throw ex;
}
MSSqlMapper.Instance(new cPos.Model.LoggingManager());
}
//MSSqlMapper.Instance(new cPos.Model.LoggingManager());//重新初始化为 AP 库
strResult += "菜单更新成功.";
}
catch (Exception ex)
{
MSSqlMapper.Instance(new cPos.Model.LoggingManager());
return(ex.InnerException.Message);
throw (ex);
}
return(strResult);
}
public MenuInfo GetMenuByID(string menuID)
{
return(MSSqlMapper.Instance().QueryForObject <MenuInfo>("Right.Menu.GetMenuByID", menuID));
}
public IList <AppInfo> GetCustomerVisibleAppList()
{
return(MSSqlMapper.Instance().QueryForList <AppInfo>("Right.App.GetCustomerVisibleAppList", null));
}
