/// <summary> /// 임시패스워드 발급 /// </summary> /// <param name="email"></param> /// <param name="newEncPassword"></param> /// <returns></returns> public int UpdateMemberTempPassword(string email, string newEncPassword) { using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50); param.Add("p_NewPassword", newEncPassword, DbType.String, ParameterDirection.Input, 200); return(connection.Execute("SP_PartnerAdmin_Update_Member_TempPassword", param, commandType: CommandType.StoredProcedure)); } } }
public List <T> GetetPartnerAdminMenuList <T>() { List <T> list = null; using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); list = connection.Query <T>("SP_PartnerAdmin_Select_PartnerAdminMenu", commandType: CommandType.StoredProcedure).AsList(); } } return(list); }
/// <summary> /// 멤버 인증 완료 /// </summary> /// <param name="email"></param> /// <param name="authCode"></param> public int UpdateAuthMember(string email, string authCode) { using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50); param.Add("p_AuthCode", authCode, DbType.String, ParameterDirection.Input, 200); return(connection.Execute("SP_PartnerAdmin_Update_AuthMember", param, commandType: CommandType.StoredProcedure)); } } }
/// <summary> /// 회원가입 /// </summary> /// <param name="email"></param> /// <param name="encPassword"></param> /// <param name="name"></param> public void InsertMemberinfo(string email, string encPassword, string name) { using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50); param.Add("p_Password", encPassword, DbType.String, ParameterDirection.Input, 200); param.Add("p_Name", name, DbType.String, ParameterDirection.Input, 20); connection.Execute("SP_PartnerAdmin_Insert_Member", param, commandType: CommandType.StoredProcedure); } } }
public virtual List <T> SelectProductnfo <T>(string partnerId) { List <T> list = null; using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_partnerId", partnerId, DbType.String, ParameterDirection.Input, 50); list = connection.Query <T>("SPP_Select_ProductInfo", param, commandType: CommandType.StoredProcedure).AsList(); return(list); } } }
/// <summary> /// 멤버 이메일 인증 대상 리스트 /// </summary> /// <param name="email"></param> public List <T> SelectAuthMember <T>(string email) { List <T> list = null; using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50); list = connection.Query <T>("SP_PartnerAdmin_Select_AuthMember_byEmail", param, commandType: CommandType.StoredProcedure).AsList(); } } return(list); }
public List <T> GetOrderChartList <T>(string domCd, int beforeDay) { List <T> list = null; using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_domCd", domCd, DbType.String, ParameterDirection.Input, 2); param.Add("p_day", beforeDay, DbType.Int32, ParameterDirection.Input, 4); list = connection.Query <T>("SP_PartnerAdmin_Select_ChartOrderByOrderM", param, commandType: CommandType.StoredProcedure).AsList(); } } return(list); }
public virtual List <T> SelectProductTarget <T>(string partnerId, string goodId, int currentPageNo, int limitPageNo) { List <T> list = null; using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz()) { using (var connection = new MySqlConnection(MysqlConnection)) { connection.Open(); var param = new DynamicParameters(); param.Add("p_partnerId", partnerId, DbType.String, ParameterDirection.Input, 50); param.Add("p_goodId", goodId, DbType.String, ParameterDirection.Input, 50); param.Add("p_currentPageNo", currentPageNo, DbType.Int32, ParameterDirection.Input, 4); param.Add("p_limitPageNo", limitPageNo, DbType.Int32, ParameterDirection.Input, 4); list = connection.Query <T>("SP_PartnerAdmin_Select_ProductTarget", param, commandType: CommandType.StoredProcedure).AsList(); return(list); } } }