public string GetCompanyID() { MasterDataBLL mdBLL = new MasterDataBLL(); OUTreeBLL otBLL = new OUTreeBLL(); AuthorizationDS.PositionRow rowPosition = (AuthorizationDS.PositionRow)Session["Position"]; AuthorizationDS.OrganizationUnitRow rowOU = GetNearestCostCenter(rowPosition.OrganizationUnitId); MasterData.CostCenterRow rowCostCenter = mdBLL.GetCostCenterById(rowOU.CostCenterID); return rowCostCenter.CompanyID.ToString(); }
public AuthorizationDS.OrganizationUnitRow GetNearestCostCenter(int OUID) { OUTreeBLL otBLL = new OUTreeBLL(); AuthorizationDS.OrganizationUnitRow rowOU = otBLL.GetOrganizationUnitById(OUID); if (rowOU.IsCostCenterIDNull()) { return GetNearestCostCenter(rowOU.ParentOrganizationUnitId); } else { return rowOU; } }
/// <summary> /// 设置职务的系统角色 /// </summary> /// <param name="positionId"></param> /// <param name="systemRoleIds"></param> public void SetPositionSystemRole(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int positionId, int[] systemRoleIds) { StringBuilder oldContent = new StringBuilder(); StringBuilder newContent = new StringBuilder(); BusinessObjects.AuthorizationDS.PositionAndSystemRoleDataTable table = this.PositionAndSystemRoleTA.GetDataByPositionId(positionId); List <int> roleIds = new List <int>(systemRoleIds); foreach (BusinessObjects.AuthorizationDS.PositionAndSystemRoleRow positionAndSystemRole in table) { if (roleIds.Contains(positionAndSystemRole.SystemRoleId)) { roleIds.Remove(positionAndSystemRole.SystemRoleId); } else { oldContent.Append("[").Append(this.SystemRoleTA.GetSystemRoleName(positionAndSystemRole.SystemRoleId)).Append("] "); positionAndSystemRole.Delete(); } } foreach (int roleId in roleIds) { BusinessObjects.AuthorizationDS.PositionAndSystemRoleRow newRow = table.NewPositionAndSystemRoleRow(); newRow.PositionId = positionId; newRow.SystemRoleId = roleId; newContent.Append("[").Append(this.SystemRoleTA.GetSystemRoleName(roleId)).Append("] "); table.AddPositionAndSystemRoleRow(newRow); } this.PositionAndSystemRoleTA.Update(table); if (oldContent.Length > 0 || newContent.Length > 0) { AuthorizationConfigure authorizationConfigure = new AuthorizationConfigure(); authorizationConfigure.StuffId = stuffUser.StuffId; authorizationConfigure.StuffName = stuffUser.StuffName; authorizationConfigure.ConfigureTarget = "职务权限设置"; authorizationConfigure.ConfigureTime = DateTime.Now; authorizationConfigure.ConfigureType = "更新"; string positionName = new OUTreeBLL().GetPositionById(positionId).PositionName; if (oldContent.Length > 0) { oldContent.Insert(0, "撤销职务[" + positionName + "]的系统角色:"); authorizationConfigure.OldContent = oldContent.ToString(); } if (newContent.Length > 0) { newContent.Insert(0, "新增职务[" + positionName + "]的系统角色:"); authorizationConfigure.NewContent = newContent.ToString(); } SysLog.LogAuthorizationConfigure(authorizationConfigure); } }
public static void InitOUTree(TreeView treeView, bool showPosition, bool checkOU, bool checkPosition, bool selectOU, bool selectPosition,bool showActiveOU) { treeView.Nodes.Clear(); AuthorizationDS.OrganizationUnitRow[] rootOU; if (showActiveOU) { rootOU = new OUTreeBLL().GetActiveRootOrganizationUnits(); } else { rootOU = new OUTreeBLL().GetRootOrganizationUnits(); } foreach (AuthorizationDS.OrganizationUnitRow organizationUnit in rootOU) { treeView.Nodes.Add(CreateOUTreeNode(organizationUnit, showPosition, checkOU, checkPosition, selectOU, selectPosition,showActiveOU)); } }
protected void OUTree_SelectedNodeChanged(object sender, EventArgs e) { this.OUIdCtl.Value = ""; this.OUCodeCtl.Value = ""; this.OUNameCtl.Value = ""; if (this.OUTree.SelectedNode != null) { if (this.OUTree.SelectedNode.Value.StartsWith("OU")) { this.OUIdCtl.Value = this.OUTree.SelectedNode.Value.Substring(2); AuthorizationDS.OrganizationUnitRow ou = new OUTreeBLL().GetOrganizationUnitById(int.Parse(this.OUIdCtl.Value)); this.OUCodeCtl.Value = ou.IsOrganizationUnitCodeNull() ? "" : ou.OrganizationUnitCode; this.OUNameCtl.Value = this.OUTree.SelectedNode.Text; } } }
public XmlDocument GetApprovalInfoByFormID(int FormID) { MasterData myDS = new MasterData(); MasterData.ApprovalInfoDataTable tbApprovalInfo = myDS.ApprovalInfo; AuthorizationDS.PositionDataTable tbPosition = null; int index = 1; AuthorizationBLL authBLL = new AuthorizationBLL(); OUTreeBLL ouBLL = new OUTreeBLL(); MasterData.ApprovalInfoRow rowApprovalInfo = tbApprovalInfo.NewApprovalInfoRow(); FormDS.FormRow rowForm = new FormSaleBLL().GetFormByID(FormID)[0]; rowApprovalInfo.ApprovalInfoID = index++; rowApprovalInfo.StuffName = authBLL.GetStuffUserById(rowForm.UserID).StuffName; rowApprovalInfo.ApprovalDate = rowForm.SubmitDate.ToString("yyyy-MM-dd HH:mm"); rowApprovalInfo.Position = ouBLL.GetPositionById(rowForm.PositionID).PositionName; rowApprovalInfo.Comment = ""; rowApprovalInfo.Status = "Submit"; tbApprovalInfo.AddApprovalInfoRow(rowApprovalInfo); if (!rowForm.IsProcIDNull()) { APWorkFlow.NodeStatusDataTable nodeTable = new APHelper().getApprovalStatus(rowForm.ProcID); foreach (APWorkFlow.NodeStatusRow item in nodeTable) { if ((!item.IsSTATUSNull()) && item.STATUS != "ASSIGNED") { rowApprovalInfo = tbApprovalInfo.NewApprovalInfoRow(); item.PARTICIPANT = item.PARTICIPANT.Replace("PP", "P"); rowApprovalInfo.ApprovalInfoID = index++; int i = 0; foreach (var userid in item.PARTICIPANT.Split('$')[0].Split('P')) { if ((!string.IsNullOrEmpty(userid)) && authBLL.GetStuffUserById(int.Parse(userid)).StuffName.Trim().Equals(item.APPROVED_BY)) { tbPosition = ouBLL.GetPositionsByID(int.Parse(item.PARTICIPANT.Split('$')[1].Split('P')[i])); rowApprovalInfo.Position = tbPosition.Count > 0 ? tbPosition[0].PositionName : ""; break; } i++; } rowApprovalInfo.StuffName = item.APPROVED_BY; rowApprovalInfo.ApprovalDate = item.IsCOMPLETED_DATENull() ? "" : item.COMPLETED_DATE; rowApprovalInfo.Comment = item.IsCOMMENTSNull() ? "" : item.COMMENTS; rowApprovalInfo.Status = item.IsSTATUSNull() ? "" : item.STATUS; tbApprovalInfo.AddApprovalInfoRow(rowApprovalInfo); } } } return new XmlDataDocument(myDS); }
protected void StuffUserPositionGridView_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DataRowView drv = (DataRowView)e.Row.DataItem; BusinessObjects.AuthorizationDS.PositionRow position = (BusinessObjects.AuthorizationDS.PositionRow)drv.Row; List<AuthorizationDS.OrganizationUnitRow> ous = new OUTreeBLL().GetParentOUsOfPosition(position.PositionId); StringBuilder ouNames = new StringBuilder(); foreach (BusinessObjects.AuthorizationDS.OrganizationUnitRow ou in ous) { ouNames.Append(ou.OrganizationUnitName + "-"); } Label label = (Label)e.Row.FindControl("ParentOUNamesCtl"); label.Text = ouNames.ToString(); } }
//启动流程 public APResult CreateProcess(APParameter app) { APResult result = new APResult(); string email = string.Empty; string l_strtitle = ""; StuffUserBLL stuffuserbll = new StuffUserBLL(); StringBuilder l_strbody = new StringBuilder(); OUTreeBLL outreebll = new OUTreeBLL(); string Deptment = outreebll.GetFlowParameter(app.OrganizationUnitID); Dictionary<string, object> Dictionary = app.Dic; Dictionary["Department"] = Deptment; AuthorizationDS.PositionRow position = outreebll.GetPositionById(app.PositionID); if (position.IsFlowLevelNull()) { Dictionary["FlowLevel"] = ""; } else { Dictionary["FlowLevel"] = position.FlowLevel; } string ProcID = AP.createProcess(app.FormNo + ":" + DateTime.Now.ToString(), new AuthorizationBLL().GetFlowTemplateNameByFormTypeAndUserID(app.FormTypeID, app.UserID), Dictionary); result.ProcID = ProcID; string[] InTurn = AP.startProcess(ProcID, app.OrganizationUnitID, ref email).Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString();///人员 pids += InTurn[a].Split('$')[1].ToString();//职位 } result.ApprovedDate = DateTime.Now; result.InTurnUserIds = ids;//下一步的人员 result.InTurnPositionIds = pids;//下一步的人员职位 result.StatusID = (int)SystemEnums.FormStatus.Awaiting; //自动审批下一个节点是自己的 if (!(ids.IndexOf("27") >= 0)) { if (ids.IndexOf(app.UserID.ToString()) > 0) { APResult approveresult = ApproveForm(app, app.FormID, app.UserID, stuffuserbll.GetStuffUserById(app.UserID)[0].StuffName, true, "", "", ProcID); result.InTurnUserIds = approveresult.InTurnUserIds; result.InTurnPositionIds = approveresult.InTurnPositionIds; } } try { if (!string.IsNullOrEmpty(email)) { //QueryDS.FormViewRow l_drformView = new FormQueryBLL().GetFormViewByID(app.FormID); l_strtitle = "有一份单据编号为:" + app.FormNo + ",等待您的审批!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 您有一份" + new StuffUserBLL().GetStuffUserById(app.UserID)[0].StuffName + "提交的单据,编号为:" + app.FormNo + ",等待您的审批!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(email, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } } catch { } return result; }
private string GetApproveName(int stuffuserID, int positionID, bool isApprove) { AuthorizationBLL authorizationBLL = new AuthorizationBLL(); AuthorizationDS.StuffUserRow stuffuserDr = authorizationBLL.GetStuffUserById(stuffuserID); string stuffUserName = stuffuserDr.StuffName; AuthorizationDS.PositionRow PositionRow = new OUTreeBLL().GetPositionById(positionID); string positionName = PositionRow.PositionName; if (isApprove) { return positionName + "[" + stuffUserName + "]"; } else { return stuffUserName; } }
private bool ExportPO(int formid, int logId) { string BakPath = ConfigurationManager.AppSettings["ExportService.BakPath"]; AuthorizationBLL authorizationbll = new AuthorizationBLL(); MasterDataBLL masterdatabll = new MasterDataBLL(); FormQueryBLL formQueryBLL = new FormQueryBLL(); FormPurchaseBLL formPurchaseBLL = new FormPurchaseBLL(); OUTreeBLL outreebll = new OUTreeBLL(); PurchaseDS.FormDataTable l_dtform = new PurchaseDS.FormDataTable(); PurchaseDS.FormRow form = l_dtform.NewFormRow(); try { PurchaseDS.FormPORow formPO = formPurchaseBLL.GetFormPOByID(formid); PurchaseDS.FormPODetailDataTable formPODetail = formPurchaseBLL.GetPODetailByFormPOID(formPO.FormPOID); form = formPurchaseBLL.GetFormByID(formPO.FormPOID)[0]; string POFileName = ConfigurationManager.AppSettings["ExportService.POFileName"]; string POLineFileName = ConfigurationManager.AppSettings["ExportService.POLineFileName"]; string spit = "\t"; string CompanyCode = masterdatabll.GetCompanyById(masterdatabll.GetVendorTypeById(masterdatabll.GetVendorByID(formPO.VendorID).VendorTypeID).CompanyID).CompanyCode; string VendorCode = masterdatabll.GetVendorByID(formPO.VendorID).VendorCode; string POcontent = ( "PH" + spit + "" + spit + formPO.BPCSPONo + spit + "0" + spit + "" + spit + "0" + spit + CompanyCode + spit + "" + spit + CompanyCode + spit + VendorCode + spit + "0" + spit + "4" + spit + "" + spit + masterdatabll.GetCompanyById(formPO.CompanyID).CompanyName + spit + authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit + bSubstring(formPO.DeliveryAddress, 30) + spit + SpitAddress(formPO.DeliveryAddress, 60) + spit + SpitAddress(formPO.DeliveryAddress, 90) + spit + "" + spit + "" + spit + "" + spit + form.SubmitDate.ToString("yyyyMMdd") + spit + "0" + spit + "0" + spit + "0" + spit + formPODetail[0].DeliveryDate.ToString("yyyyMMdd") + spit + "0" + spit + "0" + spit + bSubstring(formPO.Remark, 30) + spit + masterdatabll.GetPaymentTermById(masterdatabll.GetVendorByID(formPO.VendorID).PaymentTermID)[0].PaymentTermName + spit + "1" + spit + "" + spit + outreebll.GetOrganizationUnitById(form.OrganizationUnitID).OrganizationUnitCode + spit + masterdatabll.GetShippingTermById(formPO.ShippingTermID).ShippingTermCode + spit + "" + spit + masterdatabll.GetCurrencyByID(formPO.CurrencyID).CurrencyShortName + spit + formPO.ExchangeRate + spit + formPO.ExchangeRate + spit + formPODetail.Rows.Count + spit + formPO.ExchangeRate + spit + authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit + "" + spit + authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit + form.ApprovedDate.ToString("yyyyMMdd") + spit + "" + spit + "0" + spit + "" + spit + "0" + spit + "" + spit + "" + spit + "" + spit + "" + spit + "").Replace("\r", "").Replace("\n", ""); int order = 0; string[] PODetailcontent = new string[formPODetail.Rows.Count]; foreach (PurchaseDS.FormPODetailRow l_drformPODetail in formPODetail) { order++; PODetailcontent[order - 1] = ( "PO" + spit + formPO.BPCSPONo + spit + order + spit + l_drformPODetail.ItemCode.ToUpper() + spit + VendorCode + spit + l_drformPODetail.Quantity + spit + l_drformPODetail.Quantity + spit + l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit + "" + spit + "0" + spit + l_drformPODetail.AmountRMB.ToString() + spit + "0" + spit + "0" + spit + "EA" + spit + "0" + spit + "" + spit + "0" + spit + "0" + spit + "" + spit + "" + spit + "" + spit + DateTime.Now.ToString("yyyyMMdd") + spit + masterdatabll.GetPaymentTermById(masterdatabll.GetVendorByID(formPO.VendorID).PaymentTermID)[0].PaymentTermName + spit + "" + spit + "0" + spit + "1" + spit + "1" + spit + "" + spit + CompanyCode + spit + "0" + spit + "0" + spit + "0" + spit + "0" + spit + l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit + "" + spit + "0" + spit + "0" + spit + "" + spit + masterdatabll.GetCurrencyByID(formPO.CurrencyID).CurrencyShortName + spit + formPO.ExchangeRate + spit + formPO.ExchangeRate + spit + "0" + spit + l_drformPODetail.AmountRMB.ToString() + spit + "0" + spit + "1" + spit + "" + spit + "0" + spit + "0" + spit + "0" + spit + "" + spit + "" + spit + "" + spit + "01" + spit + "4" + spit + masterdatabll.GetCompanyById(formPO.CompanyID).CompanyName + spit +//Ship To Company authorizationbll.GetStuffUserById(form.UserID).UserName.ToUpper() + spit + bSubstring(formPO.DeliveryAddress, 30) + spit + SpitAddress(formPO.DeliveryAddress, 60) + spit + SpitAddress(formPO.DeliveryAddress, 90) + spit + "" + spit + "" + spit + "" + spit + "0" + spit + "0" + spit + l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit + "0" + spit + l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit + l_drformPODetail.DeliveryDate.ToString("yyyyMMdd") + spit + "" + spit + outreebll.GetOrganizationUnitById(form.OrganizationUnitID).OrganizationUnitCode + spit + "" + spit + "" + spit + masterdatabll.GetCostCenterById(form.CostCenterID).CostCenterCode + spit + l_drformPODetail.ItemCode.ToUpper() + spit + l_drformPODetail.ItemDescription + spit + "1" + spit + "0" + spit + "0" + spit + "3" + spit + "0" + spit + "0" + spit + "" + spit + "" + spit + "" + spit + "" + spit + "" + spit + "" + spit + "" + spit + l_drformPODetail.Quantity).Replace("\r", "").Replace("\n", ""); ; } File.AppendAllLines(path + POLineFileName, PODetailcontent, Encoding.Default); File.AppendAllLines(BakPath + DateTime.Now.ToString("yyyyMMddhhmmss") + POLineFileName, PODetailcontent, Encoding.Default); File.AppendAllText(path + POFileName, POcontent + "\r\n", Encoding.Default); File.AppendAllText(BakPath + DateTime.Now.ToString("yyyyMMddhhmmss") + POFileName, POcontent, Encoding.Default); } catch (Exception e) { logbll.InsertExportLogDetail(logId, "单据编号:" + form.FormNo + ",提交人:" + new StuffUserBLL().GetStuffUserById(form.UserID)[0].StuffName + ",错误信息:" + e.Message); return false; } return true; }
public string GetTreePathByOUID(int OUID) { String TreePath = string.Empty; AuthorizationDS.OrganizationUnitRow OU = new OUTreeBLL().GetOrganizationUnitById(OUID); if (!OU.IsOrganizationTreePathNull()) { TreePath = OU.OrganizationTreePath + "P" + OUID + "P "; } else { TreePath = "P" + OUID + "P "; } return TreePath; }
public void SaveDataToDB(string FullPath, string FileName, string excelFileExtension) { SqlTransaction transaction = null; try { DataTable dt = null; dt = this.GetDataSet(FullPath, excelFileExtension).Tables[0]; if (dt.Rows.Count <= 1) { PageUtility.ShowModelDlg(this.Page, "�ļ���û���κμ�¼��������ѡ��"); return; } BudgetManageFeeTableAdapter TABudgetManageFee = new BudgetManageFeeTableAdapter(); ImportLogTableAdapter TAImportLog = new ImportLogTableAdapter(); ImportLogDetailTableAdapter TAImportLogDetail = new ImportLogDetailTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TABudgetManageFee); TableAdapterHelper.SetTransaction(TAImportLog, transaction); TableAdapterHelper.SetTransaction(TAImportLogDetail, transaction); //�洢log��Ϣ ImportDS.ImportLogDataTable logTable = new ImportDS.ImportLogDataTable(); ImportDS.ImportLogRow logRow = logTable.NewImportLogRow(); int stuffUserID = ((AuthorizationDS.StuffUserRow)Session["StuffUser"]).StuffUserId; string fullname = this.fileUpLoad.PostedFile.FileName.ToString(); string tmpFile = fullname.Remove(0, fullname.LastIndexOf("\\") + 1); logRow.FileName = tmpFile; logRow.ImportDate = DateTime.Now; logRow.ImportUserID = stuffUserID; logRow.ImportType = 1; logRow.TotalCount = dt.Rows.Count - 1; logRow.SuccessCount = dt.Rows.Count - 1; logRow.FailCount = 0; logTable.AddImportLogRow(logRow); TAImportLog.Update(logTable); //����ÿ����ϸ BudgetDS.BudgetManageFeeDataTable BudgetManageTable = new BudgetDS.BudgetManageFeeDataTable(); ImportDS.ImportLogDetailDataTable ImportLogDetailTable = new ImportDS.ImportLogDetailDataTable(); int row_count = dt.Rows.Count; string errorInfor = string.Empty; // int expenseTypeID = int.Parse(ExpenseTypeDDL.SelectedValue); //��ʼ����ÿ����ϸ for (int i = 1; i <= row_count - 1; i++) { if (CheckData(dt.Rows[i]) != null) { errorInfor = "��" + (i + 1) + "���д��" + CheckData(dt.Rows[i]); ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else { DataRow row = dt.Rows[i]; string DepartmentName = row[0].ToString().Trim(); string Period_Year = row[1].ToString().Trim(); string Period_Month = row[2].ToString().Trim(); string AccountingCode = row[3].ToString().Trim(); string ExpenseManageType = row[4].ToString().Trim(); string OriginalBudget = row[5].ToString().Trim(); string NormalBudget = row[6].ToString().Trim(); string AdjustBudget = row[7].ToString().Trim(); string Remark = row[9].ToString().Trim(); AuthorizationDS.OrganizationUnitDataTable ouTable = new OUTreeBLL().GetDataByOrganizationUnitName(DepartmentName); if (ouTable == null || ouTable.Count == 0) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���Ҳ����˲��š�" + DepartmentName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else if (ouTable.Count > 1) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���ҵ���������ƵIJ��š�" + DepartmentName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else { ERS.ExpenseManageTypeDataTable emtTable = new MasterDataBLL().GetExpenseManageTypePaged(0, 20, string.Format("AccountingCode = '{0}'", AccountingCode), null); if (emtTable == null || emtTable.Count == 0) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���Ҳ����˷������" + AccountingCode + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else if (emtTable.Count > 1) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���ҵ�����˷������" + AccountingCode + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else { string temp = Period_Year + "-" + Period_Month + "-01"; string filter = string.Format("OrganizationUnitID = {0} and ExpenseManageTypeID= {1} and Period = '{2}'", ouTable[0].OrganizationUnitId, emtTable[0].ExpenseManageTypeID, DateTime.Parse(Period_Year + "-" + Period_Month + "-01")); if (new BudgetBLL().GetPagedBudgetManageFee(filter, 0, 20, null).Count > 0) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���Ѿ����ڱ����µ�Ԥ����Ϣ������ϵͳ��ֱ�Ӹ���"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount+1; logRow.SuccessCount = logRow.SuccessCount-1; TAImportLog.Update(logRow); continue; } else { BudgetDS.BudgetManageFeeRow BudgetManageRow = BudgetManageTable.NewBudgetManageFeeRow(); BudgetManageRow.OrganizationUnitID = ouTable[0].OrganizationUnitId; BudgetManageRow.Period = DateTime.Parse(Period_Year + "-" + Period_Month + "-01"); BudgetManageRow.ExpenseManageTypeID = emtTable[0].ExpenseManageTypeID; BudgetManageRow.OriginalBudget = decimal.Parse(OriginalBudget); BudgetManageRow.NormalBudget = decimal.Parse(NormalBudget); BudgetManageRow.AdjustBudget = decimal.Parse(AdjustBudget); BudgetManageRow.TotalBudget = decimal.Round(BudgetManageRow.NormalBudget + BudgetManageRow.AdjustBudget, 2); BudgetManageRow.ModifyReason = Remark; BudgetManageTable.AddBudgetManageFeeRow(BudgetManageRow); } } } } } TAImportLog.Update(logRow); TAImportLogDetail.Update(ImportLogDetailTable); TABudgetManageFee.Update(BudgetManageTable); transaction.Commit(); string returnString = "�ɹ�����" + logRow.SuccessCount.ToString() + "����Ϣ"; PageUtility.ShowModelDlg(this.Page, returnString); } catch (Exception ex) { if (transaction != null) { transaction.Rollback(); } PageUtility.ShowModelDlg(this.Page, "Save Fail!" + ex.ToString()); } finally { if (transaction != null) { transaction.Dispose(); } } }
/// <summary> /// 批量设置职务的业务操作范围 /// </summary> /// <param name="positionId">职务ID</param> /// <param name="operateIds">批量业务操作ID数组</param> /// <param name="scopeOUIds">操作范围覆盖的组织机构ID数组</param> /// <param name="scopePOIds">操作范围覆盖的职务ID数组</param> public void SetOperateScope(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int positionId, int[] operateIds, int[] scopeOUIds, int[] scopePOIds) { StringBuilder deleteContent = new StringBuilder(); StringBuilder addContent = new StringBuilder(); foreach (int operateId in operateIds) { string operateName = (string)this.BusinessOperateTA.GetBusinessOperateName(operateId); StringBuilder addStr = new StringBuilder(); StringBuilder deleteStr = new StringBuilder(); List <int> sOUIds = new List <int>(scopeOUIds); List <int> sPOIds = new List <int>(scopePOIds); BusinessObjects.AuthorizationDS.OperateScopeDataTable table = this.OperateScopeTA.GetDataByOperateAndPosition(operateId, positionId); foreach (BusinessObjects.AuthorizationDS.OperateScopeRow operateScope in table) { if (operateScope.IsScopeOrganziationUnitIdNull()) { if (sPOIds.Contains(operateScope.ScopePositionId)) { sPOIds.Remove(operateScope.ScopePositionId); } else { deleteStr.Append("职务[" + new OUTreeBLL().GetPositionById(operateScope.ScopePositionId).PositionName + "] "); operateScope.Delete(); } } else { if (sOUIds.Contains(operateScope.ScopeOrganziationUnitId)) { sOUIds.Remove(operateScope.ScopeOrganziationUnitId); } else { deleteStr.Append("机构[" + new OUTreeBLL().GetOrganizationUnitById(operateScope.ScopeOrganziationUnitId).OrganizationUnitName + "] "); operateScope.Delete(); } } } if (deleteStr.Length > 0) { deleteStr.Insert(0, "撤销业务操作[" + operateName + "]包含数据范围:"); deleteContent.Append(deleteStr.ToString()); } foreach (int ouId in sOUIds) { BusinessObjects.AuthorizationDS.OperateScopeRow newRow = table.NewOperateScopeRow(); newRow.PositionId = positionId; newRow.BusinessOperateId = operateId; newRow.ScopeOrganziationUnitId = ouId; table.AddOperateScopeRow(newRow); addStr.Append("机构[" + new OUTreeBLL().GetOrganizationUnitById(ouId).OrganizationUnitName + "] "); } foreach (int poId in sPOIds) { BusinessObjects.AuthorizationDS.OperateScopeRow newRow = table.NewOperateScopeRow(); newRow.PositionId = positionId; newRow.BusinessOperateId = operateId; newRow.ScopePositionId = poId; table.AddOperateScopeRow(newRow); addStr.Append("职务[" + new OUTreeBLL().GetPositionById(poId).PositionName + "] "); } if (addStr.Length > 0) { addStr.Insert(0, "新增业务操作[" + operateName + "]包含数据范围:"); addContent.Append(addStr.ToString()); } this.OperateScopeTA.Update(table); } if (deleteContent.Length > 0 || addContent.Length > 0) { AuthorizationConfigure authorizationConfigure = new AuthorizationConfigure(); authorizationConfigure.StuffId = stuffUser.StuffId; authorizationConfigure.StuffName = stuffUser.StuffName; authorizationConfigure.ConfigureType = "更新"; authorizationConfigure.ConfigureTarget = "业务操作范围"; authorizationConfigure.ConfigureTime = DateTime.Now; string positionName = new OUTreeBLL().GetPositionById(positionId).PositionName; if (deleteContent.Length > 0) { deleteContent.Insert(0, "职务[" + positionName + "]:"); authorizationConfigure.OldContent = deleteContent.ToString(); } if (addContent.Length > 0) { addContent.Insert(0, "职务[" + positionName + "]:"); authorizationConfigure.NewContent = addContent.ToString(); } SysLog.LogAuthorizationConfigure(authorizationConfigure); } }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetCacheability(HttpCacheability.NoCache); //lwy, migrate from mainpage if (Session["StuffUser"] == null) { this.NavigateMenu.Visible = false; return; } if (!IsPostBack) { AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"]; if (Session["ProxyStuffUserId"] != null) { this.Session["Position"] = new OUTreeBLL().GetPositionById((int)Session["PositionId"]); this.Session["StuffUser"] = new StuffUserBLL().GetStuffUserById((int)Session["StuffUserId"])[0]; List<string> useRootItems = new List<string>(); useRootItems.Add(" �����뱨��"); //useRootItems.Add("���˷��ñ�������"); //useRootItems.Add("��������"); //useRootItems.Add("���������"); this.CustomizeNavigateMenu(); List<MenuItem> noUseRootItems = new List<MenuItem>(); foreach (MenuItem rootItem in this.NavigateMenu.Items) { if (!useRootItems.Contains(rootItem.Text)) { noUseRootItems.Add(rootItem); } } foreach (MenuItem noUseRootItem in noUseRootItems) { this.NavigateMenu.Items.Remove(noUseRootItem); } this.CustomizeNavigateMenu(); } else { AuthorizationBLL bll = new AuthorizationBLL(); AuthorizationDS.PositionDataTable positions = bll.GetPositionByStuffUser(stuffUser.StuffUserId); if (positions.Count == 0) { PageUtility.ShowModelDlg(this.Page, "û������ְ��,����ϵϵͳ����Ա"); this.Response.Redirect("~/ErrorPage/NoPositionErrorPage.aspx"); return; } this.PositionSelectCtl.Items.Clear(); foreach (AuthorizationDS.PositionRow position in positions) { this.PositionSelectCtl.Items.Add(new ListItem(position.PositionName, position.PositionId.ToString())); } if (positions.Count > 0) { this.PositionSelectCtl.Visible = true; this.PositionSelectLabel.Visible = true; } if (this.Session["SelectedPosition"] == null) { int currentPositionId = int.Parse(this.PositionSelectCtl.SelectedValue); Session["Position"] = new OUTreeBLL().GetPositionById(currentPositionId); } else { Session["Position"] = Session["SelectedPosition"]; this.PositionSelectCtl.SelectedValue = ((AuthorizationDS.PositionRow)Session["Position"]).PositionId.ToString(); } if (Session["Position"] == null) { int currentPositionId = int.Parse(this.PositionSelectCtl.SelectedValue); Session["Position"] = new OUTreeBLL().GetPositionById(currentPositionId); } else { this.PositionSelectCtl.SelectedValue = ((AuthorizationDS.PositionRow)Session["Position"]).PositionId.ToString(); } } AuthorizationDS.StuffUserRow user = (AuthorizationDS.StuffUserRow)Session["StuffUser"]; this.StuffNameCtl.Text = user.StuffName; this.LastLogInTimeCtl.Text = user.IsLaterLogInTimeNull() ? "" : user.LaterLogInTime.ToShortDateString(); } this.CustomizeNavigateMenu(); }
protected void PositionSelectCtl_SelectedIndexChanged(object sender, EventArgs e) { int currentPositionId = int.Parse(this.PositionSelectCtl.SelectedValue); Session["SelectedPosition"] = new OUTreeBLL().GetPositionById(currentPositionId); //Response.Redirect("~/MainPage.aspx"); Response.Redirect("~/Home.aspx"); }
/// <summary> /// ��������ְ���ҵ�������Χ /// </summary> /// <param name="positionId">ְ��ID</param> /// <param name="operateIds">����ҵ�����ID����</param> /// <param name="scopeOUIds">������Χ���ǵ���֯����ID����</param> /// <param name="scopePOIds">������Χ���ǵ�ְ��ID����</param> public void SetOperateScope(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int positionId, int[] operateIds, int[] scopeOUIds, int[] scopePOIds) { StringBuilder deleteContent = new StringBuilder(); StringBuilder addContent = new StringBuilder(); foreach (int operateId in operateIds) { string operateName = (string)this.BusinessOperateTA.GetBusinessOperateName(operateId); StringBuilder addStr = new StringBuilder(); StringBuilder deleteStr = new StringBuilder(); List<int> sOUIds = new List<int>(scopeOUIds); List<int> sPOIds = new List<int>(scopePOIds); BusinessObjects.AuthorizationDS.OperateScopeDataTable table = this.OperateScopeTA.GetDataByOperateAndPosition(operateId, positionId); foreach (BusinessObjects.AuthorizationDS.OperateScopeRow operateScope in table) { if (operateScope.IsScopeOrganziationUnitIdNull()) { if (sPOIds.Contains(operateScope.ScopePositionId)) { sPOIds.Remove(operateScope.ScopePositionId); } else { deleteStr.Append("ְ��[" + new OUTreeBLL().GetPositionById(operateScope.ScopePositionId).PositionName + "] "); operateScope.Delete(); } } else { if (sOUIds.Contains(operateScope.ScopeOrganziationUnitId)) { sOUIds.Remove(operateScope.ScopeOrganziationUnitId); } else { deleteStr.Append("����[" + new OUTreeBLL().GetOrganizationUnitById(operateScope.ScopeOrganziationUnitId).OrganizationUnitName + "] "); operateScope.Delete(); } } } if (deleteStr.Length > 0) { deleteStr.Insert(0, "����ҵ�����[" + operateName + "]�������ݷ�Χ��"); deleteContent.Append(deleteStr.ToString()); } foreach (int ouId in sOUIds) { BusinessObjects.AuthorizationDS.OperateScopeRow newRow = table.NewOperateScopeRow(); newRow.PositionId = positionId; newRow.BusinessOperateId = operateId; newRow.ScopeOrganziationUnitId = ouId; table.AddOperateScopeRow(newRow); addStr.Append("����[" + new OUTreeBLL().GetOrganizationUnitById(ouId).OrganizationUnitName + "] "); } foreach (int poId in sPOIds) { BusinessObjects.AuthorizationDS.OperateScopeRow newRow = table.NewOperateScopeRow(); newRow.PositionId = positionId; newRow.BusinessOperateId = operateId; newRow.ScopePositionId = poId; table.AddOperateScopeRow(newRow); addStr.Append("ְ��[" + new OUTreeBLL().GetPositionById(poId).PositionName + "] "); } if (addStr.Length > 0) { addStr.Insert(0, "����ҵ�����[" + operateName + "]�������ݷ�Χ��"); addContent.Append(addStr.ToString()); } this.OperateScopeTA.Update(table); } if (deleteContent.Length > 0 || addContent.Length > 0) { AuthorizationConfigure authorizationConfigure = new AuthorizationConfigure(); authorizationConfigure.StuffId = stuffUser.StuffId; authorizationConfigure.StuffName = stuffUser.StuffName; authorizationConfigure.ConfigureType = "����"; authorizationConfigure.ConfigureTarget = "ҵ�������Χ"; authorizationConfigure.ConfigureTime = DateTime.Now; string positionName = new OUTreeBLL().GetPositionById(positionId).PositionName; if (deleteContent.Length > 0) { deleteContent.Insert(0, "ְ��[" + positionName + "]��"); authorizationConfigure.OldContent = deleteContent.ToString(); } if (addContent.Length > 0) { addContent.Insert(0, "ְ��[" + positionName + "]��"); authorizationConfigure.NewContent = addContent.ToString(); } SysLog.LogAuthorizationConfigure(authorizationConfigure); } }
/// <summary> /// ����ְ���ϵͳ��ɫ /// </summary> /// <param name="positionId"></param> /// <param name="systemRoleIds"></param> public void SetPositionSystemRole(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int positionId, int[] systemRoleIds) { StringBuilder oldContent = new StringBuilder(); StringBuilder newContent = new StringBuilder(); BusinessObjects.AuthorizationDS.PositionAndSystemRoleDataTable table = this.PositionAndSystemRoleTA.GetDataByPositionId(positionId); List<int> roleIds = new List<int>(systemRoleIds); foreach (BusinessObjects.AuthorizationDS.PositionAndSystemRoleRow positionAndSystemRole in table) { if (roleIds.Contains(positionAndSystemRole.SystemRoleId)) { roleIds.Remove(positionAndSystemRole.SystemRoleId); } else { oldContent.Append("[").Append(this.SystemRoleTA.GetSystemRoleName(positionAndSystemRole.SystemRoleId)).Append("] "); positionAndSystemRole.Delete(); } } foreach (int roleId in roleIds) { BusinessObjects.AuthorizationDS.PositionAndSystemRoleRow newRow = table.NewPositionAndSystemRoleRow(); newRow.PositionId = positionId; newRow.SystemRoleId = roleId; newContent.Append("[").Append(this.SystemRoleTA.GetSystemRoleName(roleId)).Append("] "); table.AddPositionAndSystemRoleRow(newRow); } this.PositionAndSystemRoleTA.Update(table); if (oldContent.Length > 0 || newContent.Length > 0) { AuthorizationConfigure authorizationConfigure = new AuthorizationConfigure(); authorizationConfigure.StuffId = stuffUser.StuffId; authorizationConfigure.StuffName = stuffUser.StuffName; authorizationConfigure.ConfigureTarget = "ְ��Ȩ������"; authorizationConfigure.ConfigureTime = DateTime.Now; authorizationConfigure.ConfigureType = "����"; string positionName = new OUTreeBLL().GetPositionById(positionId).PositionName; if (oldContent.Length > 0) { oldContent.Insert(0, "����ְ��[" + positionName + "]��ϵͳ��ɫ��"); authorizationConfigure.OldContent = oldContent.ToString(); } if (newContent.Length > 0) { newContent.Insert(0, "����ְ��[" + positionName + "]��ϵͳ��ɫ��"); authorizationConfigure.NewContent = newContent.ToString(); } SysLog.LogAuthorizationConfigure(authorizationConfigure); } }
public void SaveDataToDB(string FullPath, string FileName, string excelFileExtension) { SqlTransaction transaction = null; try { DataTable dt = null; dt = this.GetDataSet(FullPath, excelFileExtension).Tables[0]; if (dt.Rows.Count <= 1) { PageUtility.ShowModelDlg(this.Page, "�ļ���û���κμ�¼��������ѡ��"); return; } CustomerTableAdapter TACustomer = new CustomerTableAdapter(); ImportLogTableAdapter TAImportLog = new ImportLogTableAdapter(); ImportLogDetailTableAdapter TAImportLogDetail = new ImportLogDetailTableAdapter(); MasterDataBLL mdBLL = new MasterDataBLL(); transaction = TableAdapterHelper.BeginTransaction(TACustomer); TableAdapterHelper.SetTransaction(TAImportLog, transaction); TableAdapterHelper.SetTransaction(TAImportLogDetail, transaction); //�洢log��Ϣ ImportDS.ImportLogDataTable logTable = new ImportDS.ImportLogDataTable(); ImportDS.ImportLogRow logRow = logTable.NewImportLogRow(); int stuffUserID = ((AuthorizationDS.StuffUserRow)Session["StuffUser"]).StuffUserId; string fullname = this.fileUpLoad.PostedFile.FileName.ToString(); string tmpFile = fullname.Remove(0, fullname.LastIndexOf("\\") + 1); logRow.FileName = tmpFile; logRow.ImportDate = DateTime.Now; logRow.ImportUserID = stuffUserID; logRow.ImportType = 3; logRow.TotalCount = dt.Rows.Count - 1; logRow.SuccessCount = dt.Rows.Count - 1; logRow.FailCount = 0; logTable.AddImportLogRow(logRow); TAImportLog.Update(logTable); //����ÿ����ϸ ERS.CustomerDataTable tbCustomer = new ERS.CustomerDataTable(); ImportDS.ImportLogDetailDataTable ImportLogDetailTable = new ImportDS.ImportLogDetailDataTable(); int row_count = dt.Rows.Count; string errorInfor = string.Empty; // int expenseTypeID = int.Parse(ExpenseTypeDDL.SelectedValue); //��ʼ����ÿ����ϸ for (int i = 1; i <= row_count - 1; i++) { if (CheckData(dt.Rows[i]) != null) { errorInfor = "��" + (i + 1) + "���д��" + CheckData(dt.Rows[i]); ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } else { DataRow row = dt.Rows[i]; string CustomerNo = row[0].ToString().Trim(); string CustomerName = row[1].ToString().Trim(); string ProvinceName = row[2].ToString().Trim(); string CityName = row[3].ToString().Trim(); string CustomerTypeName = row[4].ToString().Trim(); string ChannelTypeName = row[5].ToString().Trim(); string OUName = row[6].ToString().Trim(); string BudgetOUName = row[7].ToString().Trim(); ERS.CustomerDataTable tbCustomerTemp = mdBLL.GetCustomerByCustomerName(CustomerName); if (tbCustomerTemp != null && tbCustomerTemp.Count > 0) { errorInfor = "��" + (i + 1) + "���д���Ѵ��ڿͻ���" + CustomerName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } //ERS.ProvinceDataTable tbProvince = mdBLL.GetProvinceByProvinceName(ProvinceName); //if (tbProvince == null || tbProvince.Count == 0) { // errorInfor = "��" + (i + 1) + "���д���Ҳ���ʡ�ݡ�" + ProvinceName + "��"; // ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); // ImportDetailRow.LogID = logRow.LogID; // ImportDetailRow.Line = i + 1; // ImportDetailRow.Error = errorInfor; // ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); // logRow.FailCount = logRow.FailCount + 1; // logRow.SuccessCount = logRow.SuccessCount - 1; // TAImportLog.Update(logRow); // continue; //} ERS.CityDataTable tbCity = mdBLL.GetCityByCityName(CityName); if (tbCity == null || tbCity.Count == 0) { errorInfor = "��" + (i + 1) + "���д���Ҳ������С�" + CityName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } ERS.CustomerTypeDataTable tbCustomerType = mdBLL.GetCustomerTypeByCustomerTypeName(CustomerTypeName); if (tbCustomerType == null || tbCustomerType.Count == 0) { errorInfor = "��" + (i + 1) + "���д���Ҳ����ͻ����͡�" + CustomerTypeName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } ERS.ChannelTypeDataTable tbChannelType = mdBLL.GetChannelTypeByChannelTypeName(ChannelTypeName); if (tbChannelType == null || tbChannelType.Count == 0) { errorInfor = "��" + (i + 1) + "���д���Ҳ����ͻ�������" + ChannelTypeName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } AuthorizationDS.OrganizationUnitDataTable ouTable = new OUTreeBLL().GetDataByOrganizationUnitName(OUName); if (ouTable == null || ouTable.Count == 0) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���Ҳ����˲��š�" + OUName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } if (ouTable.Count > 1) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���ҵ���������ƵIJ��š�" + OUName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } AuthorizationDS.OrganizationUnitDataTable BudgetOUTable = new OUTreeBLL().GetDataByOrganizationUnitName(BudgetOUName); if (BudgetOUTable == null || BudgetOUTable.Count == 0) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���Ҳ����˲��š�" + BudgetOUName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } if (BudgetOUTable.Count > 1) { errorInfor = "��" + (i + 1) + "���д��ϵͳ���ҵ���������ƵIJ��š�" + BudgetOUName + "��"; ImportDS.ImportLogDetailRow ImportDetailRow = ImportLogDetailTable.NewImportLogDetailRow(); ImportDetailRow.LogID = logRow.LogID; ImportDetailRow.Line = i + 1; ImportDetailRow.Error = errorInfor; ImportLogDetailTable.AddImportLogDetailRow(ImportDetailRow); logRow.FailCount = logRow.FailCount + 1; logRow.SuccessCount = logRow.SuccessCount - 1; TAImportLog.Update(logRow); continue; } ERS.CustomerRow rowCustomer = tbCustomer.NewCustomerRow(); rowCustomer.CustomerNo = CustomerNo; rowCustomer.CustomerName = CustomerName; rowCustomer.CityID = tbCity[0].CityID; rowCustomer.CustomerTypeID = tbCustomerType[0].CustomerTypeID; rowCustomer.ChannelTypeID = tbChannelType[0].ChannelTypeID; rowCustomer.OrganizationUnitID = ouTable[0].OrganizationUnitId; rowCustomer.ApplyOrganizationUnitID = BudgetOUTable[0].OrganizationUnitId; rowCustomer.IsActive = true; tbCustomer.AddCustomerRow(rowCustomer); TACustomer.Update(rowCustomer); } } TAImportLog.Update(logRow); TAImportLogDetail.Update(ImportLogDetailTable); transaction.Commit(); string returnString = "�ɹ�����" + logRow.SuccessCount.ToString() + "����Ϣ"; PageUtility.ShowModelDlg(this.Page, returnString); } catch (Exception ex) { if (transaction != null) { transaction.Rollback(); } PageUtility.ShowModelDlg(this.Page, "Save Fail!" + ex.ToString()); } finally { if (transaction != null) { transaction.Dispose(); } } }