public CAS_MAIN_INFO GetCASByNo(string CASNo)
{
CAS_MAIN_INFO CASInfo = (
from p in context.CAS_MAIN_INFO
where p.CAS_NUMBER.Equals(CASNo)
select p).FirstOrDefault();
return(CASInfo);
}
public CAS_MAIN_INFO GetCASByCID(string CID)
{
CAS_MAIN_INFO CASInfo = (
from a in context.CAS_MAIN_INFO
where a.PUB_CID == CID
select a).FirstOrDefault();
return(CASInfo);
}
public CAS_MAIN_INFO GetCASByCAS_NO(string CAS_NO)
{
CAS_MAIN_INFO CASInfo = (
from a in context.CAS_MAIN_INFO
where a.CAS_NO == CAS_NO
select a).FirstOrDefault();
return(CASInfo);
}
public void UpdateCASStatus(string CAS_NO, string CAS_STATUS)
{
CAS_MAIN_INFO nullable = context.CAS_MAIN_INFO.FirstOrDefault((CAS_MAIN_INFO m) => m.CAS_NO == CAS_NO);
if (!string.IsNullOrEmpty(CAS_STATUS))
{
int i;
if (int.TryParse(CAS_STATUS, out i))
{
nullable.IS_AUDIT = int.Parse(CAS_STATUS);
}
}
context.SaveChanges();
}
public void UpdateCAS(CAS_MAIN_INFO casinfo)
{
CAS_MAIN_INFO cas = context.CAS_MAIN_INFO.FirstOrDefault((CAS_MAIN_INFO m) => m.CAS_NO == casinfo.CAS_NO);
cas.CAS_NO = casinfo.CAS_NO;
cas.CAS_NUMBER = casinfo.CAS_NUMBER;
cas.CHINESE = casinfo.CHINESE;
cas.CHINESE_ALIAS = casinfo.CHINESE_ALIAS;
cas.ENGLISH = casinfo.ENGLISH;
cas.ENGLISH_ALIAS = casinfo.ENGLISH_ALIAS;
cas.MOLECULAR_FORMULA = casinfo.ENGLISH_ALIAS;
cas.MOLECULAR_WEIGHT = casinfo.MOLECULAR_WEIGHT;
cas.PRECISE_QUALITY = casinfo.ENGLISH_ALIAS;
cas.PSA = casinfo.PSA;
cas.DENSITY = casinfo.DENSITY;
cas.BOILING_POINT = casinfo.BOILING_POINT;
cas.FLASH_POINT = casinfo.FLASH_POINT;
cas.REFRACTIVE_INDEX = casinfo.REFRACTIVE_INDEX;
cas.VAPOR_PRESSURE = casinfo.VAPOR_PRESSURE;
cas.CAS_CATEGORY = casinfo.CAS_CATEGORY;
cas.SOURCE_FROM = casinfo.SOURCE_FROM;
cas.SOURCE_FROM_LINK = casinfo.SOURCE_FROM_LINK;
cas.AVAILABLE_DATE = casinfo.AVAILABLE_DATE;
cas.STRUCTURE_2D = casinfo.STRUCTURE_2D;
cas.EXTERNAL_ID = casinfo.EXTERNAL_ID;
cas.EXTERNAL_LINK = casinfo.EXTERNAL_LINK;
cas.COMMENT = casinfo.COMMENT;
cas.VERSION = casinfo.VERSION;
cas.ADD_DATE = DateTime.Now;
cas.ADD_AUTHOR = casinfo.ADD_AUTHOR;
cas.IS_DEL = casinfo.IS_DEL;
cas.DEL_UID = casinfo.DEL_UID;
cas.DEL_TIME = casinfo.DEL_TIME;
cas.IS_UPDATE = casinfo.IS_UPDATE;
cas.UPDATE_UID = casinfo.UPDATE_UID;
cas.UPDATE_TIME = DateTime.Now;
cas.AUDIT_UID = casinfo.AUDIT_UID;
cas.AUDIT_TIME = casinfo.AUDIT_TIME;
cas.AUDIT_DESC = casinfo.AUDIT_DESC;
//cas.IS_LOCK = casinfo.IS_LOCK;
context.SaveChanges();
}
public void AddCAS(CAS_MAIN_INFO casinfo)
{
context.CAS_MAIN_INFO.Add(casinfo);
context.SaveChanges();
}
