public C_SEQNO GetDataObject() { C_SEQNO DataObject = new C_SEQNO(); DataObject.SEQ_NAME = this.SEQ_NAME; DataObject.SEQ_NO = this.SEQ_NO; DataObject.DIGITS = this.DIGITS; DataObject.BASE_CODE = this.BASE_CODE; DataObject.MINIMUM = this.MINIMUM; DataObject.MAXIMUM = this.MAXIMUM; DataObject.PREFIX = this.PREFIX; DataObject.FIXED = this.FIXED; DataObject.SEQ_FORM = this.SEQ_FORM; DataObject.RESET = this.RESET; DataObject.USE_TIME = this.USE_TIME; DataObject.EDIT_EMP = this.EDIT_EMP; DataObject.EDIT_TIME = this.EDIT_TIME; DataObject.ID = this.ID; return(DataObject); }
public string GetLotno(string SeqName, OleExec DB) { string StrLot = ""; string Result = ""; string DateCode = ""; string WeekNo = ""; double NextSeqno = 0; Int16 Digits = 0; double Minimum = 0; double Maxmum = 0; string Prefix = ""; string Fixedstr = ""; string SeqForm = ""; string Reset = ""; DateTime UseTime = new DateTime(); T_C_SEQNO T_C_Seqno = new T_C_SEQNO(DB, DB_TYPE_ENUM.Oracle); C_SEQNO C_SEQNO = T_C_Seqno.GetSeqnoObj(SeqName, DB); NextSeqno = Int64.Parse(C_SEQNO.SEQ_NO.ToString()); Digits = (Int16)C_SEQNO.DIGITS; Minimum = Int64.Parse(C_SEQNO.MINIMUM.ToString()); Maxmum = Int64.Parse(C_SEQNO.MAXIMUM.ToString()); Prefix = C_SEQNO.PREFIX; Fixedstr = C_SEQNO.FIXED; SeqForm = C_SEQNO.SEQ_FORM; Reset = C_SEQNO.RESET; UseTime = (DateTime)C_SEQNO.USE_TIME; Result = NextSeqno.ToString();//默认为取下一个值 //edit by lc 20180330 if (NextSeqno == Maxmum) { Result = Minimum.ToString(); } if (!string.IsNullOrEmpty(SeqForm)) { if ("YYYYMMDD".Equals(SeqForm) && "1".Equals(Reset) && GetFormatDate(DB, UseTime, "YYYYMMDD") != GetFormatSYSDate(DB, System.DateTime.Now, "YYYYMMDD")) { Result = Minimum.ToString(); } else if ("YYMMDD".Equals(SeqForm) && "1".Equals(Reset) && GetFormatDate(DB, UseTime, "YYMMDD") != GetFormatSYSDate(DB, System.DateTime.Now, "YYMMDD")) { Result = Minimum.ToString(); } else if ("YY-WK".Equals(SeqForm) && "1".Equals(Reset) && GetFormatDate(DB, UseTime, "YY-IW") != GetFormatSYSDate(DB, System.DateTime.Now, "YY-IW")) { Result = Minimum.ToString(); } else if ("YY-MM".Equals(SeqForm) && "1".Equals(Reset)) { Result = Minimum.ToString(); } //else if (NextSeqno == Maxmum) //{ // Result = Minimum.ToString(); //} if ((SeqForm).IndexOf("YYYY") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "YYYY"); } else if ((SeqForm).IndexOf("YY") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "YY"); } else if ((SeqForm).IndexOf("Y") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "Y"); } if ((SeqForm).IndexOf("MM") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "MM"); } else if ((SeqForm).IndexOf("M") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "M"); } if ((SeqForm).IndexOf("WK") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "IW"); } if ((SeqForm).IndexOf("DD") != -1) { DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "DD"); } //if ("YYYY".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "YYYY"); //} //else if ("YY".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "YY"); //} //else if ("Y".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "Y"); //} //if ("MM".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "MM"); //} //else if ("M".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "M"); //} //if ("WK".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "IW"); //} //if ("DD".IndexOf(SeqForm) != -1) //{ // DateCode = DateCode + GetFormatSYSDate(DB, System.DateTime.Now, "DD"); //} } T_C_Seqno.UpdateSeqno(SeqName, (int.Parse(Result) + 1).ToString(), DB); StrLot = Prefix + DateCode + Fixedstr + Result.ToString().PadLeft(Digits, '0'); return(StrLot); }