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