/// <summary> /// 向TB_LocalUnit中插入单位的相关的信息 /// </summary> /// <param name="unitName">单位名称</param> /// <param name="registTime">注册时间</param> /// <param name="unitClass">单位类别</param> /// <returns></returns> public bool insterNewUnit(string unitName, string registTime, string unitClass) { MySQLiteConnection myconn = new MySQLiteConnection(filepath); SQLiteConnection conn = myconn.GetSQLiteConnection(); try { conn.Open(); string sql2 = "insert into TB_LocalUnit(unitName,registTime,unitClass) VALUES(@unitName1,@registTime1,@unitClass1)"; using (SQLiteCommand cmd = new SQLiteCommand(sql2, conn)) { cmd.Parameters.Add("@unitName1", System.Data.DbType.String).Value = unitName; cmd.Parameters.Add("@registTime1", System.Data.DbType.String).Value = registTime; cmd.Parameters.Add("@unitClass1", System.Data.DbType.String).Value = unitClass; cmd.ExecuteNonQuery(); } conn.Close(); conn.Dispose(); return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 向DBHBMSU.db中的TB_UNIT中插入单位名称、单位类别、单位时间 /// </summary> /// <param name="unitName"></param> /// <param name="registTime"></param> /// <param name="unitClass"></param> /// <returns></returns> public bool insterNewUnit_Globle(string unitName, string registTime, string unitClass) { MySQLiteConnection myconn = new MySQLiteConnection(Application.StartupPath + "\\DB\\DBHBMSU.db"); SQLiteConnection conn = myconn.GetSQLiteConnection(); try { conn.Open(); string sql = "insert into TB_UNIT(unitName,registTime,unitClass) VALUES(@unitName1,@registTime1,@unitClass1)"; using (SQLiteCommand cmd = new SQLiteCommand(sql, conn)) { cmd.Parameters.Add("@unitName1", System.Data.DbType.String).Value = unitName; cmd.Parameters.Add("@registTime1", System.Data.DbType.String).Value = registTime; cmd.Parameters.Add("@unitClass1", System.Data.DbType.String).Value = unitClass; cmd.ExecuteNonQuery(); } conn.Close(); conn.Dispose(); return(true); } catch (Exception ex) { throw ex; } }