/// <summary>
/// 保存调整单（新建修改）
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="IsTrans">是否批处理</param>
/// <param name="inoutInfo">进入库模板</param>
/// <param name="strError">输出错误信息</param>
/// <returns></returns>
public bool SetAJInfo(LoggingSessionInfo loggingSessionInfo, bool IsTrans, InoutInfo inoutInfo, out string strError)
{
if (IsTrans)
{
MSSqlMapper.Instance().BeginTransaction();
}
try
{
InoutService inoutService = new InoutService();
if (inoutInfo.order_type_id == null || inoutInfo.order_type_id.Equals(""))
{
inoutInfo.order_type_id = "5F11A199E3CD42DE9CAE70442FC3D991";
}
if (inoutInfo.BillKindCode == null || inoutInfo.BillKindCode.Equals(""))
{
inoutInfo.BillKindCode = "AJ";
}
if (inoutInfo.data_from_id == null || inoutInfo.data_from_id.Equals(""))
{
inoutInfo.data_from_id = "B8DF5D46D3CA430ABE21E20F8D71E212";
}
if (inoutInfo.operate == null || inoutInfo.operate.Equals(""))
{
inoutInfo.operate = "Create";
}
if (inoutInfo.sales_unit_id == null || inoutInfo.sales_unit_id.Equals(""))
{
if (inoutInfo.unit_id != null && (!inoutInfo.unit_id.Equals("")))
{
inoutInfo.sales_unit_id = inoutInfo.unit_id;
}
}
if (inoutService.SetInoutInfo(loggingSessionInfo, inoutInfo, false, out strError))
{
if (IsTrans)
{
MSSqlMapper.Instance().CommitTransaction();
}
return(true);
}
else
{
if (IsTrans)
{
MSSqlMapper.Instance().RollBackTransaction();
}
return(false);
}
}
catch (Exception ex) {
if (IsTrans)
{
MSSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
}
/// <summary>
/// 获取商品的属性集合
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemId"></param>
/// <returns></returns>
public IList <ItemPropInfo> GetItemPropListByItemId(LoggingSessionInfo loggingSessionInfo, string itemId)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemId", itemId);
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <ItemPropInfo>("ItemProp.SelectByItemId", _ht));
}
/// <summary>
/// 根据商品获取Sku
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemId"></param>
/// <returns></returns>
public IList <SkuInfo> GetSkuListByItemId(LoggingSessionInfo loggingSessionInfo, string itemId)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemId", itemId);
return(MSSqlMapper.Instance().QueryForList <SkuInfo>("Sku.SelectByItemId", _ht));
}
/// <summary>
/// AdOrder查询总数量
/// </summary>
public int GetAdOrderCountPackaged(string customer_id, string unit_id, Hashtable ht)
{
ht["customer_id"] = customer_id;
ht["unit_id"] = unit_id;
//ht["if_flag"] = "0";
return(MSSqlMapper.Instance().QueryForObject <int>("AdOrder.GetAdOrderCountPackaged", ht));
}
/// <summary>
/// 批量修改上传标志
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="if_flag">上传标志</param>
/// <param name="InoutInfoList">单据集合</param>
/// <param name="IsTrans">是否提交</param>
/// <returns></returns>
public bool SetInoutIfFlag(LoggingSessionInfo loggingSessionInfo, string if_flag, IList <InoutInfo> InoutInfoList, bool IsTrans)
{
if (IsTrans)
{
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).BeginTransaction();
}
try
{
bool bReturn = false;
InoutInfo inoutInfo = new InoutInfo();
inoutInfo.if_flag = if_flag;
inoutInfo.InoutInfoList = InoutInfoList;
inoutInfo.modify_time = GetCurrentDateTime();
inoutInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("Inout.UpdateIfflag", inoutInfo);
if (IsTrans)
{
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).CommitTransaction();
}
return(bReturn);
}
catch (Exception ex)
{
if (IsTrans)
{
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).RollBackTransaction();
}
throw (ex);
}
}
/// <summary>
/// Monitor Log 查询
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="order_no">订单号</param>
/// <param name="unit_code">门店</param>
/// <param name="item_name">商品</param>
/// <param name="order_date_begin">开始日期</param>
/// <param name="order_date_end">结束日期</param>
/// <param name="maxRowCount">每页数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public MonitorLogInfo SearchMonitorLogList(cPos.Model.LoggingSessionInfo loggingSessionInfo
, string customer_code
, string unit_code
, string date_begin
, string date_end
, int maxRowCount
, int startRowIndex
)
{
Hashtable ht = new Hashtable();
ht["customer_code"] = customer_code;
ht["unit_code"] = unit_code;
ht["date_begin"] = date_begin;
ht["date_end"] = date_end;
ht["StartRow"] = startRowIndex;
ht["EndRow"] = startRowIndex + maxRowCount;
MonitorLogInfo obj = new MonitorLogInfo();
IList <MonitorLogInfo> list = new List <MonitorLogInfo>();
list = MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <MonitorLogInfo>(
"Monitor.SearchMonitorLogList", ht);
if (list != null && list.Count > 0)
{
obj.icount = list[0].icount;
}
obj.List = list;
return(obj);
}
/// <summary>
/// 下载调价单
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="unit_id">组织标识</param>
/// <param name="no">序号</param>
/// <param name="item_price_type_id">价格类型</param>
/// <param name="maxRowCount">当前页数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public IList <AdjustmentOrderInfo> GetAdjustmentOrderListPackaged(LoggingSessionInfo loggingSessionInfo
, string unit_id
, int no
, string item_price_type_id
, int maxRowCount
, int startRowIndex
)
{
IList <AdjustmentOrderInfo> adjustmentOrderList = new List <AdjustmentOrderInfo>();
Hashtable _ht = new Hashtable();
_ht.Add("UnitId", unit_id);
_ht.Add("No", no);
_ht.Add("ItemPriceTypeId", item_price_type_id);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
adjustmentOrderList = MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <AdjustmentOrderInfo>("AdjustmentOrder.SelectUnDownload", _ht);
if (adjustmentOrderList != null)
{
foreach (AdjustmentOrderInfo adjustmentOrderInfo in adjustmentOrderList)
{
adjustmentOrderInfo.AdjustmentOrderDetailSkuList = new AdjustmentOrderDetailSkuService().GetAdjustmentOrderDetailSkuListByOrderIdUnDownload(loggingSessionInfo, adjustmentOrderInfo.order_id);
}
}
return(adjustmentOrderList);
}
/// <summary>
/// 根据用户获取该用户的所有门店
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public IList <UnitInfo> GetUnitListByUserId(LoggingSessionInfo loggingSessionInfo, string userId)
{
Hashtable _ht = new Hashtable();
_ht.Add("UserId", userId);
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <UnitInfo>("Unit.SelectByUserId", _ht));
}
/// <summary>
/// 获取门店的默认仓库
/// </summary>
/// <param name="unitId"></param>
/// <returns></returns>
public cPos.Admin.Model.Customer.WarehouseInfo GetDefaultWarehouse(string unitId)
{
Hashtable ht = new Hashtable();
ht.Add("UnitId", unitId);
return(MSSqlMapper.Instance().QueryForObject <cPos.Admin.Model.Customer.WarehouseInfo>("Warehouse.GetDefaultWarehouse", ht));
}
public int ModifyUserPassword(string userID, string oldPwd, string newPwd)
{
UserInfo user = MSSqlMapper.Instance().QueryForObject <UserInfo>("User.User.SelectUserByID", userID);
if (user == null)
{
return(1);
}
if (user.Status == -1)
{
return(2);
}
if (user.Password != oldPwd)
{
return(3);
}
Hashtable ht = new Hashtable();
ht.Add("UserID", userID);
ht.Add("UserPwd", newPwd);
int ret = MSSqlMapper.Instance().Update("User.User.UpdateUserPwd", ht);
if (ret == 1)
{
return(4);
}
else
{
return(5);
}
}
/// <summary>
/// 单位查询
/// </summary>
/// <param name="loggingSessionInfo">登录Model</param>
/// <param name="unit_code">组织号码</param>
/// <param name="unit_name">组织名称</param>
/// <param name="unit_type_id">组织类型</param>
/// <param name="unit_tel">电话</param>
/// <param name="unit_city_id">城市标识</param>
/// <param name="unit_status">状态</param>
/// <param name="maxRowCount">每页数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public UnitInfo SearchUnitInfo(LoggingSessionInfo loggingSessionInfo
, string unit_code
, string unit_name
, string unit_type_id
, string unit_tel
, string unit_city_id
, string unit_status
, int maxRowCount
, int startRowIndex
)
{
Hashtable _ht = new Hashtable();
_ht.Add("unit_code", unit_code);
_ht.Add("unit_name", unit_name);
_ht.Add("unit_type_id", unit_type_id);
_ht.Add("unit_tel", unit_tel);
_ht.Add("unit_city_id", unit_city_id);
_ht.Add("unit_status", unit_status);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("CustomerId", loggingSessionInfo.CurrentLoggingManager.Customer_Id);
UnitInfo unitInfo = new UnitInfo();
int iCount = MSSqlMapper.Instance().QueryForObject <int>("Unit.SearchUnitInfoCount", _ht);
IList <UnitInfo> unitInfoList = new List <UnitInfo>();
unitInfoList = MSSqlMapper.Instance().QueryForList <UnitInfo>("Unit.SearchUnitInfo", _ht);
unitInfo.ICount = iCount;
unitInfo.UnitInfoList = unitInfoList;
return(unitInfo);
//return MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList<UnitInfo>("Unit.SearchUnitInfo", _ht);
}
/// <summary>
/// 获取未打包的商品零售价格数量
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <returns></returns>
public int GetItemPriceNotPackagedCount(LoggingSessionInfo loggingSessionInfo)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemPriceTypeId", "75412168A16C4D2296B92CA0E596A188");
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForObject <int>("ItemPrice.SelectUnDownloadCount", _ht));
}
/// <summary>
/// 根据市获取地区
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="city_code">市号码</param>
/// <returns></returns>
public IList <CityInfo> GetAreaListByCity(cPos.Model.LoggingSessionInfo loggingSessionInfo, string city_code)
{
Hashtable _ht = new Hashtable();
_ht.Add("CityCode", city_code);
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <CityInfo>("City.SelectArea", _ht));
}
/// <summary>
/// 获取单个城市信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="city_id"></param>
/// <returns></returns>
public CityInfo GetCityById(cPos.Model.LoggingSessionInfo loggingSessionInfo, string city_id)
{
Hashtable _ht = new Hashtable();
_ht.Add("CityId", city_id);
return((CityInfo)MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForObject("City.SelectById", _ht));
}
/// <summary>
/// 设置Sku
/// </summary>
/// <param name="itemInfo">item info</param>
/// <param name="strError">输出错误信息</param>
/// <returns></returns>
public bool SetSkuInfo(ItemInfo itemInfo, out string strError)
{
try
{
if (itemInfo.SkuList != null)
{
foreach (SkuInfo skuInfo in itemInfo.SkuList)
{
if (skuInfo.sku_id == null || skuInfo.sku_id.Equals(""))
{
skuInfo.sku_id = NewGuid();
}
if (!IsExistBarcode(skuInfo.barcode, skuInfo.sku_id))
{
strError = "Barcode号码已经存在。";
return(false);
}
}
MSSqlMapper.Instance().Update("Sku.InsertOrUpdate", itemInfo);
}
else
{
MSSqlMapper.Instance().Update("Sku.InsertOrUpdate", itemInfo);
}
strError = "处理sku信息成功";
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 根据商品价格类型标识获取商品价格类型信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="item_price_type_id"></param>
/// <returns></returns>
public ItemPriceTypeInfo GetItemPriceTypeById(LoggingSessionInfo loggingSessionInfo, string item_price_type_id)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemPriceTypeId", item_price_type_id);
return((ItemPriceTypeInfo)MSSqlMapper.Instance().QueryForObject("ItemPriceType.SelectById", _ht));
}
/// <summary>
/// Monitor Log 保存
/// </summary>
/// <param name="logs">MonitorLogInfo model</param>
/// <param name="IsTrans">是否批处理</param>
/// <returns>Hashtable:
/// status(成功：true, 失败：false)
/// error(错误描述)
/// </returns>
public Hashtable SaveMonitorLogList(bool IsTrans, IList <MonitorLogInfo> logs)
{
Hashtable ht = new Hashtable();
ht["status"] = false;
try
{
if (IsTrans)
{
MSSqlMapper.Instance().BeginTransaction();
}
foreach (var log in logs)
{
if (!CheckExistMonitorLog(log))
{
MSSqlMapper.Instance().Insert("Monitor.InsertMonitorLog", log);
}
}
if (IsTrans)
{
MSSqlMapper.Instance().CommitTransaction();
}
ht["status"] = true;
}
catch (Exception ex)
{
if (IsTrans)
{
MSSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
return(ht);
}
/// <summary>
/// 返回用户信息
/// </summary>
/// <param name="user_id">用户标识</param>
/// <returns>返回用户信息</returns>
public UserInfo GetUserInfoById(string user_id)
{
UserInfo userInfo = new UserInfo();
userInfo = MSSqlMapper.Instance().QueryForObject <UserInfo>("User.MobileUser.SelectUserByID", user_id);
return(userInfo);
}
/// <summary>
/// 提交调价单主表信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="adjustmentOrderInfo"></param>
/// <returns></returns>
private bool SetAdjustmentOrderTableInfo(LoggingSessionInfo loggingSessionInfo, AdjustmentOrderInfo adjustmentOrderInfo)
{
try
{
if (adjustmentOrderInfo != null)
{
if (adjustmentOrderInfo.create_user_id == null || adjustmentOrderInfo.create_user_id.Equals(""))
{
adjustmentOrderInfo.create_user_id = loggingSessionInfo.CurrentUser.User_Id;
adjustmentOrderInfo.create_time = GetCurrentDateTime();
}
if (adjustmentOrderInfo.modify_user_id == null || adjustmentOrderInfo.modify_user_id.Equals(""))
{
adjustmentOrderInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
adjustmentOrderInfo.modify_time = GetCurrentDateTime();
}
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("AdjustmentOrder.InsertOrUpdate", adjustmentOrderInfo);
}
return(true);
}
catch (Exception ex)
{
return(false);
throw (ex);
}
}
/// <summary>
/// 获取未打包的Sku零售价格数量
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="ItemPriceTypeId">价格类型</param>
/// <returns></returns>
public int GetSkuPriceNotPackagedCount(LoggingSessionInfo loggingSessionInfo, string ItemPriceTypeId)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemPriceTypeId", ItemPriceTypeId);
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForObject <int>("SkuPrice.SelectUnDownloadCount", _ht));
}
/// <summary>
/// 修改调价单状态
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="order_id">标识</param>
/// <param name="billActionType">类型</param>
/// <returns></returns>
public bool SetAdjustmentOrderStatus(LoggingSessionInfo loggingSessionInfo, string order_id, BillActionType billActionType)
{
string strResult = string.Empty;
try
{
cPos.Admin.Service.BillService bs = new BillService();
BillOperateStateService state = bs.ApproveBill(loggingSessionInfo, order_id, "", billActionType);
if (state == BillOperateStateService.ApproveSuccessful)
{
//获取要改变的表单信息
BillModel billInfo = new BillService().GetBillById(loggingSessionInfo, order_id);
//设置要改变的用户信息
AdjustmentOrderInfo itenAdjustmentOrderInfo = new AdjustmentOrderInfo();
itenAdjustmentOrderInfo.status = billInfo.Status;
itenAdjustmentOrderInfo.status_desc = billInfo.BillStatusDescription;
itenAdjustmentOrderInfo.order_id = order_id;
itenAdjustmentOrderInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
itenAdjustmentOrderInfo.modify_time = GetCurrentDateTime(); //获取当前时间
//提交
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("AdjustmentOrder.UpdateStatus", itenAdjustmentOrderInfo);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 根据sku标识获取sku明细
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="skuId"></param>
/// <returns></returns>
public SkuInfo GetSkuInfoById(LoggingSessionInfo loggingSessionInfo, string skuId)
{
Hashtable _ht = new Hashtable();
_ht.Add("SkuId", skuId);
return((SkuInfo)MSSqlMapper.Instance().QueryForObject("Sku.SelectById", _ht));
}
/// <summary>
/// 设置行业版本菜单状态
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="status">修改值</param>
/// <returns></returns>
public string SetVersionMenuStatus(LoggingSessionInfo loggingSessionInfo, string menuID, string vocaVerMappingID, string appID, string status)
{
string strResult = string.Empty;
try
{
Hashtable ht = new Hashtable();
ht.Add("MenuID", menuID);
ht.Add("Status", status);
ht.Add("CreateBy", loggingSessionInfo.UserID);
ht.Add("VocaVerMappingID", vocaVerMappingID);
ht.Add("AppID", appID);
//查询是否存在
var versionMenu = MSSqlMapper.Instance().QueryForObject <Guid>("Right.Menu.SelectVersionMenu", ht);
if (versionMenu == new Guid("00000000-0000-0000-0000-000000000000"))
{
//插入
MSSqlMapper.Instance().Insert("Right.Menu.InsertVersionMenu", ht);
}
else
{
//提交
MSSqlMapper.Instance().Update("Right.Menu.UpdateVersionStatus", ht);
}
strResult = "状态修改成功.";
}
catch (Exception ex)
{
throw (ex);
}
return(strResult);
}
/// <summary>
/// 通过代码查询商品信息
/// </summary>
public IList <ItemInfo> GetItemByCode(string itemCode)
{
Hashtable _ht = new Hashtable();
_ht.Add("ItemCode", itemCode);
return(MSSqlMapper.Instance().QueryForList <ItemInfo>("Item.GetItemByCode", _ht));
}
/// <summary>
/// 查询商品
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="item_code">商品号码</param>
/// <param name="item_name">商品名称</param>
/// <param name="item_category_id">类型标识</param>
/// <param name="status">状态</param>
/// <param name="maxRowCount">当前页数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public ItemInfo SearchItemList(LoggingSessionInfo loggingSessionInfo
, string item_code
, string item_name
, string item_category_id
, string status
, int maxRowCount
, int startRowIndex)
{
Hashtable _ht = new Hashtable();
_ht.Add("item_code", item_code);
_ht.Add("item_name", item_name);
_ht.Add("item_category_id", item_category_id);
_ht.Add("status", status);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
ItemInfo itemInfo = new ItemInfo();
int iCount = MSSqlMapper.Instance().QueryForObject <int>("Item.SearchCount", _ht);
IList <ItemInfo> ItemInfoList = new List <ItemInfo>();
ItemInfoList = MSSqlMapper.Instance().QueryForList <ItemInfo>("Item.Search", _ht);
itemInfo.ICount = iCount;
itemInfo.ItemInfoList = ItemInfoList;
return(itemInfo);
//return MSSqlMapper.Instance().QueryForList<ItemInfo>("Item.Search", _ht);
}
/// <summary>
/// 设置商品主表信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemInfo"></param>
/// <returns></returns>
public bool SetItemTableInfo(LoggingSessionInfo loggingSessionInfo, ItemInfo itemInfo)
{
try
{
if (itemInfo != null)
{
itemInfo.Status = "1";
itemInfo.Status_Desc = "正常";
if (itemInfo.Create_User_Id == null || itemInfo.Create_User_Id.Equals(""))
{
itemInfo.Create_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemInfo.Create_Time = GetCurrentDateTime();
}
if (itemInfo.Modify_User_Id == null || itemInfo.Modify_User_Id.Equals(""))
{
itemInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemInfo.Modify_Time = GetCurrentDateTime();
}
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("Item.InsertOrUpdate", itemInfo);
}
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// AdOrder保存
/// </summary>
/// <param name="models">models</param>
/// <param name="IsTrans">是否批处理</param>
/// <returns>Hashtable:
/// status(成功：true, 失败：false)
/// error(错误描述)
/// </returns>
public Hashtable SaveAdOrderList(bool IsTrans, IList <AdvertiseOrderInfo> models)
{
Hashtable ht = new Hashtable();
ht["status"] = false;
try
{
if (IsTrans)
{
MSSqlMapper.Instance().BeginTransaction();
}
foreach (var model in models)
{
if (!CheckExistAdOrder(model))
{
MSSqlMapper.Instance().Insert("AdOrder.InsertAdOrder", model);
}
}
if (IsTrans)
{
MSSqlMapper.Instance().CommitTransaction();
}
ht["status"] = true;
}
catch (Exception ex)
{
if (IsTrans)
{
MSSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
return(ht);
}
/// <summary>
/// 获取AdvertiseOrderAdvertise
/// </summary>
public IList <AdvertiseOrderAdvertiseInfo> GetOrderAdList(string order_id)
{
Hashtable ht = new Hashtable();
ht["order_id"] = order_id;
return(MSSqlMapper.Instance().QueryForList <AdvertiseOrderAdvertiseInfo>("AdOrder.GetOrderAdList", ht));
}
/// <summary>
/// 需要打包的商品信息
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="maxRowCount">当前页数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public IList <ItemInfo> GetItemListPackaged(LoggingSessionInfo loggingSessionInfo, int maxRowCount, int startRowIndex)
{
Hashtable _ht = new Hashtable();
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
return(MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).QueryForList <ItemInfo>("Item.SelectUnDownload", _ht));
}
/// <summary>
/// 更新导出标记
/// </summary>
public void SetAdOrderListFlagByBatId(string customerId, string batId)
{
Hashtable ht = new Hashtable();
ht["customer_id"] = customerId;
ht["bat_id"] = batId;
MSSqlMapper.Instance().Update("AdOrder.SetAdOrderListFlagByBatId", ht);
}
