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