public string UserSignUp(object user)
{
JObject jdata = JObject.Parse(user.ToString());
string uemail = jdata.SelectToken("UserEmail").ToString(); //邮箱
string upwd = jdata.SelectToken("UserPwd").ToString(); //密码
string uname = jdata.SelectToken("UserName").ToString(); //昵称
//获取默认账号和用户名
int account = QueryDAL.GetModelTowhereSql <ShiUsers>
("select top 1 * from ShiUsers order by Key_No desc").KeyNo;
string uaccname = "shi00" + (account + 1);
ShiUsers users = new ShiUsers();
users.UserEmail = uemail;
users.UserPwd = upwd;
users.UserName = uname;
users.Account = uaccname;
users.UserSex = 2;//默认为私密
//创建token：根据用户名+时间通过MD5加密后保证唯一性
DateTime gettime = DateTime.Now;
users.UserToken = MD5Encryption.Md5_32(uname.ToString() + gettime.ToString());
users.TokenEndtiem = gettime;
if (InsertDAL.InsertModel <ShiUsers>(users))
{
return(users.UserToken);
}
return("-1");
}
public static void GetInit(string pageName, string processName, int userId, ref List <InitModel> listInitModel, ref List <Dict_SystemModel> listDict_SystemModel)
{
QueryDAL.GetInit(pageName, processName, userId, ref listInitModel, ref listDict_SystemModel);
foreach (InitModel init in listInitModel)
{
List <Dict_SystemModel> tmpList = listDict_SystemModel.Where <Dict_SystemModel>(p => p.PID == init.DictID).ToList <Dict_SystemModel>();
init.List = new List <string>();
foreach (Dict_SystemModel dict in tmpList)
{
init.List.Add(dict.DictKey);
}
}
}
public string existemailandname(object users)
{
JObject jdata = JObject.Parse(users.ToString());
string email = jdata.SelectToken("UserEmail").ToString();
string uname = jdata.SelectToken("UserName").ToString();
//查询是否存在
ShiUsers exuser = QueryDAL.GetModelTowhereExp <ShiUsers>(u => u.UserEmail == email || u.UserName == uname);
if (exuser != null)
{
if (exuser.UserName == uname)
{
return("昵称已被使用，请您重新输入！");
}
if (exuser.UserEmail == email)
{
return("邮箱已被使用，请您重新输入或登录！");
}
}
return("0");
}
public string UserLogin(object jData)
{
//参数赋值
JObject t = JObject.Parse(jData.ToString());
JToken juser_email = t.SelectToken("UserEmail");//UserEmail与前端保持一致
JToken juser_pwd = t.SelectToken("UserPwd");
ShiUsers users = QueryDAL.GetModelTowhereExp <ShiUsers>
(u => u.UserEmail == juser_email.ToString() && u.UserPwd == juser_pwd.ToString());
if (users != null)
{
//创建token：根据用户名+时间通过MD5加密后保证唯一性
DateTime gettime = DateTime.Now;
users.UserToken = MD5Encryption.Md5_32(juser_email.ToString() + gettime.ToString());
users.TokenEndtiem = gettime;
//更新到数据库，登录成功后每次访问数据都带上token
UpdateDAL.update_model <ShiUsers>(users);
return(users.UserToken);
}
// return JsonConvert.SerializeObject("-1");
return("-1");
}
public static bool GenDynamicSql(object[] conditions, string prefix, ref string sql, ref SqlParameter[] parameters, out string errMsg)
{
errMsg = string.Empty;
if (conditions == null || conditions.Length == 0)
{
errMsg = "查询条件为空";
return(false);
}
var sb = new StringBuilder();
var initModel = new InitModel();
var listDict_SystemModel = new List <Dict_SystemModel>();
var alias = !string.IsNullOrEmpty(prefix) ? (prefix.Substring(prefix.Length - 1, 1) == "." ? prefix : (prefix + ".")) : string.Empty;
foreach (IDictionary <string, object> el in conditions)
{
if (el != null)
{
var dicPara = new Dictionary <string, object>(el, StringComparer.OrdinalIgnoreCase);
int id = (dicPara.ContainsKey("id") && Utils.isNumber(dicPara["id"])) ? Convert.ToInt32(dicPara["id"]) : 0;
string field = (dicPara.ContainsKey("field") && dicPara["field"] != null) ? dicPara["field"].ToString() : string.Empty;
if (string.IsNullOrEmpty(field))
{
errMsg = "查询条件字段不明确";
return(false);
}
QueryDAL.GetInitModel(id, field, ref initModel, ref listDict_SystemModel);
if (string.IsNullOrEmpty(initModel.DataType))
{
errMsg = "查询条件类型不明确";
return(false);
}
if (initModel.DataType.Equals("string"))
{
var str = (dicPara.ContainsKey("values") && dicPara["values"] != null) ? dicPara["values"].ToString() : string.Empty;
sb.Append(string.Format(" and {1}{0} like '%' + @{0} + '%' ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field, str);
}
else if (initModel.DataType.Equals("number") || initModel.DataType.Equals("bit"))
{
var number = (dicPara.ContainsKey("values") && dicPara["values"] != null) ? dicPara["values"].ToString() : string.Empty;
sb.Append(string.Format(" and {1}{0} = @{0} ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field, number);
}
else if (initModel.DataType.Equals("numbers"))
{
var numbers = dicPara.ContainsKey("values") ? (object[])dicPara["values"] : null;
if (numbers != null && numbers.Length > 0)
{
if (numbers.Length >= 1)
{
var n0 = numbers[0];
if (!string.IsNullOrEmpty(n0 + ""))
{
sb.Append(string.Format(" and {1}{0} >= @{0}lower ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field + "lower", n0);
}
}
if (numbers.Length >= 2)
{
var n1 = numbers[1];
if (!string.IsNullOrEmpty(n1 + ""))
{
sb.Append(string.Format(" and {1}{0} <= @{0}upper ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field + "upper", n1);
}
}
}
}
else if (initModel.DataType.Equals("literals"))
{
var literals = (dicPara.ContainsKey("values") && dicPara["values"] != null) ? dicPara["values"].ToString() : string.Empty;
var dict_SystemModel = listDict_SystemModel.Where(w => w.DictKey.Equals(literals, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
literals = (dict_SystemModel != null) ? dict_SystemModel.DictValue : string.Empty;
sb.Append(string.Format(" and {1}{0} = @{0} ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field, literals);
}
else if (initModel.DataType.Equals("date") || initModel.DataType.Equals("datetime"))
{
var date = dicPara.ContainsKey("values") ? dicPara["values"] : null;
try
{
DateTime dtDate = Convert.ToDateTime(date);
if (initModel.DataType.Equals("date"))
{
//同一天
sb.Append(string.Format(" and convert(varchar,{1}{0},102) = convert(varchar,@{0},102) ", field, alias));
}
else
{
//同一分钟
sb.Append(string.Format(" and convert(varchar,{1}{0},100) = convert(varchar,@{0},100) ", field, alias));
}
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field, dtDate);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
else if (initModel.DataType.Equals("dates") || initModel.DataType.Equals("datetimes"))
{
var dates = dicPara.ContainsKey("values") ? (object[])dicPara["values"] : null;
if (dates != null && dates.Length > 0)
{
try
{
if (dates.Length >= 1)
{
var d0 = dates[0];
if (!string.IsNullOrEmpty(d0 + ""))
{
DateTime dtDate = Convert.ToDateTime(d0);
sb.Append(string.Format(" and {1}{0} >= @{0}start ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field + "start", dtDate);
}
}
if (dates.Length >= 2)
{
var d1 = dates[1];
if (!string.IsNullOrEmpty(d1 + ""))
{
DateTime dtDate = Convert.ToDateTime(d1);
sb.Append(string.Format(" and {1}{0} <= @{0}end ", field, alias));
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = new SqlParameter("@" + field + "end", dtDate);
}
}
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
}
else
{
errMsg = "查询条件类型不支持";
return(false);
}
}
else
{
errMsg = "提交数据包含空对象";
return(false);
}
}
sql = sql + sb.ToString();
return(true);
}
