[WebMethod]//任意查詢語句返回任意查詢欄位的值,
public string GetKCRQ(string sYWLX, string sDQ,string sUser)
{
//sYWLX 01 鞋子業務 02 贈品 03 資材
WinOperation wop = new WinOperation();
string sql = "SELECT CONVERT(VARCHAR(10),ISNULL(MAX(KC_RQ),'2000/01/01'),111) KC_RQ "
+ " FROM "
+ " ( "
+ " Select YWLX='01',JZ_DQ,KC_RQ "
+ " from KCJZ "
+ " UNION "
+ " SELECT YWLX='02',JZ_DQ,KC_RQ "
+ " FROM Z_ZP_KCJZ "
+ " UNION "
+ " SELECT YWLX='03',JZ_DQ,KC_RQ "
+ " FROM ZC_KCJZ "
+ " ) V_KCJZ "
+ " WHERE JZ_DQ='"+sDQ+"'"
+ " AND YWLX='"+sYWLX +"'";
object o = serverbase.execmdscalar(sql);
return o != null ? o.ToString() : "";
}
public string GetKCRQ(string sYWLX, string sDQ,string sUser)
{
//sYWLX 01 鞋子業務 02 贈品 03 資材
WinOperation wop = new WinOperation();
string sql = "SELECT CONVERT(VARCHAR(10),ISNULL(MAX(KC_RQ),'2000/01/01'),111) KC_RQ "
+ " FROM "
+ " ( "
+ " Select YWLX='01',JZ_DQ,KC_RQ "
+ " from KCJZ "
+ " UNION "
+ " SELECT YWLX='02',JZ_DQ,KC_RQ "
+ " FROM Z_ZP_KCJZ "
+ " UNION "
+ " SELECT YWLX='03',JZ_DQ,KC_RQ "
+ " FROM ZC_KCJZ "
+ " ) V_KCJZ "
+ " WHERE JZ_DQ='"+sDQ+"'"
+ " AND YWLX='"+sYWLX +"'";
object o = serverbase.execmdscalar(sql);
return o != null ? o.ToString() : "";
}