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