/// <summary> /// 添加经纪人 /// </summary> /// <param name="username">用户名</param> /// <param name="password">密码</param> /// <param name="mobile">手机号</param> /// <param name="realname">真实姓名</param> /// <param name="erpgh">erp工号</param> /// <param name="shopid">门店ID</param> /// <returns></returns> public string Addjjr(string username = null, string password = null, string mobile = null, string realname = null, string erpgh = null, int?shopid = null) { List <SqlParameter> parms = new List <SqlParameter>() { new SqlParameter("@username", SqlDbType.VarChar) { Value = username }, new SqlParameter("@password", SqlDbType.VarChar) { Value = Utils.MD5(password), Size = 50 }, new SqlParameter("@mobile", SqlDbType.VarChar) { Value = mobile }, new SqlParameter("@realname", SqlDbType.VarChar) { Value = realname }, new SqlParameter("@city", SqlDbType.Int) { Value = 3 }, new SqlParameter("@area", SqlDbType.Int) { Value = 0 }, new SqlParameter("@addip", SqlDbType.VarChar) { Value = "" }, new SqlParameter("@erpgh", SqlDbType.VarChar) { Value = erpgh }, new SqlParameter("@deptid", SqlDbType.Int) { Value = shopid }, new SqlParameter("@reftotalnum", SqlDbType.Int) { Value = 0 }, new SqlParameter("@ebtotalnum", SqlDbType.Int) { Value = 0 }, new SqlParameter("@housetotalnum", SqlDbType.Int) { Value = 5 }, new SqlParameter("@ismobilelock", SqlDbType.Int) { Value = 0 }, new SqlParameter("@userid", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@state", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@msg", SqlDbType.VarChar, 200) { Direction = ParameterDirection.Output } }; try { DBHelperSQL.ExecuteFunc("user_addbroker_jjr2018", parms); } catch (Exception ex) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "提交失败" })); } int _state = (int)parms.First(p => p.ParameterName == "@state").Value; string _msg = (string)parms.First(p => p.ParameterName == "@msg").Value; if (_state == 1) { int _useid = (int)parms.First(p => p.ParameterName == "@userid").Value; //经纪人添加成功后添加年度套餐 List <SqlParameter> parms1 = new List <SqlParameter>() { new SqlParameter("@userid", SqlDbType.Int) { Value = _useid }, new SqlParameter("@setid", SqlDbType.Int) { Value = 4 }, new SqlParameter("@setsnum", SqlDbType.Int) { Value = 1 }, new SqlParameter("@state", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@msg", SqlDbType.VarChar, 200) { Direction = ParameterDirection.Output } }; try { DBHelperSQL.ExecuteFunc("order_free_jjr2018", parms1); int state = Convert.ToInt32(parms1.First(p => p.ParameterName == "@state").Value); string msg = Convert.ToString(parms1.First(p => p.ParameterName == "@msg").Value); SMS.SendSMS_New(mobile, "恭喜您已开通e房网经纪人账号,账号(" + username + "),密码(" + password + ")。登陆地址:http://dwz.cn/rPTLC45W【e房网】"); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "添加成功" })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "添加失败" })); } } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = _msg })); } }
public MSSQLDataAccessHelper(string connectionString) { dbHelperSQL = new DBHelperSQL(connectionString); }
/// <summary> /// 获取行数 /// </summary> /// <param name="tablename"></param> /// <param name="strwhere"></param> /// <returns></returns> private int GetRows(string tablename, string strwhere) { string strSql = "select count(1) from " + tablename + " where " + strwhere + ""; return(int.Parse(DBHelperSQL.GetSingle(strSql).ToString())); }