/// <summary> /// 打印客户洽谈信息 /// </summary> /// <param name="CustID"></param> /// <param name="CustTalkM"></param> /// <param name="TalkBegin"></param> /// <param name="TalkEnd"></param> /// <param name="ord"></param> /// <returns></returns> public static DataTable ExportTalkInfo(string CanUserID, string CustID, CustTalkModel CustTalkM, string TalkBegin, string TalkEnd, string ord) { // return TalkDBHelper.ExportTalkInfo(CustID, CustTalkM, TalkBegin, TalkEnd, ord); string LinkerIds = ""; //每条记录多个ID string EmployeeNames = ""; //多个员工姓名 DataTable dt = TalkDBHelper.ExportTalkInfo(CanUserID, CustID, CustTalkM, TalkBegin, TalkEnd, ord); DataColumn LinkerName = new DataColumn(); dt.Columns.Add("LinkerName"); for (int i = 0; i < dt.Rows.Count; i++) { LinkerIds = dt.Rows[i]["Linker"].ToString(); string[] LinkerList = LinkerIds.Split(','); for (int j = 0; j < LinkerList.Length; j++) { //获取参与人ID int inputID = Convert.ToInt32(LinkerList[j]); //调用方法取name EmployeeNames = EmployeeNames + "," + EmployeeDBHelper.GetEmployeeNameByID(inputID, CustTalkM.CompanyCD); } //插入EmployeeNames到一条记录 dt.Rows[i]["LinkerName"] = EmployeeNames.Substring(1); EmployeeNames = ""; } return(dt); }
/// <summary> /// 根据ID获得请示详细信息 /// </summary> /// <param name="CompanyCD">公司代码</param> /// <param name="DocRequstID">请示ID</param> /// <returns>请示信息</returns> public static DataTable GetDocRequstByID(string CompanyCD, int DocRequstID) { //return DocRequstDBHelper.GetDocRequstByID(CompanyCD, DocRequstID); //string Linker = "";//单个ID string MainIds = ""; //每条记录多个ID string EmployeeNames = ""; //多个员工姓名 DataTable dt = DocRequstDBHelper.GetDocRequstByID(CompanyCD, DocRequstID); DataColumn MainName = new DataColumn(); dt.Columns.Add("MainName"); for (int i = 0; i < dt.Rows.Count; i++) { MainIds = dt.Rows[i]["Main"].ToString(); string[] MainList = MainIds.Split(','); for (int j = 0; j < MainList.Length; j++) { //获取参与人ID int inputID = Convert.ToInt32(MainList[j]); //调用方法取name EmployeeNames = EmployeeNames + "," + EmployeeDBHelper.GetEmployeeNameByID(inputID, CompanyCD); } //插入EmployeeNames到一条记录 dt.Rows[i]["MainName"] = EmployeeNames.Substring(1); EmployeeNames = ""; } return(dt); }
/// <summary> /// 根据ID获得会议详细信息 /// </summary> /// <param name="CompanyCD">公司代码</param> /// <param name="MeetingInfoID">会议ID</param> /// <returns>会议信息</returns> public static DataTable GetMeetingInfoByID(string CompanyCD, int MeetingInfoID) { //return MeetingInfoDBHelper.GetMeetingInfoByID(CompanyCD, MeetingInfoID); string MainIds = ""; //每条记录多个ID string EmployeeNames = ""; //多个员工姓名 DataTable dt = MeetingInfoDBHelper.GetMeetingInfoByID(CompanyCD, MeetingInfoID); DataColumn JoinName = new DataColumn(); dt.Columns.Add("JoinName"); for (int i = 0; i < dt.Rows.Count; i++) { MainIds = dt.Rows[i]["JoinUser"].ToString(); if (MainIds.StartsWith(",")) { MainIds = MainIds.Remove(0, 1); } if (MainIds.EndsWith(",")) { MainIds = MainIds.Remove(MainIds.Length - 1, 1); } string[] MainList = MainIds.Split(','); for (int j = 0; j < MainList.Length; j++) { //获取参与人ID int inputID = Convert.ToInt32(MainList[j]); //调用方法取name EmployeeNames = EmployeeNames + "," + EmployeeDBHelper.GetEmployeeNameByID(inputID, CompanyCD); } //插入EmployeeNames到一条记录 dt.Rows[i]["JoinName"] = EmployeeNames.Substring(1); EmployeeNames = ""; } return(dt); }
/// <summary> /// 根据洽谈ID获取洽谈信息的方法 /// </summary> /// <param name="CompanyCD">公司代码</param> /// <param name="TalkID">洽谈ID</param> /// <returns>返回洽谈信息</returns> public static DataTable GetTalkInfoByID(string CompanyCD, int TalkID) { //return TalkDBHelper.GetTalkInfoByID(CompanyCD, TalkID); string Linker = ""; //单个ID string LinkerIds = ""; //每条记录多个ID string EmployeeNames = ""; //多个员工姓名 DataTable dt = TalkDBHelper.GetTalkInfoByID(CompanyCD, TalkID); DataColumn LinkerName = new DataColumn(); dt.Columns.Add("LinkerName"); dt.Columns.Add("LinkerID"); for (int i = 0; i < dt.Rows.Count; i++) { LinkerIds = dt.Rows[i]["Linker"].ToString(); string[] LinkerList = LinkerIds.Split(','); for (int j = 0; j < LinkerList.Length; j++) { //获取参与人ID int inputID = Convert.ToInt32(LinkerList[j]); //调用方法取name EmployeeNames = EmployeeNames + "," + EmployeeDBHelper.GetEmployeeNameByID(inputID, CompanyCD); Linker = Linker + "," + inputID; } //插入EmployeeNames到一条记录 dt.Rows[i]["LinkerName"] = EmployeeNames.Substring(1); dt.Rows[i]["LinkerID"] = Linker.Substring(1); //EmployeeNames = ""; } return(dt); }