C# (CSharp) eTexAPI.Data.OperationSql.FindNewId Examples

Example #1

 public int FindNewMsgLogId()
 {
     return(Ope.FindNewId(Ope.EnumServer.mServer, "MessageLog", "MAX(LogID)", ""));
 }

Example #2

 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 + "'"));
 }

Example #3

File: SaleOrderServices.cs Project: pratikboghani/eTexAPI

 public int GetNewOrdNo(int mfg, int ycode)
 {
     return(Ope.FindNewId(Ope.EnumServer.mServer, TableName, "MAX(OrdNo)", " MfgUnit=" + mfg + " And YCode=" + ycode + ""));
 }