public string GetCompanyInformation(int _UserId) { ZhouFu.Bll.DataHandler bll = new Bll.DataHandler(); StringBuilder sbStr = new StringBuilder(); string _Fields = "ID as CompanyId,MonadName,LogoUrl,Phone,MailBox,Type,NumberOfPeople,Nature,Province,City,County,Address,Describe,Url,userid as LoginId,RegisteredCapital,RunRange"; string _SqlWhere = string.Format(" userid='{0}'", _UserId); DataSet ds = bll.GetList("Sm_Monad", _Fields, "ID", 1, 1, false, false, _SqlWhere); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; sbStr.Append("[{\"msg\":\"查询成功\","); sbStr.Append("\"data\":"); string strTemp = EasyUIJsonHelper.TableToJson(dt); DataSet dsFile = bll.GetList("Sm_CaseInformation", "ID,Name,FilePath,bigFilePath", "ID", 100, 1, false, false, "MonadID=" + dt.Rows[0]["LoginId"]); if (dsFile != null && dsFile.Tables[0].Rows.Count > 0) { DataTable dtFile = dsFile.Tables[0]; string strTempFile = EasyUIJsonHelper.TableToJson(dtFile); strTemp = strTemp.Insert((strTemp.Length - 2), ",\"FileList\":" + strTempFile); } sbStr.Append(strTemp); sbStr.Append(",\"state\":\"0\"}]"); } else { sbStr.Append("[{\"msg\":\"查询失败,企业信息不存在\",\"data\":\"\",\"state\":\"1\"}]"); } return(sbStr.ToString()); }
public string GetNewsList(int _ClassId, int _Page, int _PageSize) { StringBuilder sbStr = new StringBuilder(); if (_Page == 0) { _Page = 1; } if (_PageSize == 0) { _PageSize = 10; } StringBuilder sbSqlWhere = new StringBuilder(); sbSqlWhere.AppendFormat(" Isdel=0 and ClassId={0} and IsApp=1", _ClassId); ZhouFu.Bll.DataHandler bll = new Bll.DataHandler(); DataSet ds = bll.GetList("sys_News", "ID,Title,Url,AddTime", "AddTime", _PageSize, _Page, false, false, sbSqlWhere.ToString()); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; sbStr.AppendFormat("[{\"msg\":\"查询成功,无相应的数据。\",\"data\":\"{0}\",\"state\":\"0\"}]", EasyUIJsonHelper.TableToJson(dt)); } else { sbStr.Append("[{\"msg\":\"查询成功,无相应的数据。\",\"data\":\"\",\"state\":\"0\"}]"); } return(sbStr.ToString()); }
public string GetDictionaryList(int _ParentId) { StringBuilder sbStr = new StringBuilder(); if (_ParentId > 0) { DataSet ds = bll.GetList("sys_Dictionary", "ID,DtyName,ParentId", "ID", 100, 1, false, false, "ParentId=" + _ParentId); if (ds != null) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { sbStr.Append("[{\"msg\":\"获取成功\",\"data\":" + EasyUIJsonHelper.TableToJson(dt) + ",\"state\":\"0\"}]"); } else { sbStr.Append("[{\"msg\":\"获取成功,无对应数据,请核实传入参数.\",\"data\":\"\",\"state\":\"1\"}]"); } } } return(sbStr.ToString()); }
public string Login(string _LoginName, string _LoginPassword) { ZhouFu.Bll.DataHandler bll = new Bll.DataHandler(); StringBuilder sbStr = new StringBuilder(); try { string _Fields = "ID,user_name,user_mobile,user_email,user_sex,user_province,user_city,user_county,user_address,user_picture,(select LinkPicture from sys_ManagerGrade where ID=sys_manager.user_category) as user_category,(select picture from dbo.TB_HonorSet where (dbo.sys_Manager.HonorPoints) BETWEEN startnumber and endnumber)as HonorSetPic,AccountBalance,DJAccountBalance,JLAccountBalance,IsEmailVerify,IsMobileVerify,IsPersonVerify,RealName,CodeNumber,DealPassword,bank_id,bank_province,bank_city,bank_address,bank_card,login_category,LastTime"; string _SqlWhere = string.Format(" login_name='{0}' and login_password='******'", _LoginName, DESEncrypt.GetStringMD5(_LoginPassword)); DataSet ds = bll.GetList("sys_manager", _Fields, "ID", 1, 1, false, false, _SqlWhere); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Columns["DealPassword"].ColumnName == "DealPassword") { dt.Rows[0]["DealPassword"] = DESEncrypt.GetStringMD5(dt.Rows[0]["DealPassword"].ToString()); } sbStr.Append("[{\"msg\":\"登陆成功\","); sbStr.Append("\"data\":"); sbStr.Append(EasyUIJsonHelper.TableToJson(dt)); sbStr.Append(",\"state\":\"0\"}]"); ZhouFu.Model.sys_Manager mModel = new ZhouFu.Bll.sys_Manager().GetModel(Convert.ToInt32(dt.Rows[0]["ID"])); mModel.LastTime = DateTime.Now; new ZhouFu.Bll.sys_Manager().Update(mModel); } else { sbStr.Append("[{\"msg\":\"登陆失败,用户名或密码错误\",\"data\":\"\",\"state\":\"1\"}]"); } } catch { sbStr.Append("[{\"msg\":\"登陆失败,服务器处理错误\",\"data\":\"\",\"state\":\"2\"}]"); } return(sbStr.ToString()); }