public UIResult SearchMerchant(MERCHANTEntity Data)
{
var res = service.ShglService.GetMerchantElement(Data);
return(new UIResult(
new
{
merchant = res.Item1,
merchantBrand = res.Item2,
treeorg = res.Item3
}
));
}
/// <summary>
/// 列表页的删除,可以批量删除
/// </summary>
/// <param name="DeleteData"></param>
public void DeleteMerchant(List <MERCHANTEntity> DeleteData)
{
foreach (var mer in DeleteData)
{
MERCHANTEntity Data = DbHelper.Select(mer);
if (Data.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("商户(" + Data.NAME + ")已经审核不能删除!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var mer in DeleteData)
{
DbHelper.Delete(mer);
}
Tran.Commit();
}
}
/// <summary>
/// 详情页的审核
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public string ExecData(MERCHANTEntity Data)
{
MERCHANTEntity mer = DbHelper.Select(Data);
if (mer.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("商户(" + Data.NAME + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
mer.VERIFY = employee.Id;
mer.VERIFY_NAME = employee.Name;
mer.VERIFY_TIME = DateTime.Now.ToString();
mer.STATUS = ((int)普通单据状态.审核).ToString();
DbHelper.Save(mer);
Tran.Commit();
}
return(mer.MERCHANTID);
}
/// <summary>
/// 从列表页编辑跳转到编辑页数据的展示查询
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public Tuple <dynamic, DataTable, dynamic> GetMerchantElement(MERCHANTEntity Data)
{
if (Data.MERCHANTID.IsEmpty())
{
throw new LogicException("请确认商户编号!");
}
string sql = $@"SELECT * FROM MERCHANT WHERE 1=1 ";
if (!Data.MERCHANTID.IsEmpty())
{
sql += (" AND MERCHANTID= " + Data.MERCHANTID);
}
DataTable merchant = DbHelper.ExecuteTable(sql);
merchant.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC");
string sqlitem = $@"SELECT M.BRANDID,C.NAME,D.CATEGORYCODE,D.CATEGORYNAME " +
" FROM MERCHANT_BRAND M,MERCHANT E,BRAND C,CATEGORY D " +
" where M.MERCHANTID = E.MERCHANTID AND M.BRANDID=C.ID AND C.CATEGORYID = D.CATEGORYID ";
if (!Data.MERCHANTID.IsEmpty())
{
sqlitem += (" and E.MERCHANTID= " + Data.MERCHANTID);
}
DataTable merchantBrand = DbHelper.ExecuteTable(sqlitem);
List <ORGEntity> p = DbHelper.SelectList(new ORGEntity()).OrderBy(a => a.ORGCODE).ToList();
var treeOrg = new UIResult(TreeModel.Create(p,
a => a.ORGCODE,
a => new TreeModel()
{
code = a.ORGCODE,
title = a.ORGNAME,
value = a.ORGID,
label = a.ORGNAME,
expand = true
})?.ToArray());
return(new Tuple <dynamic, DataTable, dynamic>(merchant.ToOneLine(), merchantBrand, treeOrg));
}
/// <summary>
/// 编辑页的保存
/// </summary>
/// <param name="SaveData"></param>
/// <returns></returns>
public string SaveMerchant(MERCHANTEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.MERCHANTID.IsEmpty())
{
SaveData.MERCHANTID = NewINC("MERCHANT").PadLeft(4, '0'); //暂定6位
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
}
else
{
MERCHANTEntity mer = DbHelper.Select(SaveData);
SaveData.VERIFY = mer.VERIFY;
SaveData.VERIFY_NAME = mer.VERIFY_NAME;
SaveData.VERIFY_TIME = mer.VERIFY_TIME;
}
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
v.Require(a => a.MERCHANTID);
v.Require(a => a.NAME);
v.IsUnique(a => a.MERCHANTID);
v.IsUnique(a => a.NAME);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.MERCHANT_BRAND?.ForEach(shpp =>
{
GetVerify(shpp).Require(a => a.BRANDID);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
return(SaveData.MERCHANTID);
}
public string Save(MERCHANTEntity SaveData)
{
return(service.ShglService.SaveMerchant(SaveData));
}
public void ExecData(MERCHANTEntity Data)
{
service.ShglService.ExecData(Data);
}
