public R_MRB_GT GetDataObject() { R_MRB_GT DataObject = new R_MRB_GT(); DataObject.ID = this.ID; DataObject.WORKORDERNO = this.WORKORDERNO; DataObject.SAP_STATION_CODE = this.SAP_STATION_CODE; DataObject.FROM_STORAGE = this.FROM_STORAGE; DataObject.TO_STORAGE = this.TO_STORAGE; DataObject.TOTAL_QTY = this.TOTAL_QTY; DataObject.CONFIRMED_FLAG = this.CONFIRMED_FLAG; DataObject.ZCPP_FLAG = this.ZCPP_FLAG; DataObject.SAP_FLAG = this.SAP_FLAG; DataObject.SKUNO = this.SKUNO; DataObject.SAP_MESSAGE = this.SAP_MESSAGE; DataObject.EDIT_EMP = this.EDIT_EMP; DataObject.EDIT_TIME = this.EDIT_TIME; return(DataObject); }
/// <summary> /// 通過from_Storage查詢sap_flag=0的記錄 /// </summary> /// <param name="strWo">工單號</param> /// <param name="DB"></param> /// <returns></returns> public R_MRB_GT GetByFromStorageAndSAPFlageIsZero(string fromStorage, OleExec DB) { string strSql = $@" select * from r_mrb_gt where from_storage=:wono and sap_flag='0'"; OleDbParameter[] paramet = new OleDbParameter[1]; paramet[0] = new OleDbParameter(":wono", fromStorage); DataTable table = DB.ExecuteDataTable(strSql, CommandType.Text, paramet); R_MRB_GT result = new R_MRB_GT(); if (table.Rows.Count > 0) { Row_R_MRB_GT ret = (Row_R_MRB_GT)NewRow(); ret.loadData(table.Rows[0]); result = ret.GetDataObject(); } else { result = null; } return(result); }
public int Add(R_MRB_GT newMRBGT, OleExec DB) { string strSql = $@"insert into r_mrb_gt(id,workorderno,sap_station_code,from_storage,to_storage,total_qty,confirmed_flag,zcpp_flag,sap_flag,skuno,sap_message,edit_emp,edit_time)"; strSql = strSql + $@"values(:id,:workorderno,:sap_station_code,:from_storage,:to_storage,:total_qty,:confirmed_flag,:zcpp_flag,:sap_flag,:skuno,:sap_message,:edit_emp,sysdate)"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", newMRBGT.ID), new OleDbParameter(":workorderno", newMRBGT.WORKORDERNO), new OleDbParameter(":sap_station_code", newMRBGT.SAP_STATION_CODE), new OleDbParameter(":from_storage", newMRBGT.FROM_STORAGE), new OleDbParameter(":to_storage", newMRBGT.TO_STORAGE), new OleDbParameter(":total_qty", newMRBGT.TOTAL_QTY), new OleDbParameter(":confirmed_flag", newMRBGT.CONFIRMED_FLAG), new OleDbParameter(":zcpp_flag", newMRBGT.ZCPP_FLAG), new OleDbParameter(":sap_flag", newMRBGT.SAP_FLAG), new OleDbParameter(":skuno", newMRBGT.SKUNO), new OleDbParameter(":sap_message", newMRBGT.SAP_MESSAGE), new OleDbParameter(":edit_emp", newMRBGT.EDIT_EMP) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }