/// <summary> /// 通过公司Id,获取之前是否为公司分配过路线 /// </summary> /// <param name="companyId"></param> /// <returns></returns> public DeliveryCompanyLine LoadDeliveryCompyLinebyComId(int companyId) { DeliveryCompanyLine dcl = new DeliveryCompanyLine(); string sql = "select * from dbo.DeliveryCompanyLine where CompanyId =" + companyId; DataSet ds = m_dbo.GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; dcl.Id = DBTool.GetIntFromRow(row, "Id", 0); dcl.CompanyId = DBTool.GetIntFromRow(row, "CompanyId", 0); dcl.LineId = DBTool.GetIntFromRow(row, "LineId", 0); dcl.Remark = DBTool.GetStringFromRow(row, "Remark", ""); dcl.UpdateTime = DBTool.GetDateTimeFromRow(row, "UpdateTime"); dcl.Distance = DBTool.GetIntFromRow(row, "Distance", 0); return(dcl); } else { return(null); } }
/// <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); }