public static object GetCarStatus(FilterCarStatus _filterCarStatus) { try { LiteDatabase db; db = new LiteDatabase(ldbConfig.ldbCarStatusConnectionString); // get old ldb ps lst LiteCollection <CarStatus> dbPS = db.GetCollection <CarStatus>("CarStatus"); //{ int QCount = 2; if (_filterCarStatus.CompanyCode != 0) { QCount++; } if (_filterCarStatus.FinqcCode != 0) { QCount++; } if (_filterCarStatus.Status_Code != -1) { QCount++; } int i = 0; Query[] lstQ = new Query[QCount]; //-- lstQ[i] = Query.GTE("JoineryDateFaNum", _filterCarStatus.JoineryStartDateFaNum); i++; lstQ[i] = Query.LTE("JoineryDateFaNum", _filterCarStatus.JoineryEndDateFaNum); if (_filterCarStatus.CompanyCode != 0) { i++; lstQ[i] = Query.EQ("CompanyCode", _filterCarStatus.CompanyCode); } if (_filterCarStatus.FinqcCode != 0) { i++; lstQ[i] = Query.EQ("FinqcCode", _filterCarStatus.FinqcCode); } if (_filterCarStatus.Status_Code != -1) { i++; lstQ[i] = Query.EQ("Status_Code", _filterCarStatus.Status_Code); } var data = dbPS.Find(Query.And(lstQ)).Select(c => new { //Id = i++, c.CompanyCode, c.FinqcCode, c.JoineryDateFaNum, c.Status_Code, c.Vin }).ToList(); if (_filterCarStatus.AutomationSendPid != 0) { DataTable dt = DBHelper.ToDataTable(dbPS.Find(Query.And(lstQ)).Select(c => new { c.CompanyName, c.FinqcCode, c.JoineryDateFa, c.Status_Code, c.Vin }).OrderBy(o => o.CompanyName).ToList()); dt.Columns["CompanyName"].ColumnName = "شرکت"; dt.Columns["FinqcCode"].ColumnName = "وضعیت کیفی"; dt.Columns["Status_Code"].ColumnName = "وضعیت فروش"; dt.Columns["JoineryDateFa"].ColumnName = "تاریخ تجارتی"; dt.Columns["Vin"].ColumnName = "شماره شاسی"; //dt.DefaultView.Sort = "CompanyName"; string[] s = new string[1]; s[0] = _filterCarStatus.AutomationSendPid.ToString(); CommonUtility.SendAutomationAtachExcel("گزارش وضعیت خودرو", _filterCarStatus.AutomationContentDesc.Replace("🔍", Environment.NewLine + "🔍"), s, s, dt, "CarStatus"); List <CarStatus> lst = new List <CarStatus>(); CarStatus cs1 = new CarStatus(); cs1.Vin = "sent"; lst.Add(cs1); return(lst); } return(data); } catch (Exception ex) { LogManager.SetCommonLog("GetArchiveQCStatistics_Error_" + ex.Message.ToString()); return(null); } }
public object GetCarStatusByFilters([FromBody] FilterCarStatus _filterCarStatus)// _ps { return(ldbFetch.GetCarStatus(_filterCarStatus)); }