/// <summary>
/// 更新
/// </summary>
/// <param name="pDataObject"></param>
/// <param name="sqLiteTransaction"></param>
public void Update(Obj_YIJDF_TX_2 pDataObject, SQLiteTransaction sqLiteTransaction)
{
const string mySqlString =
"update YIJDF_TX_2 set DFJS=$DFJS,YJDF=$YJDF,YJDFQZ=$YJDFQZ,JFQZYF=$JFQZYF where NAME=$NAME and DATE=$DATE";
using (SQLiteCommand myCommand = sqLiteTransaction.Connection.CreateCommand())
{
myCommand.CommandText = mySqlString;
myCommand.Parameters.Add(new SQLiteParameter("DATE", pDataObject.DATE));
myCommand.Parameters.Add(new SQLiteParameter("NAME", pDataObject.Name));
myCommand.Parameters.Add(new SQLiteParameter("DFJS", pDataObject.DFJS));
myCommand.Parameters.Add(new SQLiteParameter("YJDF", pDataObject.YJDF));
myCommand.Parameters.Add(new SQLiteParameter("YJDFQZ", pDataObject.YJDFQZ));
myCommand.Parameters.Add(new SQLiteParameter("JFQZYF", pDataObject.JFQZYF));
myCommand.ExecuteNonQuery();
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="pDataObject"></param>
/// <param name="sqLiteTransaction"></param>
public void Add(Obj_YIJDF_TX_2 pDataObject, SQLiteTransaction sqLiteTransaction)
{
const string mySqlString =
"insert into YIJDF_TX_2 (DATE,NAME,DFJS,YJDF,YJDFQZ,JFQZYF) values ($DATE,$NAME,$DFJS,$YJDF,$YJDFQZ,$JFQZYF)";
using (SQLiteCommand myCommand = sqLiteTransaction.Connection.CreateCommand())
{
myCommand.CommandText = mySqlString;
myCommand.Parameters.Add(new SQLiteParameter("DATE", pDataObject.DATE));
myCommand.Parameters.Add(new SQLiteParameter("NAME", pDataObject.Name));
myCommand.Parameters.Add(new SQLiteParameter("DFJS", pDataObject.DFJS));
myCommand.Parameters.Add(new SQLiteParameter("YJDF", pDataObject.YJDF));
myCommand.Parameters.Add(new SQLiteParameter("YJDFQZ", pDataObject.YJDFQZ));
myCommand.Parameters.Add(new SQLiteParameter("JFQZYF", pDataObject.JFQZYF));
myCommand.ExecuteNonQuery();
}
}