public static void UpdateMaterial(MaterialItemModel item)
{
using (SQLiteConnection conn = new SQLiteConnection(AppSettings.ConnectString))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"Update MaterialSettings SET Name=@p0, UpdatedTime=@p1 WHERE Code=@p2";
cmd.Parameters.Add(new SQLiteParameter("@p0", item.Name));
cmd.Parameters.Add(new SQLiteParameter("@p1", DateTime.Now));
cmd.Parameters.Add(new SQLiteParameter("@p2", item.Code));
cmd.ExecuteNonQuery();
}
}
}
public static void CreateMaterial(MaterialItemModel item)
{
using (SQLiteConnection conn = new SQLiteConnection(AppSettings.ConnectString))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"INSERT INTO MaterialSettings (Code, Name, UpdatedTime) VALUES (@p1,@p2,@p3)";
cmd.Parameters.Add(new SQLiteParameter("@p1", item.Code));
cmd.Parameters.Add(new SQLiteParameter("@p2", item.Name));
cmd.Parameters.Add(new SQLiteParameter("@p3", DateTime.Now));
cmd.ExecuteNonQuery();
}
}
}
