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