/// <summary>
/// 构造函数
/// </summary>
public Agg_UnitWeeklyDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public T_Menu_FunctionDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public T_Sku_PropertyBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new T_Sku_PropertyDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public CustomerWithdrawalTransferMappingBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new CustomerWithdrawalTransferMappingDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public SysReservationPositionStatusBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new SysReservationPositionStatusDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public t_customerDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 处理盘点单信息（新建，修改）
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="ccInfo">盘点单model</param>
/// <param name="IsTrans">是否批处理</param>
/// <param name="strError">返回错误信息</param>
/// <returns></returns>
public bool SetCCInfo(LoggingSessionInfo loggingSessionInfo, CCInfo ccInfo, bool IsTrans, out string strError)
{
string strDo = string.Empty;
if (IsTrans)
{
cSqlMapper.Instance().BeginTransaction();
}
try
{
ccInfo.customer_id = loggingSessionInfo.CurrentLoggingManager.Customer_Id;
if (ccInfo.if_flag == null || ccInfo.if_flag.ToString().Trim().Equals(""))
{
ccInfo.if_flag = "0";
}
if (ccInfo.order_type_id == null || ccInfo.order_type_id.Equals(""))
{
ccInfo.order_type_id = "51BE351BFA5E49A490103669EA21BC3C";
}
if (ccInfo.BillKindCode == null || ccInfo.BillKindCode.Equals(""))
{
ccInfo.BillKindCode = "CC";
}
if (ccInfo.order_id == null || ccInfo.order_id.Equals(""))
{
ccInfo.order_id = NewGuid();
}
//1.判断重复
if (!IsExistOrderCode(loggingSessionInfo, ccInfo.order_no, ccInfo.order_id))
{
strError = "订单号码已经存在。";
throw (new System.Exception(strError));
}
if (ccInfo.operate == null || ccInfo.operate.Equals(""))
{
ccInfo.operate = "Create";
}
if (ccInfo.operate.Equals("Create"))
{
//2.提交表单
if (!SetInoutOrderInsertBill(loggingSessionInfo, ccInfo))
{
strError = "盘点单表单提交失败。";
throw (new System.Exception(strError));
}
//3.更改状态
BillModel billInfo = new cBillService().GetBillById(loggingSessionInfo, ccInfo.order_id);
if (billInfo != null)
{
ccInfo.status = billInfo.Status;
ccInfo.status_desc = billInfo.BillStatusDescription;
}
}
//4.提交cc与ccdetail信息
if (!SetCCTableInfo(loggingSessionInfo, ccInfo))
{
strError = "提交用户表失败";
throw (new System.Exception(strError));
}
if (IsTrans)
{
cSqlMapper.Instance().CommitTransaction();
}
strError = "保存成功!";
return(true);
}
catch (Exception ex)
{
if (IsTrans)
{
cSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
}
/// <summary>
/// 构造函数
/// </summary>
public PushAndroidMessageBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new PushAndroidMessageDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public TimingPushMessageVipLastRecordDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public T_MenuBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new T_MenuDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public EclubLabelBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new EclubLabelDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public UtilityDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo, true)
{
}
/// <summary>
/// 构造函数
/// </summary>
public ReservationServiceBigClassTermStatusBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new ReservationServiceBigClassTermStatusDAO(pUserInfo);
}
protected string _pTableName;//虚拟的tablename，即clientbusinessdefined里的tablename
#region 构造函数
/// <summary>
/// 构造函数
/// </summary>
/// <param name="pUserInfo"></param>
/// <param name="pTableName"></param>
public DefindModuleCRUD(LoggingSessionInfo pUserInfo, string pTableName)
{
this._currentDAO = new ClientBussinessDefinedDAO(pUserInfo);
_pUserInfo = pUserInfo;
_pTableName = pTableName;
}
/// <summary>
/// 构造函数
/// </summary>
public TicketBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new TicketDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public X_VipPointMarkDetailBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new X_VipPointMarkDetailDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public ShoppingCartDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public C_MessageSendDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public SysVisitLogsBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new SysVisitLogsDAO(pUserInfo);
}
protected override BeSuperRetailTraderRD ProcessRequest(DTO.Base.APIRequest <BeSuperRetailTraderRP> pRequest)
{
var rd = new BeSuperRetailTraderRD();
var para = pRequest.Parameters;
LoggingSessionInfo loggingSessionInfo = Default.GetBSLoggingSession(pRequest.CustomerID, pRequest.UserID);
var vipBll = new VipBLL(loggingSessionInfo);
var userBll = new T_UserBLL(loggingSessionInfo);
var T_SuperRetailTraderEntityBll = new T_SuperRetailTraderBLL(loggingSessionInfo);
var InnerGroupNewsbll = new InnerGroupNewsBLL(loggingSessionInfo);//目前还没有针对单对单通知的站内信
WMenuBLL menuServer = new WMenuBLL(Default.GetAPLoggingSession(""));
string customerCode = menuServer.GetCustomerCodeByCustomerID(loggingSessionInfo.CurrentUser.customer_id);
if (!string.IsNullOrEmpty(para.BeRYType))
{
VipEntity VipInfo = null; //会员实体
T_UserEntity T_UserInfo = null; //员工实体
T_SuperRetailTraderEntity T_SuperRetailTraderInfo = null; //超级分销商实体
T_SuperRetailTraderInfo = T_SuperRetailTraderEntityBll.QueryByEntity(new T_SuperRetailTraderEntity()
{
CustomerId = loggingSessionInfo.CurrentUser.customer_id, SuperRetailTraderFromId = para.SuperRetailTraderFromId
}, null).FirstOrDefault();
//判断是否已成为分销商
if (T_SuperRetailTraderInfo == null)
{
var SuperRetailTraderEntity = new T_SuperRetailTraderEntity();
//不是分销商 就判断分销商来源类型
if (para.BeRYType == "Vip")
{
//查询会员信息
VipInfo = vipBll.QueryByEntity(new VipEntity()
{
ClientID = loggingSessionInfo.CurrentUser.customer_id, VIPID = para.SuperRetailTraderFromId
}, null).FirstOrDefault();
if (VipInfo != null)
{
try
{
SuperRetailTraderEntity.SuperRetailTraderID = Guid.NewGuid();
SuperRetailTraderEntity.SuperRetailTraderCode = VipInfo.VipCode;
SuperRetailTraderEntity.SuperRetailTraderName = VipInfo.VipRealName == null ? VipInfo.VipName : VipInfo.VipRealName;
SuperRetailTraderEntity.SuperRetailTraderLogin = VipInfo.Phone;
string strSuperPwd = StringUtil.GetRandomStr(6);//生成6位随机数,为超级分销商密码生成使用
SuperRetailTraderEntity.SuperRetailTraderPass = EncryptManager.Hash(strSuperPwd, HashProviderType.MD5);
SuperRetailTraderEntity.SuperRetailTraderPassData = strSuperPwd;
SuperRetailTraderEntity.SuperRetailTraderMan = VipInfo.VipRealName == null ? VipInfo.VipName : VipInfo.VipRealName;
SuperRetailTraderEntity.SuperRetailTraderPhone = VipInfo.Phone;
SuperRetailTraderEntity.SuperRetailTraderAddress = "";//目前因为没有填写详细地址的地方，给空值
SuperRetailTraderEntity.SuperRetailTraderFrom = para.BeRYType;
SuperRetailTraderEntity.SuperRetailTraderFromId = VipInfo.VIPID;
if (!string.IsNullOrEmpty(para.HigheSuperRetailTraderID))
{
SuperRetailTraderEntity.HigheSuperRetailTraderID = new Guid(para.HigheSuperRetailTraderID);
}
if (!string.IsNullOrEmpty(VipInfo.Col20))
{
SuperRetailTraderEntity.HigheSuperRetailTraderID = new Guid(VipInfo.Col20);
}
SuperRetailTraderEntity.JoinTime = System.DateTime.Now;
SuperRetailTraderEntity.CreateTime = System.DateTime.Now;
SuperRetailTraderEntity.CreateBy = VipInfo.VIPID;
SuperRetailTraderEntity.LastUpdateBy = VipInfo.VIPID;
SuperRetailTraderEntity.LastUpdateTime = System.DateTime.Now;
SuperRetailTraderEntity.IsDelete = 0;
SuperRetailTraderEntity.CustomerId = loggingSessionInfo.CurrentUser.customer_id;
SuperRetailTraderEntity.Status = "00";
T_SuperRetailTraderEntityBll.Create(SuperRetailTraderEntity);
rd.IsSuperRetailTrader = 1;
rd.SuperRetailTraderLogin = VipInfo.Phone;
rd.SuperRetailTraderPass = strSuperPwd;
VipInfo.Col26 = SuperRetailTraderEntity.SuperRetailTraderID.ToString();
vipBll.Update(VipInfo, false);
}
catch
{
rd.IsSuperRetailTrader = 0;
}
}
}
//不是分销商 就判断分销商来源类型
if (para.BeRYType == "User")
{
//查询员工信息
T_UserInfo = userBll.QueryByEntity(new T_UserEntity()
{
customer_id = loggingSessionInfo.CurrentUser.customer_id, user_id = para.SuperRetailTraderFromId
}, null).FirstOrDefault();
if (T_UserInfo != null)
{
try
{
SuperRetailTraderEntity.SuperRetailTraderID = Guid.NewGuid();
SuperRetailTraderEntity.SuperRetailTraderCode = T_UserInfo.user_code;
SuperRetailTraderEntity.SuperRetailTraderName = T_UserInfo.user_name;
SuperRetailTraderEntity.SuperRetailTraderLogin = T_UserInfo.user_code;
SuperRetailTraderEntity.SuperRetailTraderPass = T_UserInfo.user_password;
SuperRetailTraderEntity.SuperRetailTraderMan = T_UserInfo.user_name;
SuperRetailTraderEntity.SuperRetailTraderPhone = T_UserInfo.user_telephone != null ? T_UserInfo.user_telephone : T_UserInfo.user_cellphone;
SuperRetailTraderEntity.SuperRetailTraderAddress = T_UserInfo.user_address;
SuperRetailTraderEntity.SuperRetailTraderFrom = para.BeRYType;
SuperRetailTraderEntity.SuperRetailTraderFromId = T_UserInfo.user_id;
if (!string.IsNullOrEmpty(para.HigheSuperRetailTraderID))
{
SuperRetailTraderEntity.HigheSuperRetailTraderID = new Guid(para.HigheSuperRetailTraderID);
}
SuperRetailTraderEntity.JoinTime = System.DateTime.Now;
SuperRetailTraderEntity.CreateTime = System.DateTime.Now;
SuperRetailTraderEntity.CreateBy = T_UserInfo.user_id;
SuperRetailTraderEntity.LastUpdateBy = T_UserInfo.user_id;
SuperRetailTraderEntity.LastUpdateTime = System.DateTime.Now;
SuperRetailTraderEntity.IsDelete = 0;
SuperRetailTraderEntity.CustomerId = loggingSessionInfo.CurrentUser.customer_id;
SuperRetailTraderEntity.Status = "00";
T_SuperRetailTraderEntityBll.Create(SuperRetailTraderEntity);
rd.IsSuperRetailTrader = 1;//成功成为分销商
}
catch
{
rd.IsSuperRetailTrader = 0;//成为分销商失败
}
}
}
//如果成为分销商 则需要增加站内信通知
if (rd.IsSuperRetailTrader == 1)
{
}
}
else
{
rd.IsSuperRetailTrader = 2;//已成为分销商
rd.SuperRetailTraderLogin = T_SuperRetailTraderInfo.SuperRetailTraderLogin;
rd.SuperRetailTraderPass = T_SuperRetailTraderInfo.SuperRetailTraderPassData;
}
}
if (!string.IsNullOrEmpty(customerCode))
{
rd.CustomerCode = customerCode;
}
return(rd);
}
/// <summary>
/// 构造函数
/// </summary>
public CustomerPayAssignDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public RegisterRequiredPageBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new RegisterRequiredPageDAO(pUserInfo);
}
/// <summary>
/// 构造函数
/// </summary>
public WXHouseBuyDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public UrlBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new UrlDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public OrderOrderSubRunObjectMappingBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new OrderOrderSubRunObjectMappingDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public RoutePOPMappingDAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo, true)
{
}
private void DoWork()
{
while (true)
{
try
{
ConfigurationManager.RefreshSection("appSettings");
var time = ConfigurationManager.AppSettings["Timing"];
TimeSpan.TryParse(time, out _timeSpan);
if (DateTime.Now.TimeOfDay.Hours == _timeSpan.Hours)
{
//支持配置多客户
string[] customerIDs = ConfigurationManager.AppSettings["CustomerIDs"].Split(',');
foreach (string customerID in customerIDs)
{
loggingSessionInfo = Default.GetBSLoggingSession(customerID, "1");
var eventsService = new LEventsBLL(loggingSessionInfo);
LEventsEntity queryEntity = new LEventsEntity();
queryEntity.EventType = 0;
var data = eventsService.WEventGetWebEvents(queryEntity, 0, 100000000);
foreach (var item in data)
{
XieHuiBaoBLL b = new XieHuiBaoBLL(loggingSessionInfo, "vip");
List <DefindControlEntity> l = new List <DefindControlEntity>();
PageResultEntity pageEntity = null;
try
{
pageEntity = b.GetPageDataByEventID(l, 100000000, 0, item.EventID);
}
catch (Exception e)
{
Loggers.Debug(new DebugLogInfo
{
Message = string.Format("{0} {1} (EventID:{3})报名人员信息通知邮件发送{2}", DateTime.Now.ToShortDateString(), DateTime.Now.TimeOfDay, "失败", item.EventID)
});
Loggers.Exception(new BasicUserInfo(), e);
continue;
}
if (pageEntity.GridData != null)
{
if (pageEntity.GridData.Rows.Count == 0)
{
continue;
}
}
GridInitEntity g = GetInitGridDataByEventID(item.EventID);
if (pageEntity != null && pageEntity.GridData != null)
{
#region 替换标题信息
if (g != null && g.GridColumnDefinds != null)
{
if (pageEntity.GridData.Columns.Contains("ROW_NUMBER"))
{
pageEntity.GridData.Columns.Remove("ROW_NUMBER");
}
if (pageEntity.GridData.Columns.Contains("SignUpID"))
{
pageEntity.GridData.Columns.Remove("SignUpID");
}
if (pageEntity.GridData.Columns.Count == 0)
{
continue;
}
for (int i = 0; i < pageEntity.GridData.Columns.Count; i++)
{
for (int j = 0; j < g.GridColumnDefinds.Count; j++)
{
if (pageEntity.GridData.Columns[i].ColumnName.ToLower() == g.GridColumnDefinds[j].DataIndex.ToLower())
{
pageEntity.GridData.Columns[i].ColumnName = g.GridColumnDefinds[j].ColumnText;
break;
}
}
}
}
#endregion
}
//数据获取
Workbook wb = DataTableExporter.WriteXLS(pageEntity.GridData, 0);
wb.Worksheets[0].Name = "参加活动人员信息";
string savePath = ConfigurationManager.AppSettings["FileURL"];
if (!Directory.Exists(savePath))
{
Directory.CreateDirectory(savePath);
}
savePath = savePath + "/" + item.Title + DateTime.Now.ToString("yyyyMMdd") + ".xls";
wb.Save(savePath);//保存Excel文件
#region 邮件发送
FromSetting fs = new FromSetting();
fs.SMTPServer = ConfigurationManager.AppSettings["SmtpServer"];
fs.SendFrom = ConfigurationManager.AppSettings["MailSendFrom"];
fs.UserName = ConfigurationManager.AppSettings["MailUserName"];
fs.Password = ConfigurationManager.AppSettings["MailUserPassword"];
string mailTo = ConfigurationManager.AppSettings["MailTo"];
string isSendMail = ConfigurationManager.AppSettings["IsSendMailToCreator"];
//是否发送成功
bool result = false;
if (!string.IsNullOrEmpty(mailTo))
{
result = Mail.SendMail(fs, mailTo, ConfigurationManager.AppSettings["MailTitle"], ConfigurationManager.AppSettings["Subject"], savePath.Split(','));
}
if (isSendMail == "1")
{
if (!string.IsNullOrEmpty(item.Email))
{
if (DateTime.Now < DateTime.Parse(item.EndTime))
{
//等于0表示不发送邮件
if (item.MailSendInterval == null || item.MailSendInterval == 0)
{
continue;
}
//日期差与间隔时间取余判断是否符合发送邮件日期
int dateDiff = ((TimeSpan)(DateTime.Now.Date - item.LastUpdateTime.Value.Date)).Days;
if (dateDiff % item.MailSendInterval != 0)
{
continue;
}
result = Mail.SendMail(fs, item.Email, ConfigurationManager.AppSettings["MailTitle"], ConfigurationManager.AppSettings["Subject"], savePath.Split(','));
Loggers.Debug(new DebugLogInfo
{
Message = string.Format("{0} {1} (EventID:{3})报名人员信息通知邮件发送{2}", DateTime.Now.ToShortDateString(), DateTime.Now.TimeOfDay, result ? "成功" : "失败", item.EventID)
});
}
}
}
#endregion
}
}
}
}
catch (Exception ex)
{
Loggers.Exception(new BasicUserInfo(), ex);
}
Thread.Sleep(new TimeSpan(0, 1, 0, 0));
}
}
/// <summary>
/// 构造函数
/// </summary>
public t_award_poolBLL(LoggingSessionInfo pUserInfo)
{
this._currentDAO = new t_award_poolDAO(pUserInfo);
this.CurrentUserInfo = pUserInfo;
}
/// <summary>
/// 构造函数
/// </summary>
public R_SetoffHome2DAO(LoggingSessionInfo pUserInfo)
: base(pUserInfo)
{
}
/// <summary>
/// 构造函数
/// </summary>
public ZCourseApplyBLL(LoggingSessionInfo pUserInfo)
{
this.CurrentUserInfo = pUserInfo;
this._currentDAO = new ZCourseApplyDAO(pUserInfo);
}
