/// <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);
}
