public string AreaCategoryADD(T_OA_AREADIFFERENCE obj, string solutionsId, string companyId)
{
using (AreaCategoryBLL bll = new AreaCategoryBLL())
{
return(bll.AreaCategoryADD(obj, solutionsId, companyId));
}
}
public AreaForm(FormTypes type, string areaID, string solutionsId)
{
InitializeComponent();
TravelSolutionsId = solutionsId;
InitParas();
FormType = type;
if (string.IsNullOrEmpty(areaID))
{
area = new T_OA_AREADIFFERENCE();
area.AREADIFFERENCEID = Guid.NewGuid().ToString();
area.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.CREATEDATE = System.DateTime.Now;
area.UPDATEDATE = System.DateTime.Now;
area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
this.DataContext = area;
}
else
{
client.GetAreaCategoryByIDAsync(areaID);
}
}
public void AreaCategoryUpdate(T_OA_AREADIFFERENCE obj)
{
using (AreaCategoryBLL bll = new AreaCategoryBLL())
{
bll.AreaCategoryUpdate(obj);
}
}
public AreaSortForm(FormTypes type, string areaID, T_OA_TRAVELSOLUTIONS travelObj)
{
InitializeComponent();
solutionsObj = travelObj;
txtTravelSolutionName.Text = travelObj.PROGRAMMENAME;
this.Loaded += (o, e) =>
{
#region 原来的
InitParas();
this.areaID = areaID;
FormType = type;
if (string.IsNullOrEmpty(areaID))
{
area = new T_OA_AREADIFFERENCE();
area.AREADIFFERENCEID = Guid.NewGuid().ToString();
area.T_OA_TRAVELSOLUTIONS = solutionsObj;
area.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.CREATEDATE = System.DateTime.Now;
area.CREATECOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
area.CREATEDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
area.CREATEPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
area.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
area.OWNERCOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
area.OWNERDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
area.OWNERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.OWNERPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
area.UPDATEDATE = System.DateTime.Now;
area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
this.DataContext = area;
}
else
{
RefreshUI(RefreshedTypes.ShowProgressBar);
client.GetAreaCategoryByIDAsync(areaID);
}
#endregion
};
}
public AreaSortForm(FormTypes type, string areaID, T_OA_TRAVELSOLUTIONS travelObj)
{
InitializeComponent();
solutionsObj = travelObj;
txtTravelSolutionName.Text = travelObj.PROGRAMMENAME;
this.Loaded += (o, e) =>
{
#region 原来的
InitParas();
this.areaID = areaID;
FormType = type;
if (string.IsNullOrEmpty(areaID))
{
area = new T_OA_AREADIFFERENCE();
area.AREADIFFERENCEID = Guid.NewGuid().ToString();
area.T_OA_TRAVELSOLUTIONS = solutionsObj;
area.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.CREATEDATE = System.DateTime.Now;
area.CREATECOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
area.CREATEDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
area.CREATEPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
area.CREATEUSERNAME = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeName;
area.OWNERCOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
area.OWNERDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
area.OWNERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.OWNERPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
area.UPDATEDATE = System.DateTime.Now;
area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
this.DataContext = area;
}
else
{
RefreshUI(RefreshedTypes.ShowProgressBar);
client.GetAreaCategoryByIDAsync(areaID);
}
#endregion
};
}
/// <summary>
/// 获取地区
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void client_GetAreaWithPagingCompleted(object sender, GetAreaWithPagingCompletedEventArgs e)
{
if (e.Error != null)
{
Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(e.Error.Message));
return;
}
else
{
if (e.Result != null)
{
DtGridArea.ItemsSource = e.Result;
areaDifference = e.Result.ToList();
//dataPagerArea.PageCount = e.pageCount;
if (e.Result.Count() > 0)
{
currentArea = e.Result[0];
}
LoadCity();
}
}
}
public AreaForm(FormTypes type, string areaID, string solutionsId)
{
InitializeComponent();
TravelSolutionsId = solutionsId;
InitParas();
FormType = type;
if (string.IsNullOrEmpty(areaID))
{
area = new T_OA_AREADIFFERENCE();
area.AREADIFFERENCEID = Guid.NewGuid().ToString();
area.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
area.CREATEDATE = System.DateTime.Now;
area.UPDATEDATE = System.DateTime.Now;
area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
this.DataContext = area;
}
else
{
client.GetAreaCategoryByIDAsync(areaID);
}
}
public string AreaCategoryADD(T_OA_AREADIFFERENCE obj, string solutionsId, string companyId)
{
using (AreaCategoryBLL bll = new AreaCategoryBLL())
{
return bll.AreaCategoryADD(obj, solutionsId, companyId);
}
}
public void AreaCategoryUpdate(T_OA_AREADIFFERENCE obj)
{
using (AreaCategoryBLL bll = new AreaCategoryBLL())
{
bll.AreaCategoryUpdate(obj);
}
}
//选择城市分类
private void DtGridArea_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DtGridArea.SelectedItems.Count > 0)
{
currentArea = DtGridArea.SelectedItems[0] as T_OA_AREADIFFERENCE;
AreaID = currentArea.AREADIFFERENCEID;
this.RefreshUI(RefreshedTypes.ShowProgressBar);
client.GetAreaAllowanceByAreaIDAsync(AreaID, solutionsObj.TRAVELSOLUTIONSID);
}
}
private void StarCopy(T_OA_TRAVELSOLUTIONS solutionitem, T_OA_AREADIFFERENCE area, string strSourceSolutionId)
{
var checkArea = (from ent in dal.T_OA_AREADIFFERENCE
where ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == solutionitem.TRAVELSOLUTIONSID
&& ent.AREACATEGORY == area.AREACATEGORY + "(" + solutionitem.PROGRAMMENAME + ")"
select ent).FirstOrDefault();
//复制城市分类
T_OA_AREADIFFERENCE areaNew = new T_OA_AREADIFFERENCE();
if (checkArea != null)
{
areaNew = checkArea;
}
else
{
Utility.CloneEntity(area, areaNew);
areaNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
areaNew.AREACATEGORY = area.AREACATEGORY + "(" + solutionitem.PROGRAMMENAME + ")";
areaNew.AREADIFFERENCEID = Guid.NewGuid().ToString();
areaNew.CREATEDATE = DateTime.Now;
areaNew.OWNERCOMPANYID = solutionitem.OWNERCOMPANYID;
areaNew.CREATECOMPANYID = solutionitem.OWNERCOMPANYID;
areaNew.CREATEUSERID = "系统复制";
areaNew.CREATEUSERNAME = "******";
dal.AddToT_OA_AREADIFFERENCE(areaNew);//添加城市分类
dal.SaveChanges();
}
//1复制城市分类关联的城市
var cityall = (from ent in dal.T_OA_AREACITY
where ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == area.AREADIFFERENCEID
select ent).ToList();
foreach (var city in cityall)
{
var checkCity = (from ent in dal.T_OA_AREACITY
where ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == areaNew.AREADIFFERENCEID
&& ent.CITY == city.CITY
select ent).FirstOrDefault();
T_OA_AREACITY citynew = new T_OA_AREACITY();
if (checkCity != null)
{
citynew = checkCity;
}
else
{
Utility.CloneEntity(city, citynew);
citynew.AREACITYID = Guid.NewGuid().ToString();
citynew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
citynew.CREATEUSERID = "系统复制";
dal.AddToT_OA_AREACITY(citynew);//添加城市
}
}
//2.修改补帖分类 查找集团所有补贴
var allowanceOldAll = (from ent in dal.T_OA_TRAVELSOLUTIONS
join b in dal.T_OA_AREADIFFERENCE on ent.TRAVELSOLUTIONSID equals b.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID
join c in dal.T_OA_AREAALLOWANCE on b.AREADIFFERENCEID equals c.T_OA_AREADIFFERENCE.AREADIFFERENCEID
where ent.TRAVELSOLUTIONSID== strSourceSolutionId
&& b.AREADIFFERENCEID == area.AREADIFFERENCEID
select c).ToList();
if (allowanceOldAll != null)
{
foreach (var allowanceOld in allowanceOldAll)
{
var checkEnt = (from ent in dal.T_OA_AREAALLOWANCE
where ent.POSTLEVEL == allowanceOld.POSTLEVEL
&& ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID
== solutionitem.TRAVELSOLUTIONSID
&& ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == areaNew.AREADIFFERENCEID
select ent).FirstOrDefault();
if (checkEnt != null)//如果已经设置，直接拷贝并删除旧的
{
T_OA_AREAALLOWANCE allowanceNew = new T_OA_AREAALLOWANCE();
Utility.CloneEntity(checkEnt, allowanceNew);
allowanceNew.AREAALLOWANCEID = Guid.NewGuid().ToString();
allowanceNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
allowanceNew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
allowanceNew.CREATEDATE = DateTime.Now;
allowanceNew.CREATEUSERID = "系统复制";
dal.AddToT_OA_AREAALLOWANCE(allowanceNew);
dal.DeleteObject(checkEnt);
}
else
{
//如果没有补贴且集团已设置，拷贝
T_OA_AREAALLOWANCE allowanceNew = new T_OA_AREAALLOWANCE();
Utility.CloneEntity(allowanceOld, allowanceNew);
allowanceNew.AREAALLOWANCEID = Guid.NewGuid().ToString();
allowanceNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
allowanceNew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
allowanceNew.CREATEDATE = DateTime.Now;
allowanceNew.CREATEUSERID = "系统复制集团方案";
dal.AddToT_OA_AREAALLOWANCE(allowanceNew);
}
}
}
}
private void StarCopy(T_OA_TRAVELSOLUTIONS solutionitem, T_OA_AREADIFFERENCE area, string strSourceSolutionId)
{
var checkArea = (from ent in dal.T_OA_AREADIFFERENCE
where ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == solutionitem.TRAVELSOLUTIONSID &&
ent.AREACATEGORY == area.AREACATEGORY + "(" + solutionitem.PROGRAMMENAME + ")"
select ent).FirstOrDefault();
//复制城市分类
T_OA_AREADIFFERENCE areaNew = new T_OA_AREADIFFERENCE();
if (checkArea != null)
{
areaNew = checkArea;
}
else
{
Utility.CloneEntity(area, areaNew);
areaNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
areaNew.AREACATEGORY = area.AREACATEGORY + "(" + solutionitem.PROGRAMMENAME + ")";
areaNew.AREADIFFERENCEID = Guid.NewGuid().ToString();
areaNew.CREATEDATE = DateTime.Now;
areaNew.OWNERCOMPANYID = solutionitem.OWNERCOMPANYID;
areaNew.CREATECOMPANYID = solutionitem.OWNERCOMPANYID;
areaNew.CREATEUSERID = "系统复制";
areaNew.CREATEUSERNAME = "******";
dal.AddToT_OA_AREADIFFERENCE(areaNew);//添加城市分类
dal.SaveChanges();
}
//1复制城市分类关联的城市
var cityall = (from ent in dal.T_OA_AREACITY
where ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == area.AREADIFFERENCEID
select ent).ToList();
foreach (var city in cityall)
{
var checkCity = (from ent in dal.T_OA_AREACITY
where ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == areaNew.AREADIFFERENCEID &&
ent.CITY == city.CITY
select ent).FirstOrDefault();
T_OA_AREACITY citynew = new T_OA_AREACITY();
if (checkCity != null)
{
citynew = checkCity;
}
else
{
Utility.CloneEntity(city, citynew);
citynew.AREACITYID = Guid.NewGuid().ToString();
citynew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
citynew.CREATEUSERID = "系统复制";
dal.AddToT_OA_AREACITY(citynew);//添加城市
}
}
//2.修改补帖分类 查找集团所有补贴
var allowanceOldAll = (from ent in dal.T_OA_TRAVELSOLUTIONS
join b in dal.T_OA_AREADIFFERENCE on ent.TRAVELSOLUTIONSID equals b.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID
join c in dal.T_OA_AREAALLOWANCE on b.AREADIFFERENCEID equals c.T_OA_AREADIFFERENCE.AREADIFFERENCEID
where ent.TRAVELSOLUTIONSID == strSourceSolutionId &&
b.AREADIFFERENCEID == area.AREADIFFERENCEID
select c).ToList();
if (allowanceOldAll != null)
{
foreach (var allowanceOld in allowanceOldAll)
{
var checkEnt = (from ent in dal.T_OA_AREAALLOWANCE
where ent.POSTLEVEL == allowanceOld.POSTLEVEL &&
ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID
== solutionitem.TRAVELSOLUTIONSID &&
ent.T_OA_AREADIFFERENCE.AREADIFFERENCEID == areaNew.AREADIFFERENCEID
select ent).FirstOrDefault();
if (checkEnt != null)//如果已经设置，直接拷贝并删除旧的
{
T_OA_AREAALLOWANCE allowanceNew = new T_OA_AREAALLOWANCE();
Utility.CloneEntity(checkEnt, allowanceNew);
allowanceNew.AREAALLOWANCEID = Guid.NewGuid().ToString();
allowanceNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
allowanceNew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
allowanceNew.CREATEDATE = DateTime.Now;
allowanceNew.CREATEUSERID = "系统复制";
dal.AddToT_OA_AREAALLOWANCE(allowanceNew);
dal.DeleteObject(checkEnt);
}
else
{
//如果没有补贴且集团已设置，拷贝
T_OA_AREAALLOWANCE allowanceNew = new T_OA_AREAALLOWANCE();
Utility.CloneEntity(allowanceOld, allowanceNew);
allowanceNew.AREAALLOWANCEID = Guid.NewGuid().ToString();
allowanceNew.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", solutionitem.TRAVELSOLUTIONSID);
allowanceNew.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("SMT_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", areaNew.AREADIFFERENCEID);
allowanceNew.CREATEDATE = DateTime.Now;
allowanceNew.CREATEUSERID = "系统复制集团方案";
dal.AddToT_OA_AREAALLOWANCE(allowanceNew);
}
}
}
}
private void DtGridArea_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DtGridArea.SelectedItems.Count > 0)
{
currentArea = DtGridArea.SelectedItems[0] as T_OA_AREADIFFERENCE;
AreaID = currentArea.AREADIFFERENCEID;
LoadCity();
}
}
/// <summary>
/// 获取地区
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void client_GetAreaWithPagingCompleted(object sender, GetAreaWithPagingCompletedEventArgs e)
{
if (e.Error != null)
{
Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(e.Error.Message));
return;
}
else
{
if (e.Result != null)
{
DtGridArea.ItemsSource = e.Result;
areaDifference = e.Result.ToList();
//dataPagerArea.PageCount = e.pageCount;
if (e.Result.Count() > 0)
{
currentArea = e.Result[0];
}
LoadCity();
}
}
}
