/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CarLocation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into carlocation(");
strSql.Append("LSH,CASEID,CCCC,CLID,SJ,JD,WD,SD,FX,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@LSH,@CASEID,@CCCC,@CLID,@SJ,@JD,@WD,@SD,@FX,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@CCCC", DBOpHelper.GetNumber(model.CCCC)),
new MySqlParameter("@CLID", DBOpHelper.GetString(model.CLID)),
new MySqlParameter("@SJ", DBOpHelper.GetDateTime(model.SJ)),
new MySqlParameter("@JD", DBOpHelper.GetString(model.JD)),
new MySqlParameter("@WD", DBOpHelper.GetString(model.WD)),
new MySqlParameter("@SD", DBOpHelper.GetNumber(model.SD)),
new MySqlParameter("@FX", DBOpHelper.GetString(model.FX)),
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>
public bool Add(ZIT.AppRouteServer.Model.ServiceQualityInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ServiceQualityInfo(");
strSql.Append("LSH,CASEID,CCCC,CLID,TIMETAKEN,MONEY,KM,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":LSH,:CASEID,:CCCC,:CLID,:TIMETAKEN,:MONEY,:KM,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)),
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":CCCC", DBOpHelper.GetNumber(model.CCCC)),
new OracleParameter(":CLID", DBOpHelper.GetString(model.CLID)),
new OracleParameter(":TIMETAKEN", DBOpHelper.GetNumber(model.TIMETAKEN)),
new OracleParameter(":MONEY", DBOpHelper.GetNumber(model.MONEY)),
new OracleParameter(":KM", DBOpHelper.GetNumber(model.KM)),
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(QualityEvaluation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QualityEvaluation(");
strSql.Append("LSH,QUALITYCOMMENT,REASON,CASEID,COMMENTTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":LSH,:QUALITYCOMMENT,:REASON,:CASEID,:COMMENTTIME,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)),
new OracleParameter(":QUALITYCOMMENT", DBOpHelper.GetString(model.QUALITYCOMMENT)),
new OracleParameter(":REASON", DBOpHelper.GetString(model.REASON)),
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":COMMENTTIME", DBOpHelper.GetDateTime(model.COMMENTTIME)),
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(HandleCallError model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into handlecallerror(");
strSql.Append("CASEID,ERRORCODE,ERRORMSG,ERRORTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@CASEID,@ERRORCODE,@ERRORMSG,@ERRORTIME,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@ERRORCODE", DBOpHelper.GetString(model.ERRORCODE)),
new MySqlParameter("@ERRORMSG", DBOpHelper.GetString(model.ERRORMSG)),
new MySqlParameter("@ERRORTIME", DBOpHelper.GetDateTime(model.ERRORTIME)),
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>
public bool Add(HandleCallError model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HandleCallError(");
strSql.Append("CASEID,ERRORCODE,ERRORMSG,ERRORTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":CASEID,:ERRORCODE,:ERRORMSG,:ERRORTIME,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":ERRORCODE", DBOpHelper.GetString(model.ERRORCODE)),
new OracleParameter(":ERRORMSG", DBOpHelper.GetString(model.ERRORMSG)),
new OracleParameter(":ERRORTIME", DBOpHelper.GetDateTime(model.ERRORTIME)),
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(CarLocation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CarLocation(");
strSql.Append("LSH,CASEID,CCCC,CLID,SJ,JD,WD,SD,FX,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":LSH,:CASEID,:CCCC,:CLID,:SJ,:JD,:WD,:SD,:FX,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)),
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":CCCC", DBOpHelper.GetNumber(model.CCCC)),
new OracleParameter(":CLID", DBOpHelper.GetString(model.CLID)),
new OracleParameter(":SJ", DBOpHelper.GetDateTime(model.SJ)),
new OracleParameter(":JD", DBOpHelper.GetString(model.JD)),
new OracleParameter(":WD", DBOpHelper.GetString(model.WD)),
new OracleParameter(":SD", DBOpHelper.GetNumber(model.SD)),
new OracleParameter(":FX", DBOpHelper.GetString(model.FX)),
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(QualityEvaluation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into qualityevaluation(");
strSql.Append("LSH,QUALITYCOMMENT,REASON,CASEID,COMMENTTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@LSH,@QUALITYCOMMENT,@REASON,@CASEID,@COMMENTTIME,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@QUALITYCOMMENT", DBOpHelper.GetString(model.QUALITYCOMMENT)),
new MySqlParameter("@REASON", DBOpHelper.GetString(model.REASON)),
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@COMMENTTIME", DBOpHelper.GetDateTime(model.COMMENTTIME)),
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>
public bool Add(ServiceQualityInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into servicequalityinfo(");
strSql.Append("LSH,CASEID,CCCC,CLID,TIMETAKEN,MONEY,KM,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@LSH,@CASEID,@CCCC,@CLID,@TIMETAKEN,@MONEY,@KM,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@CCCC", DBOpHelper.GetNumber(model.CCCC)),
new MySqlParameter("@CLID", DBOpHelper.GetString(model.CLID)),
new MySqlParameter("@TIMETAKEN", DBOpHelper.GetNumber(model.TIMETAKEN)),
new MySqlParameter("@MONEY", DBOpHelper.GetNumber(model.MONEY)),
new MySqlParameter("@KM", DBOpHelper.GetNumber(model.KM)),
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>
public bool Add(CarState model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CarState(");
strSql.Append("LSH,CASEID,CCCC,CLID,SJ,ZT,TASK_TERMINATION_REASON,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":LSH,:CASEID,:CCCC,:CLID,:SJ,:ZT,:TASK_TERMINATION_REASON,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)),
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":CCCC", DBOpHelper.GetNumber(model.CCCC)),
new OracleParameter(":CLID", DBOpHelper.GetString(model.CLID)),
new OracleParameter(":SJ", DBOpHelper.GetDateTime(model.SJ)),
new OracleParameter(":ZT", DBOpHelper.GetString(model.ZT)),
new OracleParameter(":TASK_TERMINATION_REASON", DBOpHelper.GetString(model.TASK_TERMINATION_REASON)),
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(SendCarInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sendcarinfo(");
strSql.Append("CASEID,LSH,CCCC,CLID,CPH,CCSJ,SSDW,DRIVERPHONE,DRIVERNAME,DOCTORPHONE,DOCTORNAME,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@CASEID,@LSH,@CCCC,@CLID,@CPH,@CCSJ,@SSDW,@DRIVERPHONE,@DRIVERNAME,@DOCTORPHONE,@DOCTORNAME,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@CCCC", DBOpHelper.GetNumber(model.CCCC)),
new MySqlParameter("@CLID", DBOpHelper.GetString(model.CLID)),
new MySqlParameter("@CPH", DBOpHelper.GetString(model.CPH)),
new MySqlParameter("@CCSJ", DBOpHelper.GetDateTime(model.CCSJ)),
new MySqlParameter("@SSDW", DBOpHelper.GetString(model.SSDW)),
new MySqlParameter("@DRIVERPHONE", DBOpHelper.GetString(model.DRIVERPHONE)),
new MySqlParameter("@DRIVERNAME", DBOpHelper.GetString(model.DRIVERNAME)),
new MySqlParameter("@DOCTORPHONE", DBOpHelper.GetString(model.DOCTORPHONE)),
new MySqlParameter("@DOCTORNAME", DBOpHelper.GetString(model.DOCTORNAME)),
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>
public bool Add(CarState model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into carstate(");
strSql.Append("LSH,CASEID,CCCC,CLID,SJ,ZT,TASK_TERMINATION_REASON,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@LSH,@CASEID,@CCCC,@CLID,@SJ,@ZT,@TASK_TERMINATION_REASON,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@CCCC", DBOpHelper.GetNumber(model.CCCC)),
new MySqlParameter("@CLID", DBOpHelper.GetString(model.CLID)),
new MySqlParameter("@SJ", DBOpHelper.GetDateTime(model.SJ)),
new MySqlParameter("@ZT", DBOpHelper.GetString(model.ZT)),
new MySqlParameter("@TASK_TERMINATION_REASON", DBOpHelper.GetString(model.TASK_TERMINATION_REASON)),
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>
public bool Add(SendCarInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SendCarInfo(");
strSql.Append("CASEID,LSH,CCCC,CLID,CPH,CCSJ,SSDW,DRIVERPHONE,DRIVERNAME,DOCTORPHONE,DOCTORNAME,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":CASEID,:LSH,:CCCC,:CLID,:CPH,:CCSJ,:SSDW,:DRIVERPHONE,:DRIVERNAME,:DOCTORPHONE,:DOCTORNAME,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":LSH", DBOpHelper.GetString(model.LSH)),
new OracleParameter(":CCCC", DBOpHelper.GetNumber(model.CCCC)),
new OracleParameter(":CLID", DBOpHelper.GetString(model.CLID)),
new OracleParameter(":CPH", DBOpHelper.GetString(model.CPH)),
new OracleParameter(":CCSJ", DBOpHelper.GetDateTime(model.CCSJ)),
new OracleParameter(":SSDW", DBOpHelper.GetString(model.SSDW)),
new OracleParameter(":DRIVERPHONE", DBOpHelper.GetString(model.DRIVERPHONE)),
new OracleParameter(":DRIVERNAME", DBOpHelper.GetString(model.DRIVERNAME)),
new OracleParameter(":DOCTORPHONE", DBOpHelper.GetString(model.DOCTORPHONE)),
new OracleParameter(":DOCTORNAME", DBOpHelper.GetString(model.DOCTORNAME)),
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)");
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);
}
}
