public void AreaCityAdd(T_OA_AREACITY obj) { using (AreaAllowanceBll bll = new AreaAllowanceBll()) { bll.AreaCityAdd(obj); } }
private void InitParas() { areacity = new T_OA_AREACITY(); client = new SmtOAPersonOfficeClient(); client.GetAreaCategoryByIDCompleted += new EventHandler <GetAreaCategoryByIDCompletedEventArgs>(client_GetAreaCategoryByIDCompleted); client.AreaCategoryADDCompleted += new EventHandler <AreaCategoryADDCompletedEventArgs>(client_AreaCategoryADDCompleted); client.AreaCategoryUpdateCompleted += new EventHandler <System.ComponentModel.AsyncCompletedEventArgs>(client_AreaCategoryUpdateCompleted); client.AreaCityCheckCompleted += new EventHandler <AreaCityCheckCompletedEventArgs>(client_AreaCityCheckCompleted); client.AreaCityByCategoryDeleteCompleted += new EventHandler <AreaCityByCategoryDeleteCompletedEventArgs>(client_AreaCityByCategoryDeleteCompleted); client.AreaCityAddCompleted += new EventHandler <System.ComponentModel.AsyncCompletedEventArgs>(client_AreaCityAddCompleted); client.AreaCityLotsofAddCompleted += new EventHandler <AreaCityLotsofAddCompletedEventArgs>(client_AreaCityLotsofAddCompleted); client.GetAreaCityByCategoryCompleted += new EventHandler <GetAreaCityByCategoryCompletedEventArgs>(client_GetAreaCityByCategoryCompleted); }
void client_GetQueryPlanCityCompleted(object sender, GetQueryPlanCityCompletedEventArgs e) { try { allowQueryAreaCity = true; this.RefreshUI(RefreshedTypes.HideProgressBar); if (!e.Cancelled) { if (e.Result != null) { if (e.ListAREADIFFERENCE.Count() > 0) { DtGridArea.ItemsSource = e.ListAREADIFFERENCE; ShowProgressBasePage(); client.GetAreaCityByCategoryAsync(e.ListAREADIFFERENCE.FirstOrDefault().AREADIFFERENCEID); } else { DtGridArea.ItemsSource = null; DtGridCity.ItemsSource = null; } if (e.Result.Count() > 0) { e.Result.ToList().ForEach(item => { T_OA_AREACITY Sport = new T_OA_AREACITY(); Sport.AREACITYID = item.AREACITYID; //Sport.T_OA_AREADIFFERENCE.AREADIFFERENCEID = item.T_OA_AREADIFFERENCE.AREADIFFERENCEID; Sport.CITY = item.CITY; Sport.CREATEDATE = item.CREATEDATE; Sport.CREATEUSERID = item.CREATEUSERID; Sport.UPDATEDATE = item.UPDATEDATE; Sport.UPDATEUSERID = item.UPDATEUSERID; Sport.EntityKey = item.EntityKey; }); } } else { DtGridArea.ItemsSource = null; DtGridCity.ItemsSource = null; } } } catch (Exception ex) { Utility.SetLogAndShowLog(ex.ToString()); } }
void client_GetQueryPlanCityCompleted(object sender, GetQueryPlanCityCompletedEventArgs e) { try { if (!e.Cancelled) { if (e.Result != null) { if (e.Result.Count() > 0) { e.Result.ToList().ForEach(item => { T_OA_AREACITY Sport = new T_OA_AREACITY(); Sport.AREACITYID = item.AREACITYID; //Sport.T_OA_AREADIFFERENCE.AREADIFFERENCEID = item.T_OA_AREADIFFERENCE.AREADIFFERENCEID; Sport.CITY = item.CITY; Sport.CREATEDATE = item.CREATEDATE; Sport.CREATEUSERID = item.CREATEUSERID; Sport.UPDATEDATE = item.UPDATEDATE; Sport.UPDATEUSERID = item.UPDATEUSERID; Sport.EntityKey = item.EntityKey; }); if (e.ListAREADIFFERENCE.Count() > 0) { if (DtGridArea.ItemsSource == null) { DtGridArea.ItemsSource = e.ListAREADIFFERENCE; } client.GetAreaCityByCategoryAsync(e.ListAREADIFFERENCE.FirstOrDefault().AREADIFFERENCEID); } } else { // cmbSolution.ItemsSource = null; } } } } catch (Exception ex) { Utility.SetLogAndShowLog(ex.ToString()); } }
public void Save() { RefreshUI(RefreshedTypes.ShowProgressBar); List <SMT.SaaS.FrameworkUI.Validator.ValidatorBase> validators = Group1.ValidateAll(); if (validators.Count > 0) { //could use the content of the list to show an invalid message summary somehow // Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), validators.Count.ToString() + " invalid validators"); RefreshUI(RefreshedTypes.HideProgressBar); return; } else { GetChangedList(citycode, ExistedCode); citys.Clear(); //string[] codes = citycode.Split(','); //by luojie 增加城市组 if (!string.IsNullOrEmpty(AddCode)) { string[] codes = AddCode.Split(','); foreach (string code in codes) { if (!string.IsNullOrEmpty(code)) { T_OA_AREACITY temp = new T_OA_AREACITY(); temp.AREACITYID = Guid.NewGuid().ToString(); temp.T_OA_AREADIFFERENCE = area; //temp.T_OA_AREADIFFERENCE = new T_OA_AREADIFFERENCE(); //temp.T_OA_AREADIFFERENCE.AREADIFFERENCEID = area.AREADIFFERENCEID; //temp.T_OA_AREADIFFERENCEReference.EntityKey = area.AREADIFFERENCEID; temp.CITY = code; citys.Add(temp); } } } if (AddCode != null || DelCode != null || formType == FormTypes.New) { if (FormType == FormTypes.Edit) { area.UPDATEDATE = System.DateTime.Now; area.UPDATEUSERID = Common.CurrentLoginUserInfo.EmployeeID; area.UPDATEUSERNAME = Common.CurrentLoginUserInfo.UserPosts[0].CompanyName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].DepartmentName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].PostName + "-" + Common.CurrentLoginUserInfo.EmployeeName; client.AreaCategoryUpdateAsync(area); } else { area.UPDATEDATE = System.DateTime.Now; area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; area.UPDATEUSERNAME = area.UPDATEUSERNAME = Common.CurrentLoginUserInfo.UserPosts[0].CompanyName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].DepartmentName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].PostName + "-" + Common.CurrentLoginUserInfo.EmployeeName; client.AreaCategoryADDAsync(area, solutionsObj.TRAVELSOLUTIONSID, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } } else { RefreshUI(RefreshedTypes.HideProgressBar); Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("未作修改")); } } }
private void InitParas() { areacity = new T_OA_AREACITY(); client = new SmtOAPersonOfficeClient(); client.GetAreaCategoryByIDCompleted += new EventHandler<GetAreaCategoryByIDCompletedEventArgs>(client_GetAreaCategoryByIDCompleted); client.AreaCategoryADDCompleted += new EventHandler<AreaCategoryADDCompletedEventArgs>(client_AreaCategoryADDCompleted); client.AreaCategoryUpdateCompleted += new EventHandler<System.ComponentModel.AsyncCompletedEventArgs>(client_AreaCategoryUpdateCompleted); client.AreaCityCheckCompleted += new EventHandler<AreaCityCheckCompletedEventArgs>(client_AreaCityCheckCompleted); client.AreaCityByCategoryDeleteCompleted += new EventHandler<AreaCityByCategoryDeleteCompletedEventArgs>(client_AreaCityByCategoryDeleteCompleted); client.AreaCityAddCompleted += new EventHandler<System.ComponentModel.AsyncCompletedEventArgs>(client_AreaCityAddCompleted); client.AreaCityLotsofAddCompleted += new EventHandler<AreaCityLotsofAddCompletedEventArgs>(client_AreaCityLotsofAddCompleted); client.GetAreaCityByCategoryCompleted += new EventHandler<GetAreaCityByCategoryCompletedEventArgs>(client_GetAreaCityByCategoryCompleted); }
public void Save() { RefreshUI(RefreshedTypes.ShowProgressBar); List<SMT.SaaS.FrameworkUI.Validator.ValidatorBase> validators = Group1.ValidateAll(); if (validators.Count > 0) { //could use the content of the list to show an invalid message summary somehow // Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), validators.Count.ToString() + " invalid validators"); RefreshUI(RefreshedTypes.HideProgressBar); return; } else { GetChangedList(citycode, ExistedCode); citys.Clear(); //string[] codes = citycode.Split(','); //by luojie 增加城市组 if (!string.IsNullOrEmpty(AddCode)) { string[] codes = AddCode.Split(','); foreach (string code in codes) { if (!string.IsNullOrEmpty(code)) { T_OA_AREACITY temp = new T_OA_AREACITY(); temp.AREACITYID = Guid.NewGuid().ToString(); temp.T_OA_AREADIFFERENCE = area; //temp.T_OA_AREADIFFERENCE = new T_OA_AREADIFFERENCE(); //temp.T_OA_AREADIFFERENCE.AREADIFFERENCEID = area.AREADIFFERENCEID; //temp.T_OA_AREADIFFERENCEReference.EntityKey = area.AREADIFFERENCEID; temp.CITY = code; citys.Add(temp); } } } if (AddCode != null || DelCode != null || formType==FormTypes.New) { if (FormType == FormTypes.Edit) { area.UPDATEDATE = System.DateTime.Now; area.UPDATEUSERID = Common.CurrentLoginUserInfo.EmployeeID; area.UPDATEUSERNAME = Common.CurrentLoginUserInfo.UserPosts[0].CompanyName+"-"+ Common.CurrentLoginUserInfo.UserPosts[0].DepartmentName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].PostName + "-" + Common.CurrentLoginUserInfo.EmployeeName; client.AreaCategoryUpdateAsync(area); } else { area.UPDATEDATE = System.DateTime.Now; area.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; area.UPDATEUSERNAME = area.UPDATEUSERNAME = Common.CurrentLoginUserInfo.UserPosts[0].CompanyName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].DepartmentName + "-" + Common.CurrentLoginUserInfo.UserPosts[0].PostName + "-" + Common.CurrentLoginUserInfo.EmployeeName; client.AreaCategoryADDAsync(area, solutionsObj.TRAVELSOLUTIONSID, Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); } } else { RefreshUI(RefreshedTypes.HideProgressBar); Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("未作修改")); } } }
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); } } } }
void client_GetQueryPlanCityCompleted(object sender, GetQueryPlanCityCompletedEventArgs e) { try { if (!e.Cancelled) { if (e.Result != null) { if (e.Result.Count() > 0) { e.Result.ToList().ForEach(item => { T_OA_AREACITY Sport = new T_OA_AREACITY(); Sport.AREACITYID = item.AREACITYID; //Sport.T_OA_AREADIFFERENCE.AREADIFFERENCEID = item.T_OA_AREADIFFERENCE.AREADIFFERENCEID; Sport.CITY = item.CITY; Sport.CREATEDATE = item.CREATEDATE; Sport.CREATEUSERID = item.CREATEUSERID; Sport.UPDATEDATE = item.UPDATEDATE; Sport.UPDATEUSERID = item.UPDATEUSERID; Sport.EntityKey = item.EntityKey; }); if (e.ListAREADIFFERENCE.Count() > 0) { if(DtGridArea.ItemsSource==null) DtGridArea.ItemsSource = e.ListAREADIFFERENCE; client.GetAreaCityByCategoryAsync(e.ListAREADIFFERENCE.FirstOrDefault().AREADIFFERENCEID); } } else { // cmbSolution.ItemsSource = null; } } } } catch (Exception ex) { Utility.SetLogAndShowLog(ex.ToString()); } }