public PageResultEntity GetStorePageData(HttpContext pContext)
{
CallDayPlanningBLL_Store b = new CallDayPlanningBLL_Store(CurrentUserInfo, "Store");
string pSearch = pContext.Request["pSearch"];
List <DefindControlEntity> l = new List <DefindControlEntity>();
if (!string.IsNullOrEmpty(pSearch))
{
l = pSearch.DeserializeJSONTo <List <DefindControlEntity> >();
}
int?pPageIndex = null;
int?pPageSize = null;
if (!string.IsNullOrEmpty(pContext.Request["pPageIndex"]))
{
pPageIndex = Convert.ToInt32(pContext.Request["pPageIndex"]);
}
if (!string.IsNullOrEmpty(pContext.Request["pPageSize"]))
{
pPageSize = Convert.ToInt32(pContext.Request["pPageSize"]);
}
CallDayPlanningViewEntity_POP entity = new CallDayPlanningViewEntity_POP();
entity.ClientUserID = pContext.Request["CorrelationValue"].Split('|')[0].ToInt();
entity.CallDate = pContext.Request["CorrelationValue"].Split('|')[1].ToDateTime();
return(b.GetUserCDPStoreList(l, pPageSize, pPageIndex, entity));
}
public void EditCDP(CallDayPlanningEntity entity, string poplist)
{
CallDayPlanningViewEntity_POP searchEntity = new CallDayPlanningViewEntity_POP();
searchEntity.ClientUserID = entity.ClientUserID;
searchEntity.CallDate = entity.CallDate;
CallDayPlanningEntity[] oldEntity = this._currentDAO.GetCallDayPlanning(searchEntity);
IDbTransaction tran = new TransactionHelper(this.CurrentUserInfo).CreateTransaction();
using (tran.Connection)
{
try
{
foreach (string popid in poplist.Split(','))
{
if (!string.IsNullOrEmpty(popid) &&
oldEntity.Where(m => m.POPID == popid).ToArray().Length == 0)
{
entity.PlanningID = null;
entity.POPID = popid;
this._currentDAO.Create(entity, tran);
}
}
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 路线地图选择终端
/// </summary>
/// <param name="routeid"></param>
/// <param name="mappingEntity"></param>
/// <param name="deletelist">删除的ID集合（不要含用户后来又选择的）</param>
public void EditUserCDPPOPMap_Store(CallDayPlanningViewEntity_POP infoEntity, List <DefindControlEntity> pSearch, CallDayPlanningViewEntity_POP[] mappingEntity, string deletelist)
{
IDbTransaction tran = new TransactionHelper(this.CurrentUserInfo).CreateTransaction();
using (tran.Connection)
{
try
{
List <CallDayPlanningEntity> oldList = this._currentDAO.GetCallDayPlanning(infoEntity).ToList();
for (int i = 0; i < mappingEntity.Length; i++)
{
CallDayPlanningViewEntity_POP entity = mappingEntity[i];
if (entity.MappingID != null && !string.IsNullOrEmpty(entity.MappingID.ToString()))
{
//修改
CallDayPlanningEntity uEntity = oldList.Where(m => m.PlanningID == entity.MappingID).ToArray()[0];
uEntity.Sequence = (i + 1);
this._currentDAO.Update(uEntity, tran);
}
else
{
//新增
CallDayPlanningEntity uEntity = new CallDayPlanningEntity();
uEntity.CallDate = infoEntity.CallDate;
uEntity.POPID = entity.StoreID.ToString().ToLower();
uEntity.POPType = 1;
uEntity.ClientUserID = infoEntity.ClientUserID;
uEntity.Sequence = (i + 1);
uEntity.PlanningType = 2;
uEntity.ClientID = Convert.ToInt32(CurrentUserInfo.ClientID);
uEntity.ClientDistributorID = Convert.ToInt32(CurrentUserInfo.ClientDistributorID);
this._currentDAO.Create(uEntity, tran);
}
}
//删除
if (deletelist != null && !string.IsNullOrEmpty(deletelist))
{
foreach (string mapid in deletelist.Split(','))
{
if (!string.IsNullOrEmpty(mapid))
{
this._currentDAO.Delete(Guid.Parse(mapid), tran);
}
}
}
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 拜访计划终端选择
/// </summary>
/// <param name="infoEntity">clientuserid,calldate 必传</param>
/// <param name="pSearch"></param>
/// <param name="mappingEntity"></param>
public void EditUserCDPPOPList_Store(
CallDayPlanningViewEntity_POP infoEntity,
List <DefindControlEntity> pSearch,
CallDayPlanningViewEntity_POP[] mappingEntity)
{
IDbTransaction tran = new TransactionHelper(this.CurrentUserInfo).CreateTransaction();
using (tran.Connection)
{
try
{
List <CallDayPlanningEntity> oldList = this._currentDAO.GetCallDayPlanning(infoEntity).ToList();
foreach (CallDayPlanningViewEntity_POP entity in mappingEntity)
{
if (entity.MappingID != null && !string.IsNullOrEmpty(entity.MappingID.ToString()))
{
if (entity.IsDelete == 1)
{
//删除
this._currentDAO.Delete(entity.MappingID, tran);
}
else
{
//修改
CallDayPlanningEntity uEntity = oldList.Where(m => m.PlanningID == entity.MappingID).ToArray()[0];
uEntity.Sequence = entity.Sequence;
this._currentDAO.Update(uEntity, tran);
}
}
else
{
//新增
CallDayPlanningEntity uEntity = new CallDayPlanningEntity();
uEntity.CallDate = infoEntity.CallDate;
uEntity.POPID = entity.StoreID.ToString().ToLower();
uEntity.POPType = 1;
uEntity.ClientUserID = infoEntity.ClientUserID;
uEntity.Sequence = entity.Sequence;
uEntity.PlanningType = 2;
uEntity.ClientID = Convert.ToInt32(CurrentUserInfo.ClientID);
uEntity.ClientDistributorID = Convert.ToInt32(CurrentUserInfo.ClientDistributorID);
this._currentDAO.Create(uEntity, tran);
}
}
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
private string EditRoutePOPList_Store(HttpContext pContext)
{
string pSearch = pContext.Request["pSearch"];
List <DefindControlEntity> l = new List <DefindControlEntity>();
if (!string.IsNullOrEmpty(pSearch))
{
l = pSearch.DeserializeJSONTo <List <DefindControlEntity> >();
}
CallDayPlanningViewEntity_POP infoEntity = new CallDayPlanningViewEntity_POP();
infoEntity.ClientUserID = pContext.Request["id"].Split('|')[0].ToInt();
infoEntity.CallDate = pContext.Request["id"].Split('|')[1].ToDateTime();
CallDayPlanningViewEntity_POP[] entity = pContext.Request["form"].DeserializeJSONTo <CallDayPlanningViewEntity_POP[]>();
new CallDayPlanningBLL_Store(CurrentUserInfo, "Store").EditUserCDPPOPList_Store(infoEntity, l, entity);
return("{success:true}");
}
public PageResultEntity GetUserCDPStoreList(List <DefindControlEntity> pSearch, int?pPageSize, int?pPageIndex, CallDayPlanningViewEntity_POP entity)
{
StringBuilder sql = new StringBuilder();
sql.Append(base.GetTempSql()); //需要生成的临时表
sql.AppendLine("select ");
sql.Append(new StoreDefindModuleBLL(CurrentUserInfo, "Store").GetStoreGridFildSQL()); //获取字SQL
//new
sql.AppendFormat(" CPOPM.PlanningID as MappingID,cast('{0}' as int) as ClientUserID,CPOPM.POPID,CPOPM.Sequence, ", entity.ClientUserID);
sql.AppendLine("ROW_NUMBER() OVER( order by case when CPOPM.PlanningID is null then 1 else 0 end asc,CPOPM.Sequence asc,CPOPM.CreateTime asc) ROW_NUMBER,");
sql.AppendLine("main.StoreID into #outTemp");
sql.AppendLine("from Store main");
sql.Append(new StoreDefindModuleBLL(CurrentUserInfo, "Store").GetStoreLeftGridJoinSQL()); //获取联接SQL
sql.AppendLine("");
sql.Append(new StoreDefindModuleBLL(CurrentUserInfo, "Store").GetStoreSearchJoinSQL(pSearch)); //获取条件联接SQL
//new
sql.AppendLine(string.Format(" inner join (select distinct StoreID from dbo.fnGetStoreByUserID('{0}',1)) fn_sad on CONVERT(nvarchar(100),main.StoreID) = CONVERT(nvarchar(100),fn_sad.StoreID) ", entity.ClientUserID));
sql.AppendFormat(@" left join CallDayPlanning CPOPM
on CPOPM.POPType=1 and cast(main.StoreID as nvarchar(200))=CPOPM.POPID
and CPOPM.isdelete=0 and CONVERT(date,CPOPM.CallDate,23)='{0}' and CPOPM.ClientUserID={1}
and CPOPM.ClientID={2} and CPOPM.ClientDistributorID={3}",
entity.CallDate.Value.ToShortDateString(),
entity.ClientUserID,
CurrentUserInfo.ClientID,
CurrentUserInfo.ClientDistributorID);
sql.AppendLine(string.Format("Where main.IsDelete=0 and main.ClientID={0}",
base._pUserInfo.ClientID));
sql.Append(new StoreDefindModuleBLL(CurrentUserInfo, "").GetStroeGridSearchSQL(pSearch)); //获取条件
sql.Append(base.GetPubPageSQL(pPageSize, pPageIndex));
sql.Append(base.GetDropTempSql()); //需要删除的临时表
return(base.GetPageData(sql.ToString()));
}
