public string UpdateCloseFlagByPackID(string packID, string closedFlag, OleExec sfcdb) { Row_R_PACKING rowPacking = (Row_R_PACKING)this.GetObjByID(packID, sfcdb); rowPacking.CLOSED_FLAG = closedFlag; return(sfcdb.ExecSQL(rowPacking.GetUpdateString(DB_TYPE_ENUM.Oracle))); }
public Row_R_PACKING GetRPackingByPackNo(OleExec DB, string PackNo) { string strSql = $@" SELECT * FROM R_PACKING where PACK_NO='{PackNo}' "; DataSet ds = DB.ExecSelect(strSql); Row_R_PACKING r = (Row_R_PACKING)this.NewRow(); r.loadData(ds.Tables[0].Rows[0]); return(r); }
public string UpdateQtyByID(string packId, bool isAdd, double qty, string emp, OleExec sfcdb) { Row_R_PACKING rowPacking = (Row_R_PACKING)this.GetObjByID(packId, sfcdb); if (isAdd) { rowPacking.QTY = rowPacking.QTY + qty; } else { rowPacking.QTY = rowPacking.QTY - qty; } rowPacking.EDIT_TIME = this.GetDBDateTime(sfcdb); rowPacking.EDIT_EMP = emp; return(sfcdb.ExecSQL(rowPacking.GetUpdateString(DB_TYPE_ENUM.Oracle))); }
public R_PACKING GetPackingObjectBySN(string sn, OleExec sfcdb) { string sql = $@"select * from r_packing where id in (select n.pack_id from r_sn_packing n,r_sn m where n.sn_id=m.id and m.sn='{sn}' and m.valid_flag='1')"; DataSet ds = sfcdb.ExecSelect(sql); if (ds.Tables[0].Rows.Count > 0) { Row_R_PACKING rowPacking = (Row_R_PACKING)this.NewRow(); rowPacking.loadData(ds.Tables[0].Rows[0]); return(rowPacking.GetDataObject()); } else { return(null); } }