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