/// <summary> /// 根据 LeafId 更新烟农和烟叶框的电子标签对应表,此表为流水线表记录 /// </summary> /// <returns>返回烟农和烟叶框的电子标签对应表,此表为流水线受影响的行数</returns> public virtual int Update(Leaf leaf) { return db.ExecuteNoQuery("UPDATE T_PUR_LEAF SET LEAF_RFID = @LEAF_RFID, FARMER_ID = @FARMER_ID, LEAF_DATE = @LEAF_DATE, LEAF_LEVEL = @LEAF_LEVEL, LEAF_LEVEL_DATE = @LEAF_LEVEL_DATE, LEAF_LEVEL_EMPOLYEE = @LEAF_LEVEL_EMPOLYEE, LEAF_WEIGHT = @LEAF_WEIGHT, LEAF_WEIGHT_DATE = @LEAF_WEIGHT_DATE, LEAF_WEIGHT_EMPOLYEE = @LEAF_WEIGHT_EMPOLYEE, LEAF_STATE = @LEAF_STATE, LEAF_IS_DELETED = @LEAF_IS_DELETED, LEAF_DELETED_DATE = @LEAF_DELETED_DATE WHERE LEAF_ID = @LEAF_ID", db.GetDataParameter("@LEAF_ID", leaf.LeafId), db.GetDataParameter("@LEAF_RFID", leaf.LeafRfid), db.GetDataParameter("@FARMER_ID", leaf.FarmerId), db.GetDataParameter("@LEAF_DATE", leaf.LeafDate), db.GetDataParameter("@LEAF_LEVEL", leaf.LeafLevel), db.GetDataParameter("@LEAF_LEVEL_DATE", leaf.LeafLevelDate), db.GetDataParameter("@LEAF_LEVEL_EMPOLYEE", leaf.LeafLevelEmpolyee), db.GetDataParameter("@LEAF_WEIGHT", leaf.LeafWeight), db.GetDataParameter("@LEAF_WEIGHT_DATE", leaf.LeafWeightDate), db.GetDataParameter("@LEAF_WEIGHT_EMPOLYEE", leaf.LeafWeightEmpolyee), db.GetDataParameter("@LEAF_STATE", leaf.LeafState), db.GetDataParameter("@LEAF_IS_DELETED", leaf.LeafIsDeleted), db.GetDataParameter("@LEAF_DELETED_DATE", leaf.LeafDeletedDate)); }
/// <summary> /// 新增一条烟农和烟叶框的电子标签对应表,此表为流水线记录 /// </summary> /// <param name="leaf">System.String[]<param> /// <returns>返回烟农和烟叶框的电子标签对应表,此表为流水线受影响的行数</returns> public virtual int Add(Leaf leaf) { return db.ExecuteNoQuery("INSERT INTO T_PUR_LEAF (LEAF_ID, LEAF_RFID, FARMER_ID, LEAF_DATE, LEAF_LEVEL, LEAF_LEVEL_DATE, LEAF_LEVEL_EMPOLYEE, LEAF_WEIGHT, LEAF_WEIGHT_DATE, LEAF_WEIGHT_EMPOLYEE, LEAF_STATE, LEAF_IS_DELETED, LEAF_DELETED_DATE) VALUES (@LEAF_ID, @LEAF_RFID, @FARMER_ID, @LEAF_DATE, @LEAF_LEVEL, @LEAF_LEVEL_DATE, @LEAF_LEVEL_EMPOLYEE, @LEAF_WEIGHT, @LEAF_WEIGHT_DATE, @LEAF_WEIGHT_EMPOLYEE, @LEAF_STATE, @LEAF_IS_DELETED, @LEAF_DELETED_DATE)", db.GetDataParameter("@LEAF_ID", leaf.LeafId), db.GetDataParameter("@LEAF_RFID", leaf.LeafRfid), db.GetDataParameter("@FARMER_ID", leaf.FarmerId), db.GetDataParameter("@LEAF_DATE", leaf.LeafDate), db.GetDataParameter("@LEAF_LEVEL", leaf.LeafLevel), db.GetDataParameter("@LEAF_LEVEL_DATE", leaf.LeafLevelDate), db.GetDataParameter("@LEAF_LEVEL_EMPOLYEE", leaf.LeafLevelEmpolyee), db.GetDataParameter("@LEAF_WEIGHT", leaf.LeafWeight), db.GetDataParameter("@LEAF_WEIGHT_DATE", leaf.LeafWeightDate), db.GetDataParameter("@LEAF_WEIGHT_EMPOLYEE", leaf.LeafWeightEmpolyee), db.GetDataParameter("@LEAF_STATE", leaf.LeafState), db.GetDataParameter("@LEAF_IS_DELETED", leaf.LeafIsDeleted), db.GetDataParameter("@LEAF_DELETED_DATE", leaf.LeafDeletedDate)); }