public virtual int GetCount(string month = "", string cust_id = "", string status = "")
{
var sql = string.Format(@"SELECT COUNT(1) AS CNT FROM CLAIM WHERE (@month IS NULL OR CLAIM_DATE LIKE @month+'%')
AND (@cust_id='' OR CUSTOMER_ID=@cust_id) AND(@status='' OR STATUS=@status)");
return((int)DBManager <CLAIM> .ExecuteScalar(sql, new
{
month = month,
cust_id = cust_id,
status = status
}));
}
public virtual int GetCount(string from = "", string to = "", string cust_id = "", string status = "")
{
var sql = string.Format(@"SELECT COUNT(1) AS CNT FROM ORDERED WHERE (@from ='' OR ORDED_DATE BETWEEN @from AND @to)
AND (@cust_id='' OR CUSTOMER_ID=@cust_id) AND(@status='' OR ORD_STAT=@status);");
return((int)DBManager <ORDERED> .ExecuteScalar(sql, new
{
from = from,
to = to,
cust_id = cust_id,
status = status
}));
}
public virtual int GetCount(string from = "")
{
var sql = "SELECT COUNT(1) AS CNT FROM VIST_CONTACTOR";
if (string.IsNullOrWhiteSpace(from))
{
return((int)DBManager <VIST_CONTACTOR> .ExecuteScalar(sql));
}
sql += " where contact_date like @from +'%'";
return((int)DBManager <VIST_CONTACTOR> .ExecuteScalar(sql, new
{
from = from
}));
}
public int GetCountVisit(string from = "", string to = "", string cus_id = "", string em_id = "")
{
var sql = string.Format(@"SELECT COUNT(*) FROM
VIST_CONTACTOR WHERE (@FROM='' OR CONTACT_DATE BETWEEN @FROM AND @TO)
AND (@CUSTOMER_ID='' OR CUSTOMER_ID=@CUSTOMER_ID) AND (@EMP_ID='' OR EMP_ID=@EMP_ID);");
return((int)DBManager <VIST_CONTACTOR> .ExecuteScalar(sql, new
{
FROM = from,
TO = to,
EMP_ID = em_id,
CUSTOMER_ID = cus_id
}));
}
public virtual int GetCount()
{
var sql = "SELECT COUNT(1) AS CNT FROM EMP_VISIT;";
return((int)DBManager <EMP_VISIT> .ExecuteScalar(sql));
}
public virtual int GetCount()
{
var sql = "SELECT COUNT(1) AS CNT FROM CONTACT;";
return((int)DBManager <CUSTOMER> .ExecuteScalar(sql));
}
public virtual int GetCount(string key = "")
{
var sql = "SELECT COUNT(1) AS CNT FROM EMPLOYEE WHERE @key='' OR @key IS NULL OR EMP_ID LIKE @key +'%' OR EMP_NAME LIKE '%'+@key +'%';";
return((int)DBManager <EMPLOYEE> .ExecuteScalar(sql, new { key = key }));
}
public virtual int GetCount(string key = "")
{
var sql = "SELECT COUNT(1) AS CNT FROM CUSTOMER WHERE @key='' OR @key IS NULL OR ID LIKE @key +'%' OR NAME LIKE '%'+@key+'%' ";
return((int)DBManager <CUSTOMER> .ExecuteScalar(sql, new { key = key }));
}
public virtual int GetCount()
{
var sql = "SELECT COUNT(1) AS CNT FROM STD_CODE;";
return((int)DBManager <STD_CODE> .ExecuteScalar(sql));
}