public List <TB_PREMISEModel> GetJYDW(string keyword)
{
try
{
List <TB_PREMISEModel> datas = new List <TB_PREMISEModel>();
string where = "";
if (!string.IsNullOrEmpty(keyword))
{
where = $" AND (FCODE LIKE '%{keyword}%' OR FNAME LIKE '%{keyword}%' OR FID='{keyword}')";
}
else
{
where = "";
}
var helper = new OracleDBHelper();
datas = helper.GetWithWhereStrByPage <TB_PREMISEModel>(where);
return(datas);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 获取承运公司列表
/// </summary>
/// <param name="keyword">关键字</param>
/// <returns></returns>
//public List<TB_EXPRESSCOMPANYModel> GetExpressCompanyList(string keyword)
//{
// try
// {
// return TB_EXPRESSCOMPANYDal.Instance.GetAll().ToList();
// }
// catch (Exception ex)
// {
// LogHelper.WriteLog(ex);
// throw ex;
// }
//}
/// <summary>
/// 获取商品列表
/// </summary>
/// <param name="keyword"></param>
/// <returns></returns>
public List <ProductViewModel> GetProductList(hn.Core.Model.User loginUser, string keywords)
{
try
{
StringBuilder query = new StringBuilder();
if (!keywords.IsNullOrEmpty())
{
query.Append(" and ( ");
query.AppendFormat(" FPRODUCTNAME like '%{0}%' ", keywords);
query.AppendFormat(" OR FPRODUCTTYPE like '%{0}%' ", keywords);
query.AppendFormat(" OR FPRODUCTCODE like '%{0}%' ", keywords);
query.AppendFormat(" OR FMODEL like '%{0}%' ", keywords);
query.Append(" ) ");
}
if (loginUser.IsAdmin != 1)
{
//品牌/厂家进行数据权限控制
query.AppendFormat(" AND FBRANDID IN (SELECT FBRANDID FROM TB_USERBRAND WHERE FUSERID = '{0}') ", loginUser.FID);
}
return(ProductViewDal.Instance.GetWhereStr(query.ToStr()).ToList());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public V_CLIENTACCOUNTModel GetClientAccountSingle(string clientid)
{
try
{
return(V_CLIENTACCOUNTDal.Instance.Get(clientid));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 修改密码接口
/// </summary>
/// <param name="id"></param>
/// <param name="oldpwd">旧密码</param>
/// <param name="newpwd">新密码</param>
/// <returns></returns>
public string ModifyPassword(string id, string oldpwd, string newpwd)
{
try
{
return(UserBll.Instance.EditPassword(id, oldpwd, newpwd));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public SYS_SUBDICSMODEL GetSingleDics(string fid)
{
try
{
SYS_SUBDICSMODEL single = SYS_SUBDICSDAL.Instance.Get(fid);
return(single);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public List <SYS_SUBDICSMODEL> GetDics_Area(string categorycode, string keyword, bool all = false)
{
try
{
List <SYS_SUBDICSMODEL> datas = new List <SYS_SUBDICSMODEL>();
SYS_DICSMODEL parent = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = categorycode }).FirstOrDefault();
if (parent != null)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT * from SYS_SUBDICS where fclassid='" + parent.FID + "'");
sql.AppendLine(" and fid in(select fclassarea2 from v_icpr_icpo_icseout_thd where (leftsl>0 or leftsl is null) and autoid is not null and fdesbillno is not null)");
LogHelper.WriteLog(sql.ToStr());
var list = SYS_SUBDICSDAL.Instance.Query(sql.ToString()).OrderBy(m => m.FNAME).ToList();
LogHelper.WriteLog(sql.ToStr());
if (!string.IsNullOrEmpty(keyword))
{
foreach (var item in list)
{
if (string.IsNullOrEmpty(keyword) || item.FNAME.Contains(keyword))
{
datas.Add(item);
}
}
list = datas;
}
if (all)
{
list.Insert(0, new SYS_SUBDICSMODEL()
{
FNAME = "全部", FID = ""
});
}
return(list);
}
return(null);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 获取厂家发货基地列表
/// </summary>
/// <param name="productid"></param>
/// <returns></returns>
public List <TB_DELIVER_BASEModel> GetDeliverBaseList(string brand, string keyword)
{
try
{
string where = " and FBRAND='" + brand + "'";
if (!string.IsNullOrEmpty(keyword))
{
where += string.Format(" AND (FBASEA_NAME like '%{0}%' OR FADDRESS LIKE '%{0}%')", keyword);
}
return(TB_DELIVER_BASEDal.Instance.GetWhereStr(where).ToList());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 获取厂家代码列表
/// </summary>
/// <param name="keyword"></param>
/// <returns></returns>
public List <SRCModel> GetSrcList(string productid, string keyword)
{
try
{
string where = " and FPRODUCTID='" + productid + "'";
if (!string.IsNullOrEmpty(keyword))
{
where += string.Format(" AND (FSRCNAME like '%{0}%' OR FSRCCODE LIKE '%{0}%')", keyword);
}
return(SRCDal.Instance.GetWhereStr(where).ToList());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public V_CLIENTACCOUNTModel GetClientByAccount(string faccount)
{
try
{
var list = V_CLIENTACCOUNTDal.Instance.GetWhere(" FAccount='" + faccount + "'", null).ToList();
if (list.Count() > 0)
{
return(list[0]);
}
else
{
return(new V_CLIENTACCOUNTModel());
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public SYS_SUBDICSMODEL GetArea2(string fid)
{
try
{
List <SYS_SUBDICSMODEL> sys = SYS_SUBDICSDAL.Instance.GetWhere(new { FID = fid }).ToList();
if (sys.Count > 0)
{
return(sys[0]);
}
else
{
return(null);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 获取指定数据字典的列表数据
/// </summary>
/// <param name="categorycode"></param>
/// <returns></returns>
/// <returns></returns>
public List <SYS_SUBDICSMODEL> GetDics(string categorycode, string keyword, bool all = false)
{
try
{
List <SYS_SUBDICSMODEL> datas = new List <SYS_SUBDICSMODEL>();
SYS_DICSMODEL parent = SYS_DICSDAL.Instance.GetWhere(new { FCLASSCODE = categorycode }).FirstOrDefault();
if (parent != null)
{
var list = SYS_SUBDICSDAL.Instance.GetWhere(new { FCLASSID = parent.FID }).OrderBy(m => m.FNAME).ToList();
if (!string.IsNullOrEmpty(keyword))
{
foreach (var item in list)
{
if (string.IsNullOrEmpty(keyword) || item.FNAME.Contains(keyword))
{
datas.Add(item);
}
}
list = datas;
}
if (all)
{
list.Insert(0, new SYS_SUBDICSMODEL()
{
FNAME = "全部", FID = ""
});
}
return(list);
}
return(null);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 获取厂家账户列表
/// </summary>
/// <param name="brandid">品牌ID</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public List <V_CLIENTACCOUNTModel> GetClientAccountList(string brandid, string keyword)
{
try
{
string where = " and FBRANDID='" + brandid + "'";
//where += string.Format(" AND (FACCOUNT LIKE '%MN%')", keyword);
var l1 = V_CLIENTACCOUNTDal.Instance.GetWhereStr(where).OrderBy(x => x.FACCOUNT).ToList();
List <V_CLIENTACCOUNTModel> vList = new List <V_CLIENTACCOUNTModel>();
foreach (var sub in l1)
{
vList.Add(sub);
}
return(vList);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
/// <summary>
/// 用户登录接口
/// </summary>
/// <param name="username">登录用户名</param>
/// <param name="password">登录密码</param>
/// <returns></returns>
public User Login(string username, string password)
{
try
{
User u = UserDal.Instance.GetWhere(" USERNAME=:USERNAME", new{ USERNAME = username }).SingleOrDefault();
if (u != null)
{
if (u.IsDisabled != 1)
{
bool flag;
if (u.IS_DOMAIN == 1)
{
string domainname = ConfigurationManager.AppSettings["DomainName"];
//采用域验证登陆
flag = ADLogin.Login(domainname, username, password);
}
else
{
flag = UserBll.Instance.UserLoginByClient(username, password);
}
if (flag)
{
return(u);
}
}
}
return(null);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
throw ex;
}
}
public string SaveClient(ICPOBILLMODEL ICPOBILL, IEnumerable <ICPOBILLENTRYMODEL> ICPOBILLENTRYList)
{
OracleDBHelper helper = new OracleDBHelper();
var conn = helper.GetNewConnection();
conn.Open();
var tran = conn.BeginTransaction();
try
{
string FID = null;
#region 执行前检测
if (!ICPOBILL.FID.IsGuid())
{
ICPOBILLMODEL temp = ICPOBILLDAL.Instance.GetWhere(new { FBILLNO = ICPOBILL.FBILLNO }).FirstOrDefault();
if (temp != null && temp.FID != ICPOBILL.FID)
{
return("采购订单编号重复！");
}
}
#endregion
#region 保存主表
if (!ICPOBILL.FID.IsGuid())
{
FID = Guid.NewGuid().ToString();
ICPOBILL.FSTATUS = 1;
ICPOBILL.FSTATE = 1;
ICPOBILL.FBILLERNAME = ICPOBILL.FBILLER;
ICPOBILL.FBILLDATE = DateTime.Now;
ICPOBILL.FID = FID;
ICPOBILL.FSYNCSTATUS = 0;
helper.InsertWithTransation(ICPOBILL, tran);
}
else
{
FID = ICPOBILL.FID;
//var model = ICPOBILLDAL.Instance.Get(FID);
//model.FCLIENTID = ICPOBILL.FCLIENTID;
//model.FREMARK = ICPOBILL.FREMARK;
//model.FDATE = ICPOBILL.FDATE;
//model.FTELEPHONE = ICPOBILL.FTELEPHONE;
//model.Fpricepolicy = ICPOBILL.Fpricepolicy;
//model.FPOtype = ICPOBILL.FPOtype;
//model.Fnote = ICPOBILL.Fnote;
//model.FPREMISEID = ICPOBILL.FPREMISEID;
helper.UpdateWithTransation(ICPOBILL, tran);
}
#endregion
#region 保存子表
//删除明细
//ICPOBILLENTRYBLL.Instance.DeleteByICPOBILLID(FID);
helper.DeleteWithTran <ICPOBILLENTRYMODEL>($"AND FICPOBILLID='{FID}'", tran);
//保存明细
foreach (var item in ICPOBILLENTRYList)
{
item.FICPOBILLID = FID;
item.FID = Guid.NewGuid().ToString();
helper.InsertWithTransation(item, tran);
}
#endregion
tran.Commit();
conn.Dispose();
return(null);
}
catch (Exception e)
{
tran.Rollback();
LogHelper.Info("e.Message=" + e.Message);
throw;
}
}
