/// <summary> /// 插入数据 /// </summary> /// <param name="treatTime">Class instance of infectType infomation</param> /// <param name="scId">Id of the last insert row id</param> /// <returns></returns> public bool InsertTreatTime(TreatTime treatTime, ref int scId) { try { using (SqlCommand sqlcomm = SqlConn.CreateCommand()) { sqlcomm.CommandText = @"INSERT INTO TREATTIME (ACTIVATED,NAME,BEGINTIME,ENDTIME,DESCRIPTION,RESERVED) VALUES (@ACTIVATED,@NAME,@BEGINTIME,@ENDTIME,@DESCRIPTION,@RESERVED) SET @ID = SCOPE_IDENTITY() "; sqlcomm.Parameters.Add("@NAME", DbType.String); if (treatTime.Name != null) { sqlcomm.Parameters["@NAME"].Value = treatTime.Name; } sqlcomm.Parameters.Add("@ACTIVATED", DbType.Boolean); sqlcomm.Parameters["@ACTIVATED"].Value = treatTime.Activated; sqlcomm.Parameters.Add("@BEGINTIME", DbType.String); if (treatTime.BeginTime != null) { sqlcomm.Parameters["@BEGINTIME"].Value = treatTime.BeginTime; } sqlcomm.Parameters.Add("@ENDTIME", DbType.String); if (treatTime.EndTime != null) { sqlcomm.Parameters["@ENDTIME"].Value = treatTime.EndTime; } sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String); if (treatTime.Description != null) { sqlcomm.Parameters["@DESCRIPTION"].Value = treatTime.Description; } sqlcomm.Parameters.Add("@RESERVED", DbType.String); if (treatTime.Reserved != null) { sqlcomm.Parameters["@RESERVED"].Value = treatTime.Reserved; } sqlcomm.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output; DatabaseOp.ExecuteNoneQuery(sqlcomm); scId = (int)sqlcomm.Parameters["@ID"].Value; } } catch (Exception e) { MainWindow.Log.WriteErrorLog("TreatTimeDao.cs-InsertTreatTime", e); return(false); } return(true); }
/// <summary> /// 插入数据 /// </summary> /// <param name="TreatTime">Class instance of infectType infomation</param> /// <param name="scId">Id of the last insert row id</param> /// <returns></returns> public bool InsertTreatTime(TreatTime TreatTime, ref int scId) { try { using (SQLiteCommand sqlcomm = SqlConn.CreateCommand()) { sqlcomm.CommandText = @"INSERT INTO TREATTIME (NAME,ACTIVATED,BEGINTIME,ENDTIME,DESCRIPTION,RESERVED) VALUES (@NAME,@ACTIVATED,@BEGINTIME,@ENDTIME,@DESCRIPTION,@RESERVED)"; sqlcomm.Parameters.Add("@NAME", DbType.String); sqlcomm.Parameters["@NAME"].Value = TreatTime.Name; sqlcomm.Parameters.Add("@ACTIVATED", DbType.Boolean); sqlcomm.Parameters["@ACTIVATED"].Value = TreatTime.Activated; sqlcomm.Parameters.Add("@DESCRIPTION", DbType.String); sqlcomm.Parameters["@DESCRIPTION"].Value = TreatTime.Description; sqlcomm.Parameters.Add("@BEGINTIME", DbType.String); sqlcomm.Parameters["@BEGINTIME"].Value = TreatTime.BeginTime; sqlcomm.Parameters.Add("@ENDTIME", DbType.String); sqlcomm.Parameters["@ENDTIME"].Value = TreatTime.EndTime; sqlcomm.Parameters.Add("@RESERVED", DbType.String); sqlcomm.Parameters["@RESERVED"].Value = TreatTime.Reserved; DatabaseOp.ExecuteNoneQuery(sqlcomm); //set last insert id of this table this connection SQLiteCommand comm = SqlConn.CreateCommand(); comm.CommandText = "Select last_insert_rowid() as TREATTIME;"; scId = Convert.ToInt32(comm.ExecuteScalar()); comm.Dispose(); } } catch (Exception e) { MainWindow.Log.WriteErrorLog("TreatTimeDao.cs-InsertTreatTime", e); return(false); } return(true); }