![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZuBnL2MDN4gzN3YTNtEzNyQTN1ATMxcTMxADOxAjMtkTO0cTO08CXxADOxAjMvwVO5QzN5QzLcd2bsJ2Lc12bj5ycn9Gbi52YucTMwIzcldWYtl2Lc9CX6MHc0RHaiojIsJye.png)
using DbOperate.Modify;
using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Web.Http;
using Utils.Log4net;
using Utils.JsonXmlHelper;
using static Model.GetUsrUserModel.OutGetUsrUserModel;
namespace AssistServer.Controllers
{
public class GetUsrUserController : ApiController
{
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="{"ActionCode":"1001","Table":[{"COMPNO":"*","USR":"0001"}]}"></param>
/// <returns></returns>
[TransLogFilter]
public Object Post([FromBody]string sJson)
{
LogHandle.WriteLog(typeof(GetUsrUserController),1,sJson);
InValueModel<List<GetUsrUserModel.InGetUsrUserModel.Table>> InValueModel = SerializationHelper.Deserialize<InValueModel<List<GetUsrUserModel.InGetUsrUserModel.Table>>>(sJson);
String ActionCode = InValueModel.ActionCode.ToString();
OutValueModel<List<Table>> OutValueModel = new OutValueModel<List<Table>>();
List<Table> Table = new List<Table>();
try
{
String COMPNO = InValueModel.Table[0].COMPNO.ToString();
String USR = InValueModel.Table[0].USR.ToString();
String sSql = "Select CompNo,Usr,Name,Pwd From tUsrUser_App " +
"Where CompNo='" + COMPNO + "' and Usr = '" + USR + "'";
DataTable DtHead = DbModify.GetDataTable(sSql);
Table = DbModify.GetDataList<Table>(sSql);
if (Table.Count != 0)
{
OutValueModel.RtnCode = "1";
OutValueModel.Msg = "获取用户信息成功";
}
else
{
OutValueModel.RtnCode = "0";
OutValueModel.Msg = "无此用户信息";
}
OutValueModel.Table = Table;
}
catch (Exception ex)
{
OutValueModel.RtnCode = "-1";
OutValueModel.Msg = "获取用户信息失败"+ex.Message;
}
LogHandle.WriteLog(typeof(GetUsrUserController), 1, SerializationHelper.Serialize(OutValueModel));
return OutValueModel;
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Model
{
public class InValueModel<T>
{
public String ActionCode { get; set; }
public T Table { get; set; }
}
}
using System;
namespace Model
{
public class GetUsrUserModel
{
//用户信息入参
public class InGetUsrUserModel
{
public class Table
{
public String COMPNO { get; set; }
public String USR { get; set; }
}
}
//用户信息返回结果
public class OutGetUsrUserModel
{
public class Table
{
public String COMPNO { get; set; }
public String USR { get; set; }
public String NAME { get; set; }
public String PWD { get; set; }
}
}
}
}