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); }
public static bool CheckCanCompleteService(List <int> IDList, out string error) { error = string.Empty; var list = ViewCustomerService.GetViewCustomerServiceByIDList(IDList); if (list.Length == 0) { error = "请选择工单"; return(false); } var sServiceIDList = list.Select(p => p.ID).ToList(); var chuliList = CustomerServiceChuli.GetCustomerServiceChuliListByServiceIDList(sServiceIDList); foreach (var item in list) { if (item.ServiceStatus == 1) { error = "工单已办结,不能重复办结"; return(false); } //if (item.BanJieServiceType == 1) //{ // var myItemList = chuliList.Where(p => p.ServiceID == item.ID).ToArray(); // if (myItemList.Length == 0) // { // error = "工单未处理,不能办结"; // return false; // } // continue; //} if (item.BanJieServiceType == 2) { continue; } } return(true); }