public ViewVIPApply(int Id) { this.Id = Id; DBOperate m_dbo = new DBOperate(); string sql = string.Format(@"select Id,ReceiveAddress as Address,ComId,MemberId,Memo,SumMoney, ReceiveMobile as Mobile,ReceiveRealName as RealName, ReceiveTelPhone as Telphone,DeptId,Status,Name as CompanyName,DeptName, MemberAddressId from View_VIPApply where Id={0} ", Id); DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { DataRow row = ds.Tables[0].Rows[0]; Id = DBTool.GetIntFromRow(row, "Id", 0); ComId = DBTool.GetIntFromRow(row, "ComId", 0); CompanyName = DBTool.GetStringFromRow(row, "CompanyName", ""); MemberId = DBTool.GetIntFromRow(row, "MemberId", 0); DeliveryLineManager dlm = new DeliveryLineManager(); DeliveryLine line = dlm.LoadDeliveryLine(MemberId); if (line.LineName != "") { Address = "[" + line.LineName + "]" + DBTool.GetStringFromRow(row, "Address", ""); } else { Address = DBTool.GetStringFromRow(row, "Address", ""); } Memo = DBTool.GetStringFromRow(row, "Memo", ""); SumMoney = DBTool.GetDoubleFromRow(row, "SumMoney", 0); Mobile = DBTool.GetStringFromRow(row, "Mobile", ""); RealName = DBTool.GetStringFromRow(row, "RealName", ""); Telphone = DBTool.GetStringFromRow(row, "Telphone", ""); DeptId = DBTool.GetIntFromRow(row, "DeptId", 0); DeptName = DBTool.GetStringFromRow(row, "DeptName", ""); Status = DBTool.GetStringFromRow(row, "Status", ""); MemberAddressId = DBTool.GetIntFromRow(row, "MemberAddressId", 0); } }
/// <summary> /// 获取联系人或者公司对应的线路 /// </summary> /// <param name="memberId"></param> /// <param name="companyId"></param> public DeliveryLine LoadDeliveryLine(int memberId) { DeliveryLine line = new DeliveryLine(); DeliveryMemberLine dml = LoadDeliveryMemLinebyMemId(memberId); if (dml != null) { line.Id = dml.LineId; line.Load(); } else//读取公司路线 { Member member = new Member(); member.Id = memberId; member.Load(); DeliveryCompanyLine dcl = LoadDeliveryCompyLinebyComId(member.ComId); if (dcl != null) { line.Id = dcl.LineId; line.Load(); } } return(line); }