/// <summary>
/// 添加时初始化 交通工具的行信息
/// </summary>
private void IninAddVechile(bool IsFirst)
{
T_OA_TAKETHESTANDARDTRANSPORT transport = new T_OA_TAKETHESTANDARDTRANSPORT();
transport.TAKETHESTANDARDTRANSPORTID = System.Guid.NewGuid().ToString();
transport.CREATEDATE = DateTime.Today;
StandardList.Add(transport);
DGVechileStandard.ItemsSource = StandardList;
if(IsFirst)
DGVechileStandard.SelectedIndex = 0;
}
/// <summary>
/// 复制出差方案
/// </summary>
/// <param name="EntObj">方案实体</param>
/// <param name="OldtravleSolutionId">旧方案ID</param>
/// <param name="companyids">公司ID</param>
/// <returns></returns>
public string GetCopyTravleSolution(T_OA_TRAVELSOLUTIONS EntObj, string OldtravleSolutionId)
{
string StrReturn = string.Empty;
try
{
dal.BeginTransaction();
//添加方案信息
int i = dal.Add(EntObj);
if (i > 0)
{
//根据出差方案ID查询出交通工具标准
var ents = from a in dal.GetObjects <T_OA_TAKETHESTANDARDTRANSPORT>().Include("T_OA_TRAVELSOLUTIONS")
where a.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == OldtravleSolutionId
select a;
if (ents.Count() > 0)
{
foreach (T_OA_TAKETHESTANDARDTRANSPORT obj in ents)
{
T_OA_TAKETHESTANDARDTRANSPORT tent = new T_OA_TAKETHESTANDARDTRANSPORT();
tent.TAKETHESTANDARDTRANSPORTID = System.Guid.NewGuid().ToString();
tent.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", EntObj.TRAVELSOLUTIONSID);
tent.ENDPOSTLEVEL = obj.ENDPOSTLEVEL;
tent.TYPEOFTRAVELTOOLS = obj.TYPEOFTRAVELTOOLS;
tent.TAKETHETOOLLEVEL = obj.TAKETHETOOLLEVEL;
tent.OWNERCOMPANYID = EntObj.OWNERCOMPANYID;
tent.OWNERDEPARTMENTID = EntObj.OWNERDEPARTMENTID;
tent.OWNERPOSTID = EntObj.OWNERPOSTID;
tent.CREATEUSERID = EntObj.CREATEUSERID;
tent.CREATEDATE = System.DateTime.Now;
dal.AddToContext(tent);
}
//将出差方案应用到当前公司
T_OA_PROGRAMAPPLICATIONS pent = new T_OA_PROGRAMAPPLICATIONS();
pent.PROGRAMAPPLICATIONSID = System.Guid.NewGuid().ToString();
pent.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", EntObj.TRAVELSOLUTIONSID);
pent.COMPANYID = EntObj.OWNERCOMPANYID;
pent.CREATEUSERID = EntObj.CREATEUSERID;
pent.OWNERCOMPANYID = EntObj.CREATECOMPANYID;
pent.OWNERDEPARTMENTID = EntObj.CREATEDEPARTMENTID;
pent.OWNERPOSTID = EntObj.CREATEPOSTID;
pent.CREATEDATE = System.DateTime.Now;
dal.Add(pent);
}
//根据出差方案ID查询城市分类
var area = from a in dal.GetObjects <T_OA_AREADIFFERENCE>().Include("T_OA_TRAVELSOLUTIONS")
where a.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == OldtravleSolutionId
select a;
if (area.Count() > 0)
{
foreach (T_OA_AREADIFFERENCE obj in area)
{
// T_OA_AREADIFFERENCE aread = new T_OA_AREADIFFERENCE();
// aread.AREADIFFERENCEID = System.Guid.NewGuid().ToString();//城市分类ID
// aread.T_OA_TRAVELSOLUTIONSReference.EntityKey =
// new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", EntObj.TRAVELSOLUTIONSID);//方案ID
// aread.AREACATEGORY = obj.AREACATEGORY;//城市分类名
// aread.AREAINDEX = obj.AREAINDEX;//分类序号
// aread.OWNERCOMPANYID = EntObj.OWNERCOMPANYID;//所属公司
// aread.OWNERDEPARTMENTID = EntObj.OWNERDEPARTMENTID;//所属部门
// aread.OWNERPOSTID = EntObj.OWNERPOSTID;//所属岗位
// aread.OWNERID = EntObj.OWNERID;//所属人ID
// aread.CREATEUSERID = EntObj.CREATEUSERID;//创建人
// aread.CREATEUSERNAME = EntObj.CREATEUSERNAME;//创建人姓名
// aread.CREATECOMPANYID = EntObj.CREATECOMPANYID;//创建公司
// aread.CREATEDEPARTMENTID = EntObj.CREATEDEPARTMENTID;//创建部门
// aread.CREATEPOSTID = EntObj.CREATEPOSTID;//创建岗位
// aread.CREATEDATE = System.DateTime.Now;//创建时间
// int add = dal.Add(aread);
//if (add > 0)
//{
//根据城市分类ID、方案ID查询补贴标准
var areace = from a in dal.GetObjects <T_OA_AREAALLOWANCE>().Include("T_OA_AREADIFFERENCE").Include("T_OA_TRAVELSOLUTIONS")
where a.T_OA_AREADIFFERENCE.AREADIFFERENCEID == obj.AREADIFFERENCEID &&
a.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == OldtravleSolutionId
select a;
foreach (T_OA_AREAALLOWANCE obje in areace)
{
T_OA_AREAALLOWANCE areadce = new T_OA_AREAALLOWANCE();
areadce.AREAALLOWANCEID = System.Guid.NewGuid().ToString(); //分类补贴ID
areadce.T_OA_AREADIFFERENCEReference.EntityKey =
new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", obj.AREADIFFERENCEID); //分类ID
areadce.T_OA_TRAVELSOLUTIONSReference.EntityKey =
new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_TRAVELSOLUTIONS", "TRAVELSOLUTIONSID", EntObj.TRAVELSOLUTIONSID); //方案ID
areadce.POSTLEVEL = obje.POSTLEVEL; //岗位等级
areadce.ACCOMMODATION = obje.ACCOMMODATION; //住宿补贴
areadce.TRANSPORTATIONSUBSIDIES = obje.TRANSPORTATIONSUBSIDIES; //交通伙食补贴
areadce.OWNERCOMPANYID = EntObj.OWNERCOMPANYID; //所属公司
areadce.OWNERDEPARTMENTID = EntObj.OWNERDEPARTMENTID; //所属部门
areadce.OWNERPOSTID = EntObj.OWNERPOSTID; //所属岗位
areadce.OWNERID = EntObj.OWNERID; //所属人ID
areadce.CREATEUSERID = EntObj.CREATEUSERID; //创建人
areadce.CREATEDATE = System.DateTime.Now; //创建时间
dal.AddToContext(areadce);
}
////根据城市分类ID查询分类城市
//var areacity = from a in dal.GetObjects<T_OA_AREACITY>().Include("T_OA_AREADIFFERENCE")
// where a.T_OA_AREADIFFERENCE.AREADIFFERENCEID == obj.AREADIFFERENCEID
// select a;
//foreach (T_OA_AREACITY objc in areacity)
//{
// T_OA_AREACITY arctiy = new T_OA_AREACITY();
// arctiy.AREACITYID = System.Guid.NewGuid().ToString();//分类城市ID
// arctiy.T_OA_AREADIFFERENCEReference.EntityKey =
// new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_OA_AREADIFFERENCE", "AREADIFFERENCEID", aread.AREADIFFERENCEID);//分类ID
// arctiy.CITY = objc.CITY;//所在地城市
// arctiy.CREATEUSERID = EntObj.CREATEUSERID;//创建人
// arctiy.CREATEDATE = System.DateTime.Now;//创建时间
// dal.AddToContext(arctiy);
//}
}
//}
}
int n = dal.SaveContextChanges();
if (i > 0 && n > 0)
{
dal.CommitTransaction();
}
else
{
StrReturn = "ERROR";
dal.RollbackTransaction();
}
}
}
catch (Exception ex)
{
dal.RollbackTransaction();
Tracer.Debug("出差方案TravleSolutionBLL-AddTravleSolution" + System.DateTime.Now.ToString() + " " + ex.ToString());
StrReturn = "ERROR";
}
return(StrReturn);
}
private void DgVechileStandard_LoadingRow(object sender, DataGridRowEventArgs e)
{
if (DGVechileStandard.ItemsSource != null)
{
T_OA_TAKETHESTANDARDTRANSPORT Standard = (T_OA_TAKETHESTANDARDTRANSPORT)e.Row.DataContext;
TravelDictionaryComboBox ComVechile = DGVechileStandard.Columns[1].GetCellContent(e.Row).FindName("ComVechileType") as TravelDictionaryComboBox;
TravelDictionaryComboBox ComLevel = DGVechileStandard.Columns[2].GetCellContent(e.Row).FindName("ComVechileTypeLeve") as TravelDictionaryComboBox;
SelectPost EndComPost = DGVechileStandard.Columns[3].GetCellContent(e.Row).FindName("txtSelectPost") as SelectPost;
DGVechileStandard.SelectedItem = e.Row;
string dictid = "";
if (ComVechile != null)
{
foreach (T_SYS_DICTIONARY Region in ComVechile.Items)
{
if (Region.DICTIONARYVALUE.ToString() == Standard.TYPEOFTRAVELTOOLS)
{
ComVechile.SelectedItem = Region;
dictid = Region.DICTIONARYID;
break;
}
}
}
if (ComVechile.SelectedIndex < 0)
{
ComVechile.SelectedIndex = 0;
}
if (ComLevel != null)
{
var ents = from ent in ListVechileLevel
where ent.T_SYS_DICTIONARY2.DICTIONARYID == dictid
select ent;
if (ents.Count() > 0)
{
ComLevel.ItemsSource = ents.ToList();//根据类型绑定级别
foreach (T_SYS_DICTIONARY Region in ents)
{
if (Region.DICTIONARYVALUE.ToString() == Standard.TAKETHETOOLLEVEL)
{
ComLevel.SelectedItem = Region;
break;
}
}
}
}
if (ComLevel.SelectedIndex < 0)
{
ComLevel.SelectedIndex = 0;
}
if (!string.IsNullOrEmpty(Standard.ENDPOSTLEVEL))
{
//将 岗位值转换为对应的名称
//string PostCode = EndComPost.TxtSelectedPost.Text;
string PostCode = "";
string[] arrstr = Standard.ENDPOSTLEVEL.Split(',');
foreach (var d in arrstr)
{
int i = d.ToInt32();
var ents = from n in ListPost
where n.DICTIONARYVALUE == i
select n;
if (ents.Count() > 0)
{
PostCode += ents.FirstOrDefault().DICTIONARYNAME.ToString() + ",";
}
}
if (!(string.IsNullOrEmpty(PostCode)))
{
PostCode = PostCode.Substring(0, PostCode.Length - 1);
}
EndComPost.TxtSelectedPost.Text = PostCode;
}
//}
}
}
private void NewStandardDetail()
{
T_OA_TAKETHESTANDARDTRANSPORT AddStandardObj = new T_OA_TAKETHESTANDARDTRANSPORT();
AddStandardObj.TAKETHESTANDARDTRANSPORTID = Guid.NewGuid().ToString();
AddStandardObj.T_OA_TRAVELSOLUTIONS = travelObj;
//StandardObj.ENDPOSTLEVEL = StandardList[DGVechileStandard.SelectedIndex].ENDPOSTLEVEL;//结束岗位级别
//StandardObj.TYPEOFTRAVELTOOLS = StandardList[DGVechileStandard.SelectedIndex].TYPEOFTRAVELTOOLS;//乘坐类型
//StandardObj.TAKETHETOOLLEVEL = StandardList[DGVechileStandard.SelectedIndex].TAKETHETOOLLEVEL;//乘坐级别
this.StandardList.Add(AddStandardObj);
this.DGVechileStandard.ItemsSource = StandardList;
AddStandardObj.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(Standard_PropertyChanged);
}
void client_GetVechileStandardAndPlaneLineCompleted(object sender, GetVechileStandardAndPlaneLineCompletedEventArgs e)
{
RefreshUI(RefreshedTypes.HideProgressBar);
OldStandardList.Clear();
try
{
if (!e.Cancelled)
{
if (e.Error == null)
{
if (e.VechileStandardList.Count() > 0 && (e.UserState=="DefaultSolution" || isChange==true))
{
//OldStandardList = e.VechileStandardList.ToList();
e.VechileStandardList.ToList().ForEach(item =>
{
T_OA_TAKETHESTANDARDTRANSPORT Sport = new T_OA_TAKETHESTANDARDTRANSPORT();
Sport.TAKETHESTANDARDTRANSPORTID = item.TAKETHESTANDARDTRANSPORTID;
Sport.T_OA_TRAVELSOLUTIONS = item.T_OA_TRAVELSOLUTIONS;
Sport.TAKETHETOOLLEVEL = item.TAKETHETOOLLEVEL;
Sport.TYPEOFTRAVELTOOLS = item.TYPEOFTRAVELTOOLS;
Sport.ENDPOSTLEVEL = item.ENDPOSTLEVEL;
Sport.CREATEDATE = item.CREATEDATE;
Sport.CREATEUSERID = item.CREATEUSERID;
Sport.UPDATEDATE = item.UPDATEDATE;
Sport.UPDATEUSERID = item.UPDATEUSERID;
Sport.EntityKey = item.EntityKey;
if (OldStandardList.Count() > 0)
{
var ents = from ent in OldStandardList
where ent.ENDPOSTLEVEL == item.ENDPOSTLEVEL && ent.TAKETHETOOLLEVEL == item.TAKETHETOOLLEVEL
&& ent.TYPEOFTRAVELTOOLS == item.TYPEOFTRAVELTOOLS && ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == item.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID
&& ent.TAKETHESTANDARDTRANSPORTID == item.TAKETHESTANDARDTRANSPORTID
select ent;
if (ents.Count() == 0)
OldStandardList.Add(Sport);
}
else
{
OldStandardList.Add(Sport);
}
});
StandardList = e.VechileStandardList;
StandardBindDataGrid(StandardList, false);
}
else
{
DGVechileStandard.ItemsSource = null;
StandardList.Clear();
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
private void NewStandardDetail()
{
T_OA_TAKETHESTANDARDTRANSPORT AddStandardObj = new T_OA_TAKETHESTANDARDTRANSPORT();
AddStandardObj.TAKETHESTANDARDTRANSPORTID = Guid.NewGuid().ToString();
AddStandardObj.T_OA_TRAVELSOLUTIONS = travelObj;
AddStandardObj.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
AddStandardObj.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
AddStandardObj.CREATEDATE = DateTime.Now;
AddStandardObj.UPDATEDATE = DateTime.Now;
AddStandardObj.OWNERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
AddStandardObj.OWNERPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID;
AddStandardObj.OWNERDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID;
AddStandardObj.OWNERCOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID;
this.StandardList.Add(AddStandardObj);
DGVechileStandard.ItemsSource = StandardList;
}
