public Tuple <dynamic, DataTable> GetStaionElement(STATIONEntity Data)
{
string sql = $@"select S.STATIONBH,S.TYPE,S.IP,S.SHOPID,S.NETWORK_NODE_ADDRESS from STATION S where 1=1 ";
if (!Data.STATIONBH.IsEmpty())
{
sql += $" and S.STATIONBH = '{ Data.STATIONBH}'";
}
sql += " order by S.STATIONBH";
DataTable station = DbHelper.ExecuteTable(sql);
var sqlpay = $@"SELECT S.STATIONBH,S.PAYID,P.NAME from STATION_PAY S,PAY P WHERE S.PAYID=P.PAYID ";
if (!Data.STATIONBH.IsEmpty())
{
sqlpay += $" and STATIONBH = '{Data.STATIONBH.ToString()}'";
}
sqlpay += " order by S.PAYID";
DataTable pay = DbHelper.ExecuteTable(sqlpay);
return(new Tuple <dynamic, DataTable>(station.ToOneLine(), pay));
}
public void DeleteStation(STATIONEntity DeleteData)
{
var v = GetVerify(DeleteData);
string sql = $@"delete from STATION_PAY where STATIONBH=" + DeleteData.STATIONBH.ToString();
DbHelper.ExecuteNonQuery(sql);
DbHelper.Delete(DeleteData);
}
public UIResult SearchStation(STATIONEntity Data)
{
var res = service.XtglService.GetStaionElement(Data);
return(new UIResult(
new
{
Station = res.Item1,
Pay = res.Item2
}
));
}
public string SaveSataion(STATIONEntity DefineSave)
{
var v = GetVerify(DefineSave);
if (DefineSave.STATIONBH.IsEmpty())
{
DefineSave.STATIONBH = CommonService.NewINC("STATION").PadLeft(5, '0');
}
v.Require(a => a.STATIONBH);
v.Require(a => a.BRANCHID);
v.Require(a => a.TYPE);
v.Require(a => a.IP);
v.IsUnique(a => a.IP);
//生成终端密钥，调用销售数据采集接口时用
if (DefineSave.Encryption.IsEmpty())
{
DefineSave.Encryption = MD5Encryption.Encrypt($"z.DGS.LoginSalt{DefineSave.STATIONBH }");
}
DefineSave.STATION_PAY?.ForEach(sdb =>
{
GetVerify(sdb).Require(a => a.PAYID);
});
v.Verify();
using (var tran = DbHelper.BeginTransaction())
{
DbHelper.Save(DefineSave);
tran.Commit();
}
return(DefineSave.STATIONBH);
}
public void Delete(STATIONEntity DefineDelete)
{
service.XtglService.DeleteStation(DefineDelete);
}
public string Save(STATIONEntity DefineSave)
{
return(service.XtglService.SaveSataion(DefineSave));
}
