/// <summary>
/// insert
/// </summary>
/// <param name="sysAreaPost">Model</param>
/// <param name="ErrorMsg">Result</param>
/// <returns></returns>
public bool Create(SysAreaPost sysAreaPost, ref string ErrorMsg)
{
try
{
SysArea sysArea = new SysArea();
LinqHelper.ModelTrans(sysAreaPost, sysArea);
sysArea.ObjectId = ResultHelper.NewId;
sysArea.CreateTime = ResultHelper.NowTime;
sysArea.ModificationTime = ResultHelper.NowTime;
SysArea sysArea1 = new SysArea();
sysArea1.ObjectId = "202008131744238122763d1e7363908";
LinqHelper.ModelTrans(sysAreaPost, sysArea1);
sysArea1.CreateTime = ResultHelper.NowTime;
sysArea1.ModificationTime = ResultHelper.NowTime;
SysArea sysArea2 = new SysArea();
LinqHelper.ModelTrans(sysAreaPost, sysArea2);
sysArea2.ObjectId = ResultHelper.NewId;
sysArea2.CreateTime = ResultHelper.NowTime;
sysArea2.ModificationTime = ResultHelper.NowTime;
sysAreaRepository.CreateTransaction(sysArea);
sysAreaRepository.CreateTransaction(sysArea1);
sysAreaRepository.CreateTransaction(sysArea2);
sysAreaRepository.TransactionCommit();
return(true);
}
catch (Exception ex)
{
ErrorMsg = "Create Error";
return(false);
}
}
protected override void On_ActionAdd(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtAreaName.Text))
{
txtMessage.InnerHtml = "区域名称不能为空!";
goto lbl_end;
}
int pid;
if (!int.TryParse(AreaPID, out pid) || pid < 0)
pid = 0;
SysArea area = new SysArea
{
AreaName = txtAreaName.Text.Trim( ),
Depth = string.Empty,
PId = pid,
AreaCode = txtCode.Text
};
if (string.IsNullOrEmpty(area.AreaCode))
{
txtCode.Text = GetAreaCode(area);
area.AreaCode = txtCode.Text;
}
area.Save( );
area.Depth = GetAreaDepth(area.Id, pid);
area.Save( );
this.txtMessage.InnerHtml = "新增成功!";
lbl_end:
On_ActionQuery(sender, e);
}
public void SubmitForm(SysArea areaEntity, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
areaEntity.FId = keyValue;
var LoginInfo = OperatorProvider.Provider.GetCurrent();
if (LoginInfo != null)
{
areaEntity.FLastModifyUserId = LoginInfo.UserId;
}
areaEntity.FLastModifyTime = DateTime.Now;
service.Update(areaEntity);
}
else
{
areaEntity.FId = Common.GuId();
var LoginInfo = OperatorProvider.Provider.GetCurrent();
if (LoginInfo != null)
{
areaEntity.FCreatorUserId = LoginInfo.UserId;
}
areaEntity.FCreatorTime = DateTime.Now;
service.Insert(areaEntity);
}
}
public int Edit(SysArea entity)
{
entity.EditTime = DateTime.Now;
entity.Editor = AuthenWidget.CurrentOperator?.UserId;
this.DbContext.SysArea.Attach(entity);
this.DbContext.Entry(entity).State = EntityState.Modified;
return(this.DbContext.SaveChanges() <= 0 ? OperationWidget.Failed : OperationWidget.Success);
}
//
// GET: /Platform/SysArea/Edit/5
public ActionResult Edit(string id)
{
var item = new SysArea();
if (!string.IsNullOrEmpty(id))
{
item = _SysAreaService.GetById(id);
}
return(View(item));
}
//
// GET: /Platform/SysArea/Edit/5
public ActionResult Edit(Guid?id)
{
var item = new SysArea();
if (id.HasValue)
{
item = _sysAreaService.GetById(id.Value);
}
return(View(item));
}
public void SubmitForm(SysArea SysArea, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
SysArea.Id = keyValue;
_Respository.Update(SysArea);
}
else
{
_Respository.Insert(SysArea);
}
}
public void create(SysArea area)
{
try
{
db.SysArea.Add(area);
db.SaveChanges();
}
catch (Exception ex)
{
LogUtil.Exception("ExceptionLogger", ex);
}
}
/// <summary>
/// 绑定主要浏览国家或城市
/// </summary>
private void BindCountrysOrCity()
{
//根据线路区域id获取线路区域实体
SysArea AreaModel = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetSysAreaModel(travelRangeId);
if (AreaModel != null)
{
//国际线,绑定主要浏览国家
if (travelRangeType == 1)
{
//主要浏览国家
if (AreaModel.VisitCity != null && AreaModel.VisitCity.Count > 0)
{
//根据主要浏览国家ID获取国家集合
IList <MSysCountry> lsCountry = EyouSoft.BLL.SystemStructure.BSysCountry.CreateInstance().GetCountryList(
AreaModel.VisitCity.Select(ls => ls.CountryId).ToArray()
);
if (lsCountry != null && lsCountry.Count > 0)
{
rpt_VisitingNational.DataSource = lsCountry;
rpt_VisitingNational.DataBind();
}
}
}
else
{
//主要浏览城市
if (AreaModel.VisitCity != null && AreaModel.VisitCity.Count > 0)
{
//城市信息
IList <SysCity> lsCity = EyouSoft.BLL.SystemStructure.SysCity.CreateInstance().GetSysCityList(
AreaModel.VisitCity.Where(ls => ls.CountyId == 0 && ls.CityId != 0).Select(ls => ls.CityId).ToArray()
);
//县的信息
IList <SysDistrictCounty> lsDistrictCounty = EyouSoft.BLL.SystemStructure.SysDistrictCounty.CreateInstance().GetDistrictCountyList(
AreaModel.VisitCity.Select(ls => ls.CountyId).ToArray()
);
//分别绑定
if (lsDistrictCounty != null && lsDistrictCounty.Count > 0)
{
rpt_districtCounty.DataSource = lsDistrictCounty;
rpt_districtCounty.DataBind();
}
if (lsCity != null && lsCity.Count > 0)
{
rpt_browseCitys.DataSource = lsCity;
rpt_browseCitys.DataBind();
}
}
}
}
}
public void SubmitForm(SysArea areaEntity, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
areaEntity.Modify(keyValue);
service.Update(areaEntity);
}
else
{
areaEntity.Create();
service.Insert(areaEntity);
}
}
/// <summary>
/// 获取县区
/// </summary>
/// <param name="areaid"></param>
/// <returns></returns>
private string GetArea(int areaid)
{
SysArea sysarea = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetSysAreaModel(areaid);
if (sysarea != null)
{
return(sysarea.AreaName);
}
else
{
return("");
}
}
public ActionResult Edit(Guid?id, SysArea collection)
{
if (!ModelState.IsValid)
{
return(View(collection));
}
_sysAreaService.Save(id, collection);
_unitOfWork.Commit();
return(RedirectToAction("Index"));
}
private TreeNode wrapTree(SysArea parent, List <SysArea> areas)
{
TreeNode result = new TreeNode();
result.id = Int64.Parse(parent.Code);
result.children = new List <TreeNode>();
result.state = "closed";
result.text = parent.Name;
foreach (SysArea sysArea in areas.Where(a => a.Parent == parent.Code && a.Parent != a.Code))
{
result.children.Add(wrapTree(sysArea, areas));
}
return(result);
}
public async Task <ActionResult> Edit(string id, SysArea collection)
{
if (!ModelState.IsValid)
{
Edit(id);
return(View(collection));
}
_SysAreaService.Save(id, collection);
await _unitOfWork.CommitAsync();
return(new EditSuccessResult(id));
}
void AreaView_CurrentChanged(object sender, EventArgs e)
{
CollectionView view = (CollectionView)sender;
if (view.CurrentItem != null)
{
this._selectedArea = (SysArea)view.CurrentItem;
this.FilteredProvinces.View.Refresh();
this.FilteredCities.View.Refresh();
}
else
{
this._selectedArea = null;
}
}
public string GetMemAddress(object province, object city, object county, object village, object address)
{
SysArea bllArea = new SysArea();
return(string.Concat(new string[]
{
bllArea.GetNameByID(int.Parse(province.ToString())),
"省",
bllArea.GetNameByID(int.Parse(city.ToString())),
"市",
bllArea.GetNameByID(int.Parse(county.ToString())),
bllArea.GetNameByID(int.Parse(village.ToString())),
address.ToString()
}));
}
public int Add(SysArea entity)
{
if (VerificationWidget.IsExit(nameof(SysArea), nameof(SysArea.AreaName), entity.AreaName, nameof(SysArea.AreaID), entity.AreaID))
{
return(OperationWidget.IsRepeated);
}
using (TransactionScope transaction = new TransactionScope())
{
if (handle.Add(entity) != OperationWidget.Success)
{
return(OperationWidget.Failed);
}
transaction.Complete();
return(OperationWidget.Success);
}
}
public int Add(SysArea entity)
{
entity.IsActive = (int)IsActive.否;
entity.Creator = AuthenWidget.CurrentOperator?.UserId;
entity.CreateTime = DateTime.Now;
entity.Editor = AuthenWidget.CurrentOperator?.UserId;
entity.EditTime = DateTime.Now;
this.DbContext.SysArea.Add(entity);
this.DbContext.Entry(entity).State = EntityState.Added;
if (this.DbContext.SaveChanges() <= 0)
{
return(OperationWidget.Failed);
}
return(OperationWidget.Success);
}
public int Edit(SysArea model)
{
if (VerificationWidget.IsExit(nameof(SysArea), nameof(SysArea.AreaName), model.AreaName, nameof(SysArea.AreaID), model.AreaID))
{
return(OperationWidget.IsRepeated);
}
SysArea entity = handle.Detail(model.AreaID);
using (TransactionScope transaction = new TransactionScope())
{
entity.AreaName = model.AreaName;
if (handle.Edit(entity) != OperationWidget.Success)
{
return(OperationWidget.Failed);
}
transaction.Complete();
return(OperationWidget.Success);
}
}
protected void BindDropDownList()
{
//线路类型
foreach (EnumObj item in EnumObj.GetList(typeof(AreaType)))
{
if (Utils.GetInt(item.Value) < 3)
{
this.DropSearchLineType.Items.Add(new ListItem(item.Text, item.Value));
}
}
this.DropSearchLineType.Items.Insert(0, new ListItem("线路类型", "-1"));
if (!string.IsNullOrEmpty(Areaid))
{
AreaType = "";
SysArea modelsysArea = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetSysAreaModel(Utils.GetInt(Areaid));
if (modelsysArea != null)
{
AreaType = ((int)modelsysArea.RouteType).ToString();
}
}
}
/// <summary>
/// update
/// </summary>
/// <param name="sysAreaPost">Model</param>
/// <param name="ErrorMsg">Result</param>
/// <returns></returns>
public bool Update(SysAreaPost sysAreaPost, ref string ErrorMsg)
{
try
{
SysArea sysArea = new SysArea();
LinqHelper.ModelTrans(sysAreaPost, sysArea);
sysArea.ModificationTime = ResultHelper.NowTime;
if (sysAreaRepository.EditNotNull(sysArea))
{
ErrorMsg = "Update Success";
return(true);
}
else
{
ErrorMsg = "Update Faild";
return(false);
}
}
catch (Exception ex)
{
ErrorMsg = "Update Error";
return(false);
}
}
//
// GET: /Platform/SysArea/Details/5
public ActionResult Details(Guid id)
{
SysArea item = _sysAreaService.GetById(id);
return(View(item));
}
private string GetAreaCode(SysArea area)
{
string result = string.Empty;
if (area == null || !string.IsNullOrEmpty(area.AreaCode))
goto label_return;
result = PinYin.GetChineseSpell(area.AreaName);
label_return:
return result;
}
private string GetAreaDepth(int id, int pID, SysArea pArea = null)
{
string sDepth = string.Format("/{0}/", id);
if (pID > 0)
{
pArea = pArea == null ? SysArea.FetchByID(pID) : pArea;
if (pArea != null)
sDepth = string.Format("{0}{1}/", pArea.Depth, id);
}
return sDepth;
}
private bool AreaIsExist(SysArea area)
{
bool isExist = false;
SysArea _area;
foreach (SuperTabItem item in areaContainer.Tabs)
{
if (item.Tag != null &&
((_area = item.Tag as SysArea) != null) &&
_area.Id == area.Id)
{
isExist = true;
break;
}
}
return isExist;
}
private void AddTab(SysArea area)
{
if (area.Id <= 0)
{
MessageBoxEx.Show("请选择商圈");
return;
}
if (AreaIsExist(area))
{
MessageBoxEx.Show("此商圈已经存在!");
return;
}
SuperTabItem item = new SuperTabItem( );
item.Tag = area;
item.Text = area.AreaName;
areaContainer.Tabs.Add(item);
}
public void Insert(string AreaName,int? PId,string Depth,string AreaCode)
{
SysArea item = new SysArea();
item.AreaName = AreaName;
item.PId = PId;
item.Depth = Depth;
item.AreaCode = AreaCode;
item.Save(UserName);
}
public void Update(int Id,string AreaName,int? PId,string Depth,string AreaCode)
{
SysArea item = new SysArea();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.AreaName = AreaName;
item.PId = PId;
item.Depth = Depth;
item.AreaCode = AreaCode;
item.Save(UserName);
}
public static IEnumerable<SysArea> LoadAreas( )
{
var rdr = DB.Select( ).From<SysArea>( ).ExecuteReader( );
using (rdr)
{
while (rdr.Read( ))
{
SysArea area = new SysArea( );
area.Load(rdr);
yield return area;
}
}
}
public static List<SysArea> GetAreasByDepths(string depth)
{
List<SysArea> areas = new List<SysArea>( );
if (string.IsNullOrEmpty(depth))
return areas;
string[] depths = depth.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (depths.Length > 0)
{
var query = DB.Select( ).From<SysArea>( ).Where(SysArea.DepthColumn).In(depths);
using (var dr = query.ExecuteReader( ))
{
while (dr.Read( ))
{
SysArea area = new SysArea( );
area.Load(dr);
areas.Add(area);
}
}
}
return areas;
}
public ActionResult SubmitForm(SysArea areaEntity, string keyValue)
{
areaApp.SubmitForm(areaEntity, keyValue);
return(Success("操作成功。"));
}
/// <summary>
/// 加载页面
/// </summary>
private void InitPage()
{
MPowderList model = EyouSoft.BLL.NewTourStructure.BPowderList.CreateInstance().GetModel(tourId);
companyid = model.Publishers;
if (!isAllUpdata)
{
//绑定团队状态
BindPowderTourStatus();
}
//绑定销售城市
SalesArea();
//绑定交通
BindTraffic();
//绑定线路区域主题
BindTheme();
if (model != null)
{
routeId = model.RouteId;
if (!isAllUpdata)
{
#region 团队报价标准
//出团时间
lbl_LeaveDate.Text = model.LeaveDate.ToString("yyyy-MM-dd");
//报名截止时间
txt_registrationEndDate.Text = model.RegistrationEndDate.ToString("yyyy-MM-dd");
//成人市场价
txt_retailAdultPrice.Text = Utils.FilterEndOfTheZeroDecimal(model.RetailAdultPrice);
//成人结算价
txt_settlementAudltPrice.Text = Utils.FilterEndOfTheZeroDecimal(model.SettlementAudltPrice);
//儿童市场价
txt_retailChildrenPrice.Text = Utils.FilterEndOfTheZeroDecimal(model.RetailChildrenPrice);
//儿童结算价
txt_settlementChildrenPrice.Text = Utils.FilterEndOfTheZeroDecimal(model.SettlementChildrenPrice);
//单房差
txt_marketPrice.Text = Utils.FilterEndOfTheZeroDecimal(model.MarketPrice);
//计划收客人数
txt_orderPeopleNum.Text = model.TourNum.ToString();
//是否显示余位
isShowMoreThan = model.IsLimit;
//余位
txt_moreThan.Text = model.MoreThan.ToString();
//留位
txt_saveNum.Text = model.SaveNum.ToString();
//航班出发时间
txt_startDate.Text = model.StartDate;
//航班返回时间
txt_endDate.Text = model.EndDate;
//集合说明时间
txt_setDec.Value = model.SetDec;
//领队全陪说明
txt_teamLeaderDec.Value = model.TeamLeaderDec;
//团队备注
txt_tourNotes.Value = model.TourNotes;
//团队状态
ddl_powderTourStatus.SelectedValue = ((int)model.PowderTourStatus).ToString();
//团队推荐
ddl_Status.SelectedValue = ((int)model.RecommendType).ToString();
//发布时间
litTime.Text = model.IssueTime.ToShortDateString();
//发布ip
litIP.Text = model.IP;
#endregion
}
#region 行程信息
//绑定出发返回城市
BindCity();
//专线名称
lbl_travelRangeName.Text = model.AreaName;
//线路名称
txt_LineName.Text = model.RouteName;
//发布商
txtPublishersName.Value = model.PublishersName;
//发布人
EyouSoft.Common.Function.MessageBox.ResponseScript(Page, "GetOperator('" + model.Publishers + "','" + model.OperatorId + "')");
//B2B显示控制
dropB2B.SelectedValue = ((int)model.B2B).ToString();
//B2C显示控制
dropB2C.SelectedValue = ((int)model.B2C).ToString();
//B2B排序值
txt_B2B.Value = model.B2BOrder.ToString();
//B2B排序值
txt_B2C.Value = model.B2COrder.ToString();
//绑定推荐状态
BindRecommendType(model.RecommendType == RecommendType.推荐);
//推荐状态
ddl_Status.SelectedValue = ((int)model.RecommendType).ToString();
//出发交通
ddl_DepartureTraffic.SelectedIndex = (int)model.StartTraffic - 1;
//返回交通
ddl_ReturnTraffic.SelectedIndex = (int)model.EndTraffic - 1;
//出发城市
hd_goCity.Value = model.StartCity + "|" + model.StartCityName;
//返回城市
hd_returnCity.Value = model.EndCity + "|" + model.EndCityName;
//线路特色
txt_LineFeatures.Value = model.Characteristic;
//住宿天数
txt_days.Text = model.Day.ToString();
//住宿夜数
txt_nights.Text = model.Late.ToString();
//简易版行程
txt_BriefnessTravel.Value = model.StandardStroke;
//散客报价
txt_FIT.Value = model.FitQuotation;
//销售须知
txt_Notes.Value = model.VendorsNotes;
//主题
hd_SubjectLine.Value = SetTheme(model.Themes);
//销售区域
hd_SellCity.Value = SetSalesArea(model.Citys);
#region 主要浏览
//主要浏览国家
SysArea AreaModel = EyouSoft.BLL.SystemStructure.SysArea.CreateInstance().GetSysAreaModel(model.AreaId);
if (AreaModel != null)
{
if (model.RouteType == AreaType.国际线)
{
if (model.BrowseCountrys != null && model.BrowseCountrys.Count > 0)
{
//主要浏览国家
if (AreaModel.VisitCity != null && AreaModel.VisitCity.Count > 0)
{
IList <MSysCountry> lsCountry = EyouSoft.BLL.SystemStructure.BSysCountry.CreateInstance().GetCountryList(
AreaModel.VisitCity.Select(ls => ls.CountryId).ToArray()
);
if (lsCountry != null && lsCountry.Count > 0)
{
rpt_VisitingNational.DataSource = lsCountry;
rpt_VisitingNational.DataBind();
}
}
citysOrCountrys = true;
int i = model.BrowseCountrys.Count;
string str = string.Empty, qzstr = string.Empty;
while (i-- > 0)
{
str += model.BrowseCountrys[i].CountryId + ",";
//签证信息
if (model.BrowseCountrys[i].IsVisa)
{
qzstr += model.BrowseCountrys[i].CountryId + ",";
}
}
if (qzstr.Length > 0)
{
hd_qz.Value = qzstr.Substring(0, qzstr.Length - 1);
}
hd_BrowseCountrys.Value = str.Substring(0, str.Length - 1);
}
//免签 直接显示免签
if (model.IsNotVisa)
{
chk_null.Checked = true;
hd_qz.Value = string.Empty;
}
//国际线路成人定金
txt_AdultDeposit.Text = model.AdultPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.AdultPrice);
//国际线路儿童定金
txt_ChildrenDeposit.Text = model.ChildrenPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.ChildrenPrice);
}
else
{
//主要浏览城市
if (AreaModel.VisitCity != null && AreaModel.VisitCity.Count > 0)
{
IList <SysCity> lsCity = EyouSoft.BLL.SystemStructure.SysCity.CreateInstance().GetSysCityList(
AreaModel.VisitCity.Where(ls => ls.CountyId == 0 && ls.CityId != 0).Select(ls => ls.CityId).ToArray()
);
IList <SysDistrictCounty> lsDistrictCounty = EyouSoft.BLL.SystemStructure.SysDistrictCounty.CreateInstance().GetDistrictCountyList(
AreaModel.VisitCity.Select(ls => ls.CountyId).ToArray()
);
if (lsDistrictCounty != null && lsDistrictCounty.Count > 0)
{
rpt_districtCounty.DataSource = lsDistrictCounty;
rpt_districtCounty.DataBind();
}
if (lsCity != null && lsCity.Count > 0)
{
rpt_browseCitys.DataSource = lsCity;
rpt_browseCitys.DataBind();
}
}
//主要浏览城市
if (model.BrowseCitys != null && model.BrowseCitys.Count > 0)
{
citysOrCountrys = false;
int i = model.BrowseCitys.Count;
string str = string.Empty;
while (i-- > 0)
{
if (model.BrowseCitys[i].CountyId > 0)
{
str += model.BrowseCitys[i].CountyId + "|" + model.BrowseCitys[i].CityId + ",";
}
else
{
str += model.BrowseCitys[i].CityId + ",";
}
}
hd_BrowseCitys.Value = str.Substring(0, str.Length - 1);
}
}
}
#endregion
//行程
if (model.StandardStroke.Length > 0)
{
txt_BriefnessTravel.Value = model.StandardStroke;
}
else
{
if (model.StandardPlans != null && model.StandardPlans.Count > 0)
{
isTravel = true;
rpt_standardPlans.DataSource = model.StandardPlans;
rpt_standardPlans.DataBind();
}
}
if (model.ServiceStandard != null)
{
//报价不包含
txt_PriceExcluding.Value = model.ServiceStandard.NotContainService;
//赠送项目
txt_GiftItems.Value = model.ServiceStandard.GiftInfo;
//儿童及其他安排
txt_OtherArr.Value = model.ServiceStandard.ChildrenInfo;
//购物安排
txt_ShoppingArr.Value = model.ServiceStandard.ShoppingInfo;
//自费项目
txt_ThisConsumption.Value = model.ServiceStandard.ExpenseItem;
//备注
txt_Remarks.Value = model.ServiceStandard.Notes;
//判断是否为团队
isServiceStandard = model.ServiceStandard.CarContent.Length > 0 || //用车
model.ServiceStandard.DinnerContent.Length > 0 || //用餐
model.ServiceStandard.ResideContent.Length > 0 || //住宿
model.ServiceStandard.SightContent.Length > 0 || //景点
model.ServiceStandard.TrafficContent.Length > 0 || //往返交通
model.ServiceStandard.GuideContent.Length > 0 || //导游
model.ServiceStandard.IncludeOtherContent.Length > 0; //其他包含
if (isServiceStandard)
{
this.AddStandardRoute_ServiceStandard.RouteServiceStandardInfo = model.ServiceStandard;
}
}
#endregion
}
}
public ActionResult SubmitForm(SysArea SysArea, string keyValue)
{
SysAreaService.SubmitForm(SysArea, keyValue);
return(Success("操作成功。"));
}
private string GetAreamSelectText(SysArea area)
{
string result = string.Empty;
for (int i = 0; i < area.Depth.Split(separator, StringSplitOptions.RemoveEmptyEntries).Length; i++)
result = string.Concat(result, LEVEL_NBSP);
return string.Concat(result, PREFIX, area.AreaName);
}
public void Create(SysArea area)
{
areaDal.create(area);
}
