/// <summary> /// 用户登录 /// </summary> /// <param name="loginname"></param> /// <param name="pwd"></param> /// <returns></returns> public string Login(string loginname, string pwd) { //if (string.IsNullOrEmpty(loginname) || string.IsNullOrEmpty(pwd)) //{ // return Returnhelper.GetReturnStr("false", "参数不完善", "1"); //} //loginname = loginname.Replace("'", ","); //pwd = pwd.Replace("'", ","); //#region //string sql = "select * from users where loginpwd='" + Zx.Common.Common.MD5(pwd, true) + "'and loginname='" + loginname + "' and (userphone='4' or userphone='5')"; //Zx.Query.ExecSqlQuery exs = new Zx.Query.ExecSqlQuery(); //DataTable dt = exs.DataTableBySql(sql); //if (dt != null && dt.Rows.Count > 0) //{ // return "{\"success\":\"true\",\"msg\":\"登录成功\",\"errorcode\":\"0\",\"userid\":\"" + dt.Rows[0]["userid"] + "\",\"mobile\":\"" + dt.Rows[0]["loginname"] + "\",\"nickname\":\"" + dt.Rows[0]["extension"] + "\",\"company\":\"" + dt.Rows[0]["Extension4"] + "\",\"type\":\"" + (dt.Rows[0]["UserPhone"].ToString() == "4" ? "家装设计" : "工装设计") + "\"}"; //} //else //{ // return Returnhelper.GetReturnStr("false", "用户名或密码错误", "0"); //} //#endregion #region 查询登录 string sql = "select * from users where loginpwd=@loginpwd and loginname=@loginname and (userphone='4' or userphone='5')"; SqlParameter[] arr = new SqlParameter[] { new SqlParameter("@loginname", loginname), new SqlParameter("@loginpwd", pwd.To16Md5()) }; DataTable dt = SqlHelperMeasure.ExecuteDataTable(sql, arr); #endregion if (dt != null && dt.Rows.Count > 0) { var row = dt.Rows[0]; #region 检查头像 string headimg = row["HeadImage"].ToSafeString(); if (headimg.Contains("http")) { } else if (headimg.Length == 0) { headimg = "http://www.mj100.com/img/defaultHead.png"; } else { headimg = "http://www.mj100.com/UploadFile/head/" + headimg; } #endregion var user = new { success = "true", msg = "登录成功", errorcode = "0", userid = row["userid"].ToSafeString(), mobile = row["loginname"].ToSafeString(), nickname = row["extension"].ToSafeString(), company = row["Extension4"].ToSafeString(), type = row["UserPhone"].ToSafeString() == "4" ? "家装设计" : "工装设计", headimg = headimg }; return(JsonConvert.SerializeObject(user)); } else { return("{\"success\":\"false\",\"msg\":\"用户名或密码错误\",\"errorcode\":\"0\"}"); } }
/// <summary> /// 得到一个单独的需求 /// </summary> /// <param name="userid"></param> /// <param name="id"></param> /// <returns></returns> public DataTable Getsingle(string userid, string id) { string sql = @"select Start_zfzbj as pics, Constructionid , Start_jlxy as projectid,SupportingId as userid ,phone,Start as demanddesc , Start_qht as address,ConstructionLxr as CustomerName,ProjectCost as fileurls, Start_kgjc as Thumbnailpic , CreateTime from dbo.Construction where SupportingId=@userid and ConstructionId=@id "; SqlParameter[] arr = new SqlParameter[] { new SqlParameter("@userid", userid), new SqlParameter("@id", id) }; return(SqlHelperMeasure.ExecuteDataTable(sql, arr)); }