public ShopsecuritySelectBuild WhereIdcardLike(params string[] Idcard)
{
if (Idcard == null || Idcard.Where(a => !string.IsNullOrEmpty(a)).Any() == false)
{
return(this);
}
return(this.Where1Or(@"a.`idcard` LIKE {0}", Idcard.Select(a => "%" + a + "%").ToArray()));
}
/// <summary>
/// 查询储户 （注册的,绑定卡号的）根据储户账号查询
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public Idcard QueryData(int ICid)
{
Idcard idCard = new Idcard();
using (var dbContext = new bankContext())
{
return(idCard = dbContext.Idcard.FirstOrDefault(a => a.Icid == ICid));
}
}
/// <summary>
/// 储户绑定卡号,先找到该储户，然后找到该储户要绑定的银行卡，最后绑定
/// </summary>
/// <param name="depositor">前端传入DepositorAndCard对象，属性：Duid,Dname,Dcid</param>
/// <returns></returns>
public DepositorAndCard UpdataBandService(DepositorAndCard depositor)
{
Idcard idcard = new Idcard();
DepositorAndCard DAndC = new DepositorAndCard(); //返回对象
Cards card = new Cards(); //接受返回数据
Depositors depositor1 = new Depositors(); //接受查询到的数据
depositor1 = accessDepositors.CheakData(depositor.Duid); //查询有没有该储户
if (depositor1 != null) //有数据
{
if (depositor1.Uid == depositor.Duid) //判断查找到的储户是不是我们要找的
{
card = cardsService.CheakCardsService((int)depositor.Dcid);
if (card != null && card.Cuid == depositor.Duid && card.Cicid == depositor.Dicid) //判断查找到的银行卡是不是我们要找的
{
accessDepositors.UpdataBandData(depositor); //更新绑定卡号
idcard = idcardService.QueryService(card.Cicid);
DAndC.Dname = idcard.Icname;
DAndC.Dcid = depositor.Dcid;
DAndC.Duid = depositor.Duid;
}
else
{
DAndC = null;
}
}
else
{
DAndC = null;
}
}
else
{
DAndC = null;
}
return(DAndC);
}
public override string ToString()
{
string json = string.Concat(
__jsonIgnore.ContainsKey("Shop_id") ? string.Empty : string.Format(", Shop_id : {0}", Shop_id == null ? "null" : Shop_id.ToString()),
__jsonIgnore.ContainsKey("Idcard") ? string.Empty : string.Format(", Idcard : {0}", Idcard == null ? "null" : string.Format("'{0}'", Idcard.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
__jsonIgnore.ContainsKey("Idcard_img1") ? string.Empty : string.Format(", Idcard_img1 : {0}", Idcard_img1 == null ? "null" : string.Format("'{0}'", Idcard_img1.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
__jsonIgnore.ContainsKey("Idcard_img2") ? string.Empty : string.Format(", Idcard_img2 : {0}", Idcard_img2 == null ? "null" : string.Format("'{0}'", Idcard_img2.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
__jsonIgnore.ContainsKey("License_img") ? string.Empty : string.Format(", License_img : {0}", License_img == null ? "null" : string.Format("'{0}'", License_img.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))), " }");
return(string.Concat("{", json.Substring(1)));
}
public override int GetHashCode()
{
return(Idcard.GetHashCode());
}
public async Task <ServiceResponse <string> > AddNumber(int id, int nomor, DateTime masa, string status, string catatan, int userId)
{
var response = new ServiceResponse <string>();
var pengajuan = await _context.Tb_pengajuan.Include(c => c.Vendor).FirstOrDefaultAsync(c => c.Id == id && c.Status_pengajuan == "1");
var user = await _context.Tb_user.FirstOrDefaultAsync(c => c.Id == userId);
var idcard = new Idcard();
if (pengajuan == null || (status != "0" && status != "1"))
{
response.Status = false;
response.Message = (pengajuan == null ? "Pengajuan tidak ditemukan" : "Status Salah");
return(response);
}
DateTime masaAuto = Convert.ToDateTime((DateTime.Now.Year + 1).ToString() + '-' + pengajuan.Tgl_lahir.Month.ToString() + '-' + pengajuan.Tgl_lahir.Day.ToString());
masa = masa.Year == 00001 ? masaAuto : masa;
if (status == "1")
{
if (nomor == 0 || await NomorExists(nomor))
{
response.Status = false;
response.Message = (nomor == 0 ? "inputan tidak lengkap" : "Nomor Id Card sudah Digunakan");
return(response);
}
}
var data = await _context.Tb_idcard.FirstOrDefaultAsync(c => c.Pengajuan == pengajuan);
var proses = await _context.Tb_proses.OrderByDescending(c => c.Id).FirstOrDefaultAsync(c => c.Pengajuan == pengajuan);
if (data == null)
{
idcard.Nik = pengajuan.Nik;
idcard.Nomor_idcard = nomor;
idcard.Masa_berlaku = masa;
idcard.Status = false;
idcard.Pengajuan = pengajuan;
idcard.Sistem_created_time = DateTime.Now;
idcard.Tanggal = DateTime.Now;
}
else
{
idcard = data;
idcard.Nomor_idcard = nomor;
idcard.Masa_berlaku = masa;
idcard.Tanggal = DateTime.Now;
idcard.Status = false;
}
var prosesAdmin = new Proses();
prosesAdmin.Status_proses = status;
prosesAdmin.Tanggal_proses = DateTime.Now;
prosesAdmin.Pengajuan = pengajuan;
prosesAdmin.User = user;
if (status == "0")
{
prosesAdmin.Catatan = catatan;
}
try
{
proses.Status_proses = "2";
proses.Next = user;
pengajuan.Status_pengajuan = (status == "0" ? "3" : "2");
pengajuan.Sistem_updated_time = DateTime.Now;
if (status == "1")
{
if (data == null)
{
await _context.Tb_idcard.AddAsync(idcard);
}
else
{
_context.Tb_idcard.Update(data);
}
await _context.SaveChangesAsync();
}
_context.Tb_pengajuan.Update(pengajuan);
await _context.SaveChangesAsync();
_context.Tb_proses.Update(proses);
await _context.SaveChangesAsync();
await _context.Tb_proses.AddAsync(prosesAdmin);
await _context.SaveChangesAsync();
response.Message = (status == "1" ? "Update Nomor Id Card Berhasil" : "Pengajuan Berhasil Ditolak");
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
}
return(response);
}
