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