public static string GetCustomerByAppId(string AppId) { string sql = "select top 1 CustomerId From cpos_ap..TCustomerWeiXinMapping where AppId = 'wx8a8c3152a369751a' and IsDelete = '0' "; string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }
/// <summary> /// 获取商户编码 /// </summary> /// <param name="customerId"></param> /// <returns></returns> public static string GetCustomerCode(string customerId) { string sql = string.Format( "select a.customer_code from t_customer a where a.customer_id='{0}' ", customerId); string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }
public string GetCustomerIdByWx(string weixinID) { string sql = string.Format( "select CustomerId FROM dbo.TCustomerWeiXinMapping WHERE WeiXinId = '{0}' AND IsDelete = 0 ", weixinID); string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }
/// <summary> /// 根据Customer_ID获取CustomerCode /// </summary> /// <param name="customerID"></param> /// <returns></returns> public string GetCustomerCodeByCustomerID(string customerID) { string sql = string.Format("SELECT customer_code FROM dbo.t_customer WHERE customer_id = '{0}'", customerID); string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }
public static string GetCustomerConn(string customerId) { string sql = string.Format( "select 'user id='+a.db_user+';password='******';data source='+a.db_server+';database='+a.db_name+';' conn " + " from t_customer_connect a where a.customer_id='{0}' ", customerId); string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }
/// <summary> /// 根据微信公众账号获取数据库连接字符串 /// </summary> /// <param name="weixinID"></param> /// <returns></returns> public string GetCustomerConn(string weixinID) { string sql = string.Format( "select 'user id='+a.db_user+';password='******';data source='+a.db_server+';database='+a.db_name+';' conn " + " from t_customer_connect a where a.customer_id = " + " (SELECT CustomerId FROM dbo.TCustomerWeiXinMapping WHERE WeiXinId = '{0}' AND IsDelete = 0) ", weixinID); string conn = ConfigurationManager.AppSettings["Conn_ap"]; DefaultSQLHelper sqlHelper = new DefaultSQLHelper(conn); var result = sqlHelper.ExecuteScalar(sql); return(result == null || result == DBNull.Value ? string.Empty : result.ToString()); }