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