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);
}
