public int RemoveUser(UserInfo userInfo)
{
using (var db = new EasyEsb())
{
return(db.Delete <UserInfo>(userInfo));
}
}
public int RemoveRoute(RouteInfo routeInfo)
{
using (var db = new EasyEsb())
{
return(db.Delete <RouteInfo>(routeInfo));
}
}
public int AddUser(UserInfo userInfo)
{
using (var db = new EasyEsb())
{
return(db.Insert <UserInfo>(userInfo));
}
}
public int RemoveAuthority(AuthorityInfo authorityInfo)
{
using (var db = new EasyEsb())
{
return(db.Insert <AuthorityInfo>(authorityInfo));
}
}
public int AddRoute(RouteInfo routeInfo)
{
using (var db = new EasyEsb())
{
return(db.Insert <RouteInfo>(routeInfo));
}
}
public int RemoveGroup(GroupInfo groupInfo)
{
using (var db = new EasyEsb())
{
return(db.Delete <GroupInfo>(groupInfo));
}
}
public IEnumerable <TransInfo> GetAllTransInfo()
{
using (var db = new EasyEsb())
{
return(db.TransInfo);
}
}
public int AddGroup(GroupInfo groupInfo)
{
using (var db = new EasyEsb())
{
return(db.Insert <GroupInfo>(groupInfo));
}
}
public int RemoveTrans(TransInfo transInfo)
{
using (var db = new EasyEsb())
{
return(db.Delete <TransInfo>(transInfo));
}
}
public int AddTrans(TransInfo transInfo)
{
using (var db = new EasyEsb())
{
return(db.Insert <TransInfo>(transInfo));
}
}
public TransInfo GetTransInfo(string transNo)
{
using (var db = new EasyEsb())
{
var tis = from ti in db.TransInfo
where ti.TransNo == transNo
select ti;
return(tis.First());
}
}
public void TestMethod1()
{
using (EasyEsb db = new EasyEsb())
{
var transInfos = db.TransInfo;
foreach (var tran in transInfos)
{
Console.WriteLine(tran.TransID);
}
}
}
public IEnumerable <TransFieldInfo> GetTransFieldInfo(string transNo)
{
using (var db = new EasyEsb())
{
var tfis = from tfi in db.TransFieldInfo
from ti in db.TransInfo.Where(t => t.TransID == tfi.TransID)
where ti.TransNo == transNo
select tfi;
return(tfis);
}
}
public bool ValidateUser(string userName, string password, string transNo)
{
using (var db = new EasyEsb())
{
var userInfo = from ui in db.UserInfo
from gi in db.GroupInfo.Where(g => g.GroupID == ui.GroupID)
from ai in db.AuthorityInfo.Where(a => a.UserID == ui.UserID || a.GroupID == gi.GroupID)
where ui.UserName == userName && ui.Password == password && ai.TransNo == transNo
select ui;
if (userInfo.Count() != 1)
{
return(false);
}
return(true);
}
}
public string InvokeTrans(XmlDocument xdoc)
{
using (var db = new EasyEsb())
{
try
{
UserService userService = new UserService();
string userName = xdoc.SelectSingleNode("request/header/userid").InnerText;
string password = xdoc.SelectSingleNode("request/header/password").InnerText;
string transNo = xdoc.SelectSingleNode("request/header/trans_no").InnerText;
if (userService.ValidateUser(userName, password, transNo))
{
TransInfo ti = GetTransInfo(transNo);
IEnumerable <TransFieldInfo> tfis = GetTransFieldInfo(transNo);
#region 执行配置语句
db.Command.CommandType = CommandType.Text;
db.Command.CommandText = ti.Sql;
var tfisIn = tfis.Where(tfi => tfi.FieldDirection == false);
foreach (TransFieldInfo tfi in tfisIn)
{
//TODO 后期提为通用版本
db.Command.Parameters.Add(new SqlParameter(tfi.DFieldName,
xdoc.SelectSingleNode(string.Format("request/body/{0}", tfi.FieldName)).InnerText));
}
SqlDataAdapter sda = new SqlDataAdapter((SqlCommand)db.Command);
DataTable dt = new DataTable();
sda.Fill(dt);
var tfisOut = tfis.Where(tfi => tfi.FieldDirection == true);
foreach (TransFieldInfo tfi in tfisOut)
{
dt.Columns[tfi.DFieldName].ColumnName = tfi.FieldName;
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds.GetXml());
#region 模式1 要求配置顺序
//IDataReader sdr = db.Command.ExecuteReader();
//var tfisOut = tfis.Where(tfi => tfi.FieldDirection == true);
//DataTable dt = new DataTable();
//foreach (TransFieldInfo tfi in tfisOut)
//{
// dt.Columns.Add(tfi.FieldName);
//}
//while (sdr.Read())
//{
// DataRow dr = dt.NewRow();
// int i = 0;
// foreach (TransFieldInfo tfi in tfisOut)
// {
// dr[tfi.FieldName] = sdr.GetValue(i++);
// }
// dt.Rows.Add(dr);
//}
//DataSet ds = new DataSet();
//ds.Tables.Add(dt);
//return ds.GetXml();
#endregion
#endregion
}
return("error");
}
catch (Exception)
{
throw;
}
}
}
