/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
private string PageSave()
{
string msg = string.Empty;
#region 获取表单
string type = Utils.GetFormValue("sltType");
DateTime txtDateTime = Utils.GetDateTime(Utils.GetFormValue("txtDateTime"), DateTime.Now);
decimal txtSource = Utils.GetDecimal(Utils.GetFormValue("txtSource"));
string txtRemarks = Utils.GetFormValue("txtRemarks");
string crmId = Utils.GetQueryStringValue("crmId");
#endregion
EyouSoft.Model.CrmStructure.MJiFenInfo model = new EyouSoft.Model.CrmStructure.MJiFenInfo();
EyouSoft.BLL.CrmStructure.BCrmMember bll = new EyouSoft.BLL.CrmStructure.BCrmMember();
model.CrmId = crmId;
model.IssueTime = DateTime.Now;
model.JiFen = txtSource;
model.JiFenShiJian = txtDateTime;
model.OperatorId = SiteUserInfo.UserId;
model.Remark = txtRemarks;
model.ZengJianLeiBie = type == "1" ? EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie.增加 : EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie.减少;
if (bll.SetJiFen(model))
{
msg = UtilsCommons.AjaxReturnJson("1", "操作成功!");
}
else
{
msg = UtilsCommons.AjaxReturnJson("0", "操作失败!");
}
return(msg);
}
/// <summary>
/// 设置个人会员积分
/// </summary>
/// <param name="info">积分信息业务实体</param>
/// <returns></returns>
public bool SetJiFen(EyouSoft.Model.CrmStructure.MJiFenInfo info)
{
string cmdText = "INSERT INTO[tbl_CrmJiFen]([CrmId],[JiFenShiJian],[ZengJianLeiBie],[JiFen],[Remark],[OperatorId],[IssueTime],[OrderId],[OrderJinE],[JiFenBiLi])VALUES(@CrmId,@JiFenShiJian,@ZengJianLeiBie,@JiFen,@Remark,@OperatorId,@IssueTime,@OrderId,@OrderJinE,@JiFenBiLi)";
/*if (info.ZengJianLeiBie == EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie.增加)
* {
* cmdText += ";UPDATE tbl_CrmMember SET AvailableIntegral=AvailableIntegral+@JiFen WHERE CrmId=@CrmId";
* }
* else
* {
* cmdText += ";UPDATE tbl_CrmMember SET AvailableIntegral=AvailableIntegral-@JiFen WHERE CrmId=@CrmId";
* }*/
DbCommand cmd = _db.GetSqlStringCommand(cmdText);
_db.AddInParameter(cmd, "CrmId", DbType.AnsiStringFixedLength, info.CrmId);
_db.AddInParameter(cmd, "JiFenShiJian", DbType.DateTime, info.JiFenShiJian);
_db.AddInParameter(cmd, "ZengJianLeiBie", DbType.Byte, info.ZengJianLeiBie);
_db.AddInParameter(cmd, "JiFen", DbType.Decimal, info.JiFen);
_db.AddInParameter(cmd, "Remark", DbType.String, info.Remark);
_db.AddInParameter(cmd, "OperatorId", DbType.AnsiStringFixedLength, info.OperatorId);
_db.AddInParameter(cmd, "IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "OrderId", DbType.AnsiStringFixedLength, info.OrderId);
_db.AddInParameter(cmd, "OrderJinE", DbType.Decimal, info.OrderJinE);
_db.AddInParameter(cmd, "JiFenBiLi", DbType.Decimal, info.JiFenBiLi);
return(DbHelper.ExecuteSql(cmd, _db) > 1);
}
/// <summary>
/// 获取个人会员积分明细集合
/// </summary>
/// <param name="crmId">个人会员编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页索引</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.CrmStructure.MJiFenInfo> GetJiFens(string crmId, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.CrmStructure.MJiFenInfo> items = new List <EyouSoft.Model.CrmStructure.MJiFenInfo>();
string tableName = "tbl_CrmJiFen";
string fields = "JiFenShiJian,ZengJianLeiBie,JiFen,Remark,IssueTime";
string orderByString = "Id DESC";
string query = string.Format(" CrmId='{0}' ", crmId);
using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, string.Empty, fields, query, orderByString))
{
while (rdr.Read())
{
EyouSoft.Model.CrmStructure.MJiFenInfo item = new EyouSoft.Model.CrmStructure.MJiFenInfo();
item.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
item.JiFen = rdr.GetDecimal(rdr.GetOrdinal("JiFen"));
item.JiFenShiJian = rdr.GetDateTime(rdr.GetOrdinal("JiFenShiJian"));
item.Remark = rdr["Remark"].ToString();
item.ZengJianLeiBie = (EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie)rdr.GetByte(rdr.GetOrdinal("ZengJianLeiBie"));
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="order">订单、游客、游客保险组合的实体</param>
/// <returns>
///1:修改后的订单人数超过计划剩余人数
///2:合同未领用
///3:添加成功
///4:添加失败
///-----------
///--5:自动客满
///--6:自动停收
///--7:手动客满
///--8:手动停收
///(5,6,7,8用于分销商订单报名时的计划状态判断)
/// ----------
///王磊： 2012-08-20
/// --9:销售员超限
///--10:客户超限
///--11:销售员客户单位均超限
/// </returns>
public int AddTourOrderExpand(MTourOrderExpand order)
{
//计划状态封团不允许添加订单
//收客客满
//计划停收
//订单人数超出了剩余人数
//合同号未领用
//添加失败
//添加失败
//关于订单的金额
//order.SumPrice可手动输入
order.SettlementMoney = order.PeerAdultPrice * order.Adults + order.PeerChildPrice * order.Childs;
order.ConfirmSettlementMoney = order.SettlementMoney + order.PeerAddCost - order.PeerReduceCost;
order.ConfirmMoney = order.SumPrice + order.SumPriceAddCost - order.SumPriceReduceCost;
order.SalerIncome = order.SumPrice - order.GuideIncome;
int flg = dal.AddTourOrderExpand(order);
if (flg == 3)
{
//添加操作日志
StringBuilder str = new StringBuilder();
str.AppendFormat("新增订单,订单编号:{0}", order.OrderId);
EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString());
}
if (flg == 3 && order.IsJiFen == 1)
{
decimal jiFenBiLi = 0;
var setting = EyouSoft.Security.Membership.UserProvider.GetComSetting(order.CompanyId);
if (setting != null)
{
jiFenBiLi = (decimal)setting.IntegralProportion / 100M;
}
if (jiFenBiLi > 0)
{
var jiFenInfo = new EyouSoft.Model.CrmStructure.MJiFenInfo();
EyouSoft.BLL.CrmStructure.BCrmMember bll = new EyouSoft.BLL.CrmStructure.BCrmMember();
jiFenInfo.CrmId = order.BuyCompanyId;
jiFenInfo.IssueTime = System.DateTime.Now;
jiFenInfo.JiFen = order.SumPrice * jiFenBiLi;
jiFenInfo.JiFenShiJian = System.DateTime.Now;
jiFenInfo.OperatorId = order.OperatorId;
jiFenInfo.Remark = string.Empty;
jiFenInfo.ZengJianLeiBie = EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie.增加;
jiFenInfo.OrderId = order.OrderId;
jiFenInfo.OrderJinE = order.SumPrice;
jiFenInfo.JiFenBiLi = jiFenBiLi;
new EyouSoft.BLL.CrmStructure.BCrmMember().SetJiFen(jiFenInfo);
}
}
return(flg);
}
/// <summary>
/// 设置个人会员积分
/// </summary>
/// <param name="info">积分信息业务实体</param>
/// <returns></returns>
public bool SetJiFen(EyouSoft.Model.CrmStructure.MJiFenInfo info)
{
if (info == null)
{
return(false);
}
info.IssueTime = DateTime.Now;
if (dal.SetJiFen(info))
{
SysStructure.BSysLogHandle.Insert(string.Format("设置个人会员积分，会员编号：{0}，积分{1}{2}。", info.CrmId, info.ZengJianLeiBie, info.JiFen));
return(true);
}
return(false);
}
/// <summary>
/// 修改团队报价(2报价成功 3 修改成功 4操作失败 5销售员超限 6客户超限 7 销售员客户均超限)
/// 2012-8-17 王磊 返回的结果 去掉【1超限，垫付申请中】
/// </summary>
/// <param name="info">报价实体</param>
/// <returns></returns>
public int SuccessTourQuote(EyouSoft.Model.TourStructure.MTourQuoteInfo info)
{
int result = 3;
if (info.MTourQuoteTourInfo != null && info.MTourQuoteTourInfo.LDate != null)
{
info.MTourQuoteTourInfo.TourId = System.Guid.NewGuid().ToString();
info.MTourQuoteTourInfo.TourCode = "";
//info.OrderCode = info.MTourQuoteTourInfo.TourCode + "01";
}
info.OrderId = System.Guid.NewGuid().ToString();
info.OrderCode = "";
if (string.IsNullOrEmpty(info.QuoteId))
{
//先新增，再报价成功
info.QuoteId = System.Guid.NewGuid().ToString();
info.ParentId = "0";
if (dal.AddTourQuote(info))
{
result = dal.UpdateTourQuote(info);
}
}
else
{
result = dal.UpdateTourQuote(info);
}
if (result == 1)
{
//添加操作日志
System.Text.StringBuilder str = new System.Text.StringBuilder();
str.AppendFormat("报价未成功(超限垫付申请中)，,报价编号:{0}", info.QuoteId);
EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString());
}
if (result == 2)
{
//添加操作日志
System.Text.StringBuilder str = new System.Text.StringBuilder();
str.AppendFormat("报价成功,报价编号:{0}", info.QuoteId);
EyouSoft.BLL.SysStructure.BSysLogHandle.Insert(str.ToString());
}
if (result == 2 && info.IsJiFen == 1)
{
decimal jiFenBiLi = 0;
var setting = EyouSoft.Security.Membership.UserProvider.GetComSetting(info.CompanyId);
if (setting != null)
{
jiFenBiLi = (decimal)setting.IntegralProportion / 100M;
}
if (jiFenBiLi > 0)
{
var jiFenInfo = new EyouSoft.Model.CrmStructure.MJiFenInfo();
EyouSoft.BLL.CrmStructure.BCrmMember bll = new EyouSoft.BLL.CrmStructure.BCrmMember();
jiFenInfo.CrmId = info.BuyCompanyID;
jiFenInfo.IssueTime = System.DateTime.Now;
jiFenInfo.JiFen = info.TotalPrice * jiFenBiLi;
jiFenInfo.JiFenShiJian = System.DateTime.Now;
jiFenInfo.OperatorId = info.OperatorInfo.OperatorId;
jiFenInfo.Remark = string.Empty;
jiFenInfo.ZengJianLeiBie = EyouSoft.Model.EnumType.CrmStructure.JiFenZengJianLeiBie.增加;
jiFenInfo.OrderId = info.OrderId;
jiFenInfo.OrderJinE = info.TotalPrice;
jiFenInfo.JiFenBiLi = jiFenBiLi;
new EyouSoft.BLL.CrmStructure.BCrmMember().SetJiFen(jiFenInfo);
}
}
return(result);
}
