public static Dictionary <string, object> GetCustomerServiceDataByProjectID(int ProjectID)
{
Dictionary <string, object> dic = null;
CustomerService data = null;
CustomerService[] dataList = new CustomerService[] { };
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ProjectID", ProjectID));
dataList = GetList <CustomerService>("select * from [CustomerService] where ProjectID=@ProjectID", parameters).ToArray();
if (dataList.Length > 0)
{
data = dataList.FirstOrDefault(p => p.ServiceStatus == 0 || p.ServiceStatus == 3 || p.ServiceStatus == 10);
}
if (data == null)
{
return(dic);
}
dic = new Dictionary <string, object>();
dic["GongDanType"] = "";
if (data.ServiceType1ID > 0)
{
var type = ServiceType.GetServiceType(data.ServiceType1ID);
dic["GongDanType"] = type != null ? type.ServiceTypeName : string.Empty;
}
dic["GongDanAddTime"] = data.AddTime.ToString("yyyy-MM-dd HH:mm:ss");
dic["GongDanStatusDesc"] = data.ServiceStatusDesc;
dic["GongDanRemark"] = "";
var chuLiList = CustomerServiceChuli.GetCustomerServiceChuliList(data.ID);
if (chuLiList.Length > 0)
{
var chuLiData = chuLiList.FirstOrDefault(p => !string.IsNullOrEmpty(p.ChuliNote));
dic["GongDanRemark"] = chuLiData != null ? chuLiData.ChuliNote : "";
}
dic["GongDanContent"] = data.ServiceContent;
var dataGongDanList = dataList.Where(p => !p.IsSuggestion).ToArray();
var dataTouSuList = dataList.Where(p => p.IsSuggestion).ToArray();
dic["HisotryGongDanCount"] = dataGongDanList.Length;
dic["HisotryTouSuCount"] = dataTouSuList.Length;
return(dic);
}
