public bool T12067Check(M12263 t12263, string siteCode)
{
//Command(
// $"SELECT* FROM T12067, T12121 WHERE T12121.T_EMP_CODE = T12067.T_BB_ISSUED_BY AND T12067.T_BLOOD_REQNO = '{t12263.T_BLOOD_REQNO}' AND T12067.T_UNIT_NO = '{t12263.T_UNIT_NO}' AND T12067.T_PRODUCT_CODE = '{t12263.T_PRODUCT_CODE}' AND T12067.T_BLOOD_GRP = '{t12263.T_BLOOD_GRP}' AND T12067.T_SITE_CODE = '{siteCode}' AND T12067.T_ZONE_CODE = '{ZoneCode}'");
return(Query($@"SELECT * FROM T12067, T01009 WHERE T01009.T_EMP_CODE = T12067.T_BB_ISSUED_BY AND T12067.T_BLOOD_REQNO = '{t12263.T_BLOOD_REQNO}' AND T12067.T_UNIT_NO = '{t12263.T_UNIT_NO}' AND
T12067.T_PRODUCT_CODE = '{t12263.T_PRODUCT_CODE}' AND T12067.T_BLOOD_GRP = '{t12263.T_BLOOD_GRP}' AND T12067.T_SITE_CODE = '{t12263.T_SITE_CODE}'").Rows.Count > 0);
}
public bool InsertT12091(M12263 t12263, string user)
{
var max = Query($"SELECT MAX(TO_NUMBER(T_REQ_ID))+1 ID FROM T12091").Rows[0]["ID"].ToString();
Command($@"UPDATE T12092 SET T_STATUS = '1' WHERE T_EMP_CODE = '{t12263.T_DELIVERY_MAN}'");
Command(
$"INSERT INTO T12091(T_REQ_ID,T_ENTRY_USER,T_ENTRY_DATE,T_ENTRY_TIME,T_BLOOD_REQ_NO,T_SITE_CODE,T_EMP_CODE,T_ESTIMATED_DELIVERY_DIST,T_ESTIMATED_DELIVERY_TIME) VALUES ('{max}','{user}',Trunc(sysdate),TO_CHAR(SYSDATE,'HH24MI'), '{t12263.T_BLOOD_REQNO}', '{t12263.T_SITE_CODE}','{t12263.T_DELIVERY_MAN}','{t12263.ESTIMATE_DISTANCE}','{t12263.ESTIMATE_TIME}')");
return(true);
}
public bool UpdateT12065(M12263 t63, string T_REQUEST_STATUS)
{
return(Command($@"UPDATE T12065 SET T_REQUEST_STATUS = '{T_REQUEST_STATUS}',T_COURIER_CODE='{t63.T_COURIER_CODE}',T_TRACKING_NO='{t63.T_TRACKING_NO}',T_ESTIMATED_DELIVERY_TIME='{t63.T_ESTIMATED_DELIVERY_TIME}',T_DELIVERY_MAN='{t63.T_DELIVERY_MAN}',T_ESTIMATION_TYPE='{t63.T_ESTIMATION_TYPE}' WHERE T_BLOOD_REQNO = '{t63.T_BLOOD_REQNO}' AND T_SITE_CODE = '{t63.T_SITE_CODE}'"));
}
public bool UpdateT12019(M12263 t12263)
{
return(Command($@"UPDATE T12019 SET T_SENT_OUTSIDE_FLAG = '1', T_UNIT_STATUS = '9' WHERE T_UNIT_NO = '{t12263.T_UNIT_NO}' AND T_ABO_CODE = '{t12263.T_BLOOD_GRP}' AND T_PRODUCT_CODE = '{t12263.T_PRODUCT_CODE}'"));
}
public bool T12263insertT12067(M12263 t12263, string user, string siteCode)
{
Command(
$"INSERT INTO T12067 (T_ENTRY_USER,T_ENTRY_DATE,T_BLOOD_GRP,T_PRODUCT_CODE,T_BLOOD_REQNO,T_UNIT_NO,T_BB_ISSUED_BY,T_BB_ISSUED_DATE,T_BB_ISSUED_TIME,T_BLOOD_EXPIRY_DATE,T_SITE_CODE) VALUES ('{user}',Trunc(sysdate), '{t12263.T_BLOOD_GRP}', '{t12263.T_PRODUCT_CODE}', '{t12263.T_BLOOD_REQNO}', '{t12263.T_UNIT_NO}', '{t12263.T_BB_ISSUED_BY}',Trunc(sysdate),TO_CHAR(SYSDATE,'HH24MI'),TO_DATE('{t12263.T_BLOOD_EXPIRY_DATE}','DD/MM/YYYY'),'{t12263.T_SITE_CODE}')");
return(true);
}
public bool checkT91(M12263 m12263)
{
return(Query($"SELECT * FROM T12091 WHERE T_BLOOD_REQ_NO ='{m12263.T_BLOOD_REQNO}' AND T_REQ_CANCEL_FLG ='1'").Rows.Count > 0);
}
