public int GetrOrAddUser(string userName)
{
using (ProofDataContext pdc = new ProofDataContext())
{
string pym = userName.ToLower();
var re = pdc.xt_ryb.Where(p => p.xm == userName).FirstOrDefault();
if (re == null)
{
int ghid = int.Parse(pdc.xt_ryb.Max(p => p.gh));
pdc.xt_ryb.Add(new xt_ryb
{
id_dept = 3,
rylb = "1",
gzlb = "1",
xm = userName,
pym = PinyinHelper.PinyinString(userName),
mm = "123",
xb = "1",
gh = (ghid + 1).ToString(),
});
pdc.SaveChanges();
re = pdc.xt_ryb.Where(p => p.xm == userName).FirstOrDefault();
}
return(re.id);
}
}
public List <string> GetClientList()
{
using (ProofDataContext pdc = new ProofDataContext())
{
var ns = pdc.xt_khb.Select(p => p.khmc).ToList();
return(ns);
}
}
public bool AddOrUpdataGlRecord(ProofTask task)
{
using (ProofDataContext pdc = new ProofDataContext())
{
try
{
var yd = pdc.ypgl_yd.FirstOrDefault(p => p.dydbh == task.Order.Dydbh);
if (yd == null)
{
return(false);
}
var gy = pdc.ypgl_gyzbjl.FirstOrDefault(p => p.id_yd == yd.id && p.task_id == task.Id);
if (gy == null)
{
gy = new ypgl_gyzbjl()
{
id_dept = 1,
id_yd = yd.id,
gg = "均码",
ry_gy = task.UserName,
ry_zb = "a",
fsj_gy = task.BeginDate,
jhsj_gy = task.NeedFinshDate,
task_id = task.Id,
sl = (short)task.Order.ProofNum,
};
pdc.ypgl_gyzbjl.Add(gy);
}
else
{
gy.ry_gy = task.UserName;
gy.fsj_gy = task.BeginDate;
gy.jhsj_gy = task.NeedFinshDate;
gy.sl = (short)task.Order.ProofNum;
gy.task_id = task.Id;
}
pdc.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public int GetOrAddClient(string clientName)
{
using (ProofDataContext pdc = new ProofDataContext())
{
string c = clientName.ToLower();
string pym = PinyinHelper.PinyinString(clientName).ToLower();
var re = pdc.xt_khb.Where(p => p.khmc.ToLower() == c).FirstOrDefault();
if (re == null)
{
pdc.xt_khb.Add(new xt_khb
{
khmc = clientName,
khqc = clientName,
rq = DateTime.Now,
bz_dd = 1,
address = "内部同步客户",
pym = pym == "" ? clientName : pym,
});
pdc.SaveChanges();
re = pdc.xt_khb.Where(p => p.khmc.ToLower() == c).FirstOrDefault();
}
return(re.id);
}
}
