private string CreateAppCallInMsg(AppCallInfo aci) { StringBuilder message = new StringBuilder(); message.Append("[5180"); message.Append("caseId:" + aci.CASEID + "*#"); message.Append("phone:" + aci.PHONE + "*#"); message.Append("name:" + aci.NAME + "*#"); message.Append("sex:" + aci.SEX + "*#"); message.Append("brithday:" + aci.BRITHDAY + "*#"); message.Append("height:" + aci.HEIGHT.ToString() + "*#"); message.Append("weight:" + aci.WEIGHT.ToString() + "*#"); message.Append("identityCard:" + aci.IDENTITYCARD + "*#"); message.Append("jd:" + aci.JD + "*#"); message.Append("wd:" + aci.WD + "*#"); message.Append("address:" + aci.ADDRESS + "*#"); message.Append("medicalHistory:" + aci.MEDICALHISTORY + "*#"); message.Append("contactWay1:" + aci.CONTACTWAY1 + "*#"); message.Append("contactWay2:" + aci.CONTACTWAY2 + "*#"); message.Append("contactWay3:" + aci.CONTACTWAY3 + "*#"); message.Append("medicalInsuranceCard:" + aci.MEDICALINSURANCECARD + "*#"); message.Append("province:" + aci.PROVINCE + "*#"); message.Append("city:" + aci.CITY + "*#"); message.Append("callTime:" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", aci.CALLTIME) + "*#"); message.Append("isSelf:" + aci.ISSELF.ToString() + "*#"); message.Append("]"); return(message.ToString()); }
/// <summary> /// 获取最新的呼救信息 /// </summary> /// <returns></returns> public List <AppCallInfo> GetNewCallInfo() { List <AppCallInfo> list = new List <AppCallInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select CASEID,PHONE,PROVINCE,CITY,AREA,CALLTIME,ISSELF,NAME,SEX,BRITHDAY,HEIGHT,WEIGHT,IDENTITYCARD,JD,WD,ADDRESS,MEDICALHISTORY,CONTACTWAY1,CONTACTWAY2,CONTACTWAY3,MEDICALINSURANCECARD,ADDTIME "); strSql.Append(" from (select * from AppCallInfo where (sysdate-CALLTIME)*24*60*60<300 and READFLAG=0 order by CALLTIME) where rownum<=100 "); OracleParameter[] parameters = { }; DataSet ds = DbHelperOra.Query(SysParameters.DBConnectString, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { ArrayList arrayList = new ArrayList(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { AppCallInfo model = DataRowToModel(ds.Tables[0].Rows[i]); list.Add(model); arrayList.Add(string.Format("update AppCallInfo set READFLAG=1,READTIME=sysdate where CASEID='{0}'", model.CASEID)); } //更新读取标志 ExcuteSqlList(arrayList); } return(list); }
private string CreateCallInfoJsonByModel(AppCallInfo aci) { Hashtable htCallInfo = new Hashtable(); htCallInfo.Add("messageName", "CallInfo"); htCallInfo.Add("phone", aci.PHONE); htCallInfo.Add("name", aci.NAME); htCallInfo.Add("sex", aci.SEX); htCallInfo.Add("brithday", aci.BRITHDAY); htCallInfo.Add("height", aci.HEIGHT); htCallInfo.Add("weight", aci.WEIGHT); htCallInfo.Add("identityCard", aci.IDENTITYCARD); htCallInfo.Add("jd", aci.JD); htCallInfo.Add("wd", aci.WD); htCallInfo.Add("address", aci.ADDRESS); htCallInfo.Add("medicalHistory", aci.MEDICALHISTORY); htCallInfo.Add("contactWay1", aci.CONTACTWAY1); htCallInfo.Add("contactWay2", aci.CONTACTWAY2); htCallInfo.Add("contactWay3", aci.CONTACTWAY3); htCallInfo.Add("medicalInsuranceCard", aci.MEDICALINSURANCECARD); htCallInfo.Add("caseId", aci.CASEID); htCallInfo.Add("province", aci.PROVINCE); htCallInfo.Add("city", aci.CITY); htCallInfo.Add("area", aci.AREA); htCallInfo.Add("callTime", string.Format("{0:yyyy-MM-dd HH:mm:ss}", aci.CALLTIME)); htCallInfo.Add("isSelf", aci.ISSELF); return(JSON.Encode(htCallInfo)); }
/// <summary> /// 获取最新的呼救信息 /// </summary> /// <returns></returns> public List <AppCallInfo> GetNewCallInfo() { List <AppCallInfo> list = new List <AppCallInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append(" select * from AppCallInfo where TIMESTAMPDIFF(SECOND,CALLTIME,now()) <300 and READFLAG=0 order by CALLTIME limit 100 "); MySqlParameter[] parameters = { }; DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { List <string> arrayList = new List <string>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { AppCallInfo model = DataRowToModel(ds.Tables[0].Rows[i]); list.Add(model); arrayList.Add(string.Format("update AppCallInfo set READFLAG=1,READTIME=now() where CASEID='{0}'", model.CASEID)); } //更新读取标志 ExcuteSqlList(arrayList); } return(list); }
/// <summary> /// 给120业务服务器发送APP呼救信息 /// </summary> /// <param name="aci"></param> public void SendAppCallInMessage(AppCallInfo aci) { try { string message = CreateAppCallInMsg(aci); SendMessage(message); } catch (Exception ex) { LogHelper.WriteLog("", ex); } }
/// <summary> /// 根据CASEID 获取 单位编号 /// </summary> /// <param name="CaseId"></param> /// <returns></returns> public string GetUnitCodeByCaseId(string CaseId) { string UnitCode = ""; DBAppCallInfo dba = new DBAppCallInfo(); DBRouter router = new DBRouter(); AppCallInfo aci = dba.GetAppCallInfoByCaseId(CaseId); if (aci != null) { UnitCode = router.GetUnitCodeByRegistCity(aci.PROVINCE, aci.CITY, aci.AREA); } return(UnitCode); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AppCallInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AppCallInfo("); strSql.Append("CASEID,PHONE,PROVINCE,CITY,AREA,CALLTIME,ISSELF,NAME,SEX,BRITHDAY,HEIGHT,WEIGHT,IDENTITYCARD,JD,WD,ADDRESS,MEDICALHISTORY,CONTACTWAY1,CONTACTWAY2,CONTACTWAY3,MEDICALINSURANCECARD,ADDTIME)"); strSql.Append(" values ("); strSql.Append(":CASEID,:PHONE,:PROVINCE,:CITY,:AREA,:CALLTIME,:ISSELF,:NAME,:SEX,:BRITHDAY,:HEIGHT,:WEIGHT,:IDENTITYCARD,:JD,:WD,:ADDRESS,:MEDICALHISTORY,:CONTACTWAY1,:CONTACTWAY2,:CONTACTWAY3,:MEDICALINSURANCECARD,:ADDTIME)"); OracleParameter[] parameters = { new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)), new OracleParameter(":PHONE", DBOpHelper.GetString(model.PHONE)), new OracleParameter(":PROVINCE", DBOpHelper.GetString(model.PROVINCE)), new OracleParameter(":CITY", DBOpHelper.GetString(model.CITY)), new OracleParameter(":AREA", DBOpHelper.GetString(model.AREA)), new OracleParameter(":CALLTIME", DBOpHelper.GetDateTime(model.CALLTIME.ToString())), new OracleParameter(":ISSELF", DBOpHelper.GetNumber(model.ISSELF.ToString())), new OracleParameter(":NAME", DBOpHelper.GetString(model.NAME)), new OracleParameter(":SEX", DBOpHelper.GetNumber(model.SEX.ToString())), new OracleParameter(":BRITHDAY", DBOpHelper.GetString(model.BRITHDAY)), new OracleParameter(":HEIGHT", DBOpHelper.GetNumber(model.HEIGHT.ToString())), new OracleParameter(":WEIGHT", DBOpHelper.GetNumber(model.WEIGHT.ToString())), new OracleParameter(":IDENTITYCARD", DBOpHelper.GetString(model.IDENTITYCARD)), new OracleParameter(":JD", DBOpHelper.GetString(model.JD)), new OracleParameter(":WD", DBOpHelper.GetString(model.WD)), new OracleParameter(":ADDRESS", DBOpHelper.GetString(model.ADDRESS)), new OracleParameter(":MEDICALHISTORY", DBOpHelper.GetString(model.MEDICALHISTORY)), new OracleParameter(":CONTACTWAY1", DBOpHelper.GetString(model.CONTACTWAY1)), new OracleParameter(":CONTACTWAY2", DBOpHelper.GetString(model.CONTACTWAY2)), new OracleParameter(":CONTACTWAY3", DBOpHelper.GetString(model.CONTACTWAY3)), new OracleParameter(":MEDICALINSURANCECARD", DBOpHelper.GetString(model.MEDICALINSURANCECARD)), new OracleParameter(":ADDTIME", DBOpHelper.GetDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))) }; int rows = DbHelperOra.ExecuteSql(SysParameters.DBConnectString, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AppCallInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into appcallinfo("); strSql.Append("CASEID,PHONE,PROVINCE,CITY,AREA,CALLTIME,ISSELF,NAME,SEX,BRITHDAY,HEIGHT,WEIGHT,IDENTITYCARD,JD,WD,ADDRESS,MEDICALHISTORY,CONTACTWAY1,CONTACTWAY2,CONTACTWAY3,MEDICALINSURANCECARD,ADDTIME)"); strSql.Append(" values ("); strSql.Append("@CASEID,@PHONE,@PROVINCE,@CITY,@AREA,@CALLTIME,@ISSELF,@NAME,@SEX,@BRITHDAY,@HEIGHT,@WEIGHT,@IDENTITYCARD,@JD,@WD,@ADDRESS,@MEDICALHISTORY,@CONTACTWAY1,@CONTACTWAY2,@CONTACTWAY3,@MEDICALINSURANCECARD,@ADDTIME)"); MySqlParameter[] parameters = { new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)), new MySqlParameter("@PHONE", DBOpHelper.GetString(model.PHONE)), new MySqlParameter("@PROVINCE", DBOpHelper.GetString(model.PROVINCE)), new MySqlParameter("@CITY", DBOpHelper.GetString(model.CITY)), new MySqlParameter("@AREA", DBOpHelper.GetString(model.AREA)), new MySqlParameter("@CALLTIME", DBOpHelper.GetDateTime(model.CALLTIME.ToString())), new MySqlParameter("@ISSELF", DBOpHelper.GetNumber(model.ISSELF.ToString())), new MySqlParameter("@NAME", DBOpHelper.GetString(model.NAME)), new MySqlParameter("@SEX", DBOpHelper.GetNumber(model.SEX.ToString())), new MySqlParameter("@BRITHDAY", DBOpHelper.GetString(model.BRITHDAY)), new MySqlParameter("@HEIGHT", DBOpHelper.GetNumber(model.HEIGHT.ToString())), new MySqlParameter("@WEIGHT", DBOpHelper.GetNumber(model.WEIGHT.ToString())), new MySqlParameter("@IDENTITYCARD", DBOpHelper.GetString(model.IDENTITYCARD)), new MySqlParameter("@JD", DBOpHelper.GetString(model.JD)), new MySqlParameter("@WD", DBOpHelper.GetString(model.WD)), new MySqlParameter("@ADDRESS", DBOpHelper.GetString(model.ADDRESS)), new MySqlParameter("@MEDICALHISTORY", DBOpHelper.GetString(model.MEDICALHISTORY)), new MySqlParameter("@CONTACTWAY1", DBOpHelper.GetString(model.CONTACTWAY1)), new MySqlParameter("@CONTACTWAY2", DBOpHelper.GetString(model.CONTACTWAY2)), new MySqlParameter("@CONTACTWAY3", DBOpHelper.GetString(model.CONTACTWAY3)), new MySqlParameter("@MEDICALINSURANCECARD", DBOpHelper.GetString(model.MEDICALINSURANCECARD)), new MySqlParameter("@ADDTIME", DBOpHelper.GetDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))) }; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取最新的呼救信息 /// </summary> /// <returns></returns> public AppCallInfo GetAppCallInfoByCaseId(string strCaseId) { AppCallInfo model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("select CASEID,PHONE,PROVINCE,CITY,AREA,CALLTIME,ISSELF,NAME,SEX,BRITHDAY,HEIGHT,WEIGHT,IDENTITYCARD,JD,WD,ADDRESS,MEDICALHISTORY,CONTACTWAY1,CONTACTWAY2,CONTACTWAY3,MEDICALINSURANCECARD,ADDTIME "); strSql.Append(" from AppCallInfo where CASEID = '" + strCaseId + "'"); OracleParameter[] parameters = { }; DataSet ds = DbHelperOra.Query(SysParameters.DBConnectString, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model = DataRowToModel(ds.Tables[0].Rows[0]); } return(model); }
private void HandleAppCallInfo(AppCallInfo aci) { try { IDBRouter router = DataAccess.DataAccess.GetDBRouter(); string strUnitCode = router.GetUnitCodeByRegistCity(aci.PROVINCE, aci.CITY, aci.AREA); if (string.IsNullOrEmpty(strUnitCode)) { //send error msg to app server HandleCallError hce = new HandleCallError(); hce.CASEID = aci.CASEID; hce.ERRORCODE = "1"; hce.ERRORMSG = "未注册APP急救服务"; hce.ERRORTIME = DateTime.Now; Appserver.SendCallError(hce); } else { ServerClient client = CoreService.GetInstance().CallInServer.GetServerClientByUnitCode(strUnitCode); if (client != null) { //send msg to app client string msg = CreateCallInfoJsonByModel(aci); client.SendMessage(new ScsTextMessage(msg)); } else { //send error msg to app server HandleCallError hce = new HandleCallError(); hce.CASEID = aci.CASEID; hce.ERRORCODE = "2"; hce.ERRORMSG = "未找到服务通讯"; hce.ERRORTIME = DateTime.Now; Appserver.SendCallError(hce); } } } catch (Exception ex) { LogHelper.WriteLog("程序异常!", ex); } }
public void SendAppCallInMessage(AppCallInfo aci) { try { receiveAPPSheet res = new receiveAPPSheet(); res.address = aci.ADDRESS; res.areacode = SysParameters.LocalUnitCode; res.brithday = aci.BRITHDAY; res.calltime = aci.CALLTIME.ToString(); res.caseid = aci.CASEID; res.contactway1 = aci.CONTACTWAY1; res.contactway2 = aci.CONTACTWAY2; res.contactway3 = aci.CONTACTWAY3; res.height = aci.HEIGHT.ToString(); res.identitycard = aci.IDENTITYCARD; res.isself = aci.ISSELF.ToString(); res.jd = aci.JD; res.medicalhistory = aci.MEDICALHISTORY; res.medicalinsurancecard = aci.MEDICALINSURANCECARD; res.name = aci.NAME; res.phone = aci.PHONE; res.sex = aci.SEX.ToString(); res.wd = aci.WD; res.weight = aci.WEIGHT.ToString(); res.area = aci.AREA.ToString(); res.city = aci.CITY.ToString(); res.province=aci.PROVINCE.ToString(); string strMsg = JSON.ToJson(res); tch.SendToServer(7000, CommandType.joson, strMsg); LOG.LogHelper.WriteLog(string.Format("发送APP转单消息发送成功,消息内容{0}",strMsg)); } catch (Exception ex) { LOG.LogHelper.WriteLog("发送APP转单消息发送失败", ex); } }
/// <summary> /// 验证客户端提交的信息内容 /// </summary> /// <param name="ErrorInfo"></param> /// <param name="htCallInfo"></param> /// <returns></returns> public bool VerifyItems(out string ErrorInfo, out AppCallInfo aci, Hashtable htCallIn) { ErrorInfo = ""; aci = new AppCallInfo(); // phone String 主叫号码 Varchar2(20) 20 必填 if (htCallIn["phone"] == null || htCallIn["phone"].ToString() == "") { ErrorInfo = "主机号码不能为空"; return(false); } else { aci.PHONE = htCallIn["phone"].ToString(); } // caseId String CaseID Varchar2(50) 50 必填,由APP提供,GUID if (htCallIn["caseId"] == null || htCallIn["caseId"].ToString() == "") { ErrorInfo = "caseId不能为空"; return(false); } else { aci.CASEID = htCallIn["caseId"].ToString(); } //province String 省(直辖市) Varchar2(30) 30 必填 if (htCallIn["province"] == null || htCallIn["province"].ToString() == "") { ErrorInfo = "省(直辖市)不能为空"; return(false); } else { aci.PROVINCE = htCallIn["province"].ToString(); } //city String 市 Varchar2(30) 30 必填 if (htCallIn["city"] == null || htCallIn["city"].ToString() == "") { ErrorInfo = "市不能为空"; return(false); } else { aci.CITY = htCallIn["city"].ToString(); } //area String 区(县) Varchar2(30) 30 必填 if (htCallIn["area"] == null || htCallIn["area"].ToString() == "") { ErrorInfo = "区(县)不能为空"; return(false); } else { aci.AREA = htCallIn["area"].ToString(); } //isSelf String 是否本人 Number(1) 1 必填,1:自己,2: if (htCallIn["isSelf"] == null || htCallIn["isSelf"].ToString() == "") { ErrorInfo = "是否本人不能为空"; return(false); } else { aci.ISSELF = int.Parse(htCallIn["isSelf"].ToString()); } //callTime Date 呼叫时间 Date 必填,呼叫时间 if (htCallIn["callTime"] == null || htCallIn["callTime"].ToString() == "") { ErrorInfo = "呼叫时间不能为空"; return(false); } else { aci.CALLTIME = DateTime.Parse(htCallIn["callTime"].ToString()); } //name String 姓名 Varchar2(50) 50 可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (htCallIn["name"] != null) { aci.NAME = htCallIn["name"].ToString(); } //sex String 性别 Number(1) 1 可以是本人,可以是亲友,由呼叫人指定,路人时候为空【0:未知 1:男 2:女】 if (htCallIn["sex"] == null || htCallIn["sex"].ToString() == "") { aci.SEX = 0; } else { aci.SEX = int.Parse(htCallIn["sex"].ToString()); } //brithday String 出生日期【年月日】 Varchar2 (8) 8 可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (htCallIn["brithday"] != null) { aci.BRITHDAY = htCallIn["brithday"].ToString(); } //height Integer 身高 Number(4) 厘米,可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (!(htCallIn["height"] == null || htCallIn["height"].ToString() == "")) { aci.HEIGHT = int.Parse(htCallIn["height"].ToString()); } //weight Integer 体重 Number(4) 千克,可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (!(htCallIn["weight"] == null || htCallIn["weight"].ToString() == "")) { aci.WEIGHT = decimal.Parse(htCallIn["weight"].ToString()); } //identityCard String 身份证号码 Varchar2(50) 50 可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (htCallIn["identityCard"] != null) { aci.IDENTITYCARD = htCallIn["identityCard"].ToString(); } //jd String 经度 Varchar2(30) 30 报警电话的经度 if (htCallIn["jd"] != null) { aci.JD = htCallIn["jd"].ToString(); } //wd String 纬度 Varchar2(30) 30 报警电话的维度 if (htCallIn["wd"] != null) { aci.WD = htCallIn["wd"].ToString(); } //address String 呼叫人地址 Varchar2(400) 400 报警电话的呼叫地址 if (htCallIn["address"] != null) { aci.ADDRESS = htCallIn["address"].ToString(); } //medicalHistory String 既往病史 Varchar2(500) 500 可以是本人,可以是亲友,由呼叫人指定,路人时候为空 if (htCallIn["medicalHistory"] != null) { aci.MEDICALHISTORY = htCallIn["medicalHistory"].ToString(); } //contactWay1 String 联系方式1 Varchar2(20) 20 if (htCallIn["contactWay1"] != null) { aci.CONTACTWAY1 = htCallIn["contactWay1"].ToString(); } //contactWay2 String 联系方式2 Varchar2(20) 20 if (htCallIn["contactWay2"] != null) { aci.CONTACTWAY2 = htCallIn["contactWay2"].ToString(); } //contactWay3 String 联系方式3 Varchar2(20) 20 if (htCallIn["contactWay3"] != null) { aci.CONTACTWAY3 = htCallIn["contactWay3"].ToString(); } //medicalInsuranceCard String 医保卡号 Varchar2(50) 50 if (htCallIn["medicalInsuranceCard"] != null) { aci.MEDICALINSURANCECARD = htCallIn["medicalInsuranceCard"].ToString(); } return(true); }
/// <summary> /// 得到一个对象实体 /// </summary> public AppCallInfo DataRowToModel(DataRow row) { AppCallInfo model = new AppCallInfo(); if (row != null) { if (row["CASEID"] != null) { model.CASEID = row["CASEID"].ToString(); } if (row["PHONE"] != null) { model.PHONE = row["PHONE"].ToString(); } if (row["PROVINCE"] != null) { model.PROVINCE = row["PROVINCE"].ToString(); } if (row["CITY"] != null) { model.CITY = row["CITY"].ToString(); } if (row["AREA"] != null) { model.AREA = row["AREA"].ToString(); } if (row["CALLTIME"] != null && row["CALLTIME"].ToString() != "") { model.CALLTIME = DateTime.Parse(row["CALLTIME"].ToString()); } if (row["ISSELF"] != null && row["ISSELF"].ToString() != "") { model.ISSELF = int.Parse(row["ISSELF"].ToString()); } if (row["NAME"] != null) { model.NAME = row["NAME"].ToString(); } if (row["SEX"] != null && row["SEX"].ToString() != "") { model.SEX = int.Parse(row["SEX"].ToString()); } if (row["BRITHDAY"] != null) { model.BRITHDAY = row["BRITHDAY"].ToString(); } if (row["HEIGHT"] != null && row["HEIGHT"].ToString() != "") { model.HEIGHT = int.Parse(row["HEIGHT"].ToString()); } if (row["WEIGHT"] != null && row["WEIGHT"].ToString() != "") { model.WEIGHT = decimal.Parse(row["WEIGHT"].ToString()); } if (row["IDENTITYCARD"] != null) { model.IDENTITYCARD = row["IDENTITYCARD"].ToString(); } if (row["JD"] != null) { model.JD = row["JD"].ToString(); } if (row["WD"] != null) { model.WD = row["WD"].ToString(); } if (row["ADDRESS"] != null) { model.ADDRESS = row["ADDRESS"].ToString(); } if (row["MEDICALHISTORY"] != null) { model.MEDICALHISTORY = row["MEDICALHISTORY"].ToString(); } if (row["CONTACTWAY1"] != null) { model.CONTACTWAY1 = row["CONTACTWAY1"].ToString(); } if (row["CONTACTWAY2"] != null) { model.CONTACTWAY2 = row["CONTACTWAY2"].ToString(); } if (row["CONTACTWAY3"] != null) { model.CONTACTWAY3 = row["CONTACTWAY3"].ToString(); } if (row["MEDICALINSURANCECARD"] != null) { model.MEDICALINSURANCECARD = row["MEDICALINSURANCECARD"].ToString(); } if (row["ADDTIME"] != null && row["ADDTIME"].ToString() != "") { model.ADDTIME = DateTime.Parse(row["ADDTIME"].ToString()); } } return(model); }