public int FindNewMsgLogId() { return(Ope.FindNewId(Ope.EnumServer.mServer, "MessageLog", "MAX(LogID)", "")); }
public int FindNewSrNo(string pIntMfgUnit, string pStrDeptCode, string pStrDate, string pStrFlorNo, string pStrShift) { return(Ope.FindNewId(Ope.EnumServer.mServer, TableName, "Max(SRNO)", "MfgUnit = " + pIntMfgUnit + " And Dept_Code = '" + pStrDeptCode + "' And Att_Date = '" + Ope.SqlDate(pStrDate.ToString()) + "' And FlorNo = '" + pStrFlorNo + "' And Shift = '" + pStrShift + "'")); }
public int GetNewOrdNo(int mfg, int ycode) { return(Ope.FindNewId(Ope.EnumServer.mServer, TableName, "MAX(OrdNo)", " MfgUnit=" + mfg + " And YCode=" + ycode + "")); }