/// <summary> /// �ت�:�d�ߤW�ǫ᪺���\���� /// Table:VDS_VDM_VCMS_MAIN_TMP /// ����:V_CREATEUID /// </summary> public void QueryItemTmpImportStat(string V_CREATEUID, out int N_TMP_CNT, out int N_TAB_CNT) { try { OUT05 dbo = new OUT05(ref USEDB); dbo.doQueryItemTmpImportStat(V_CREATEUID, out N_TMP_CNT, out N_TAB_CNT); } catch (Exception ex) { throw ex; } }
/// <summary> /// �ت�:�N�W���ɮפ��e�A�s�J�Ȧs�� /// �ǤJ�ѼơG /// �e@�ҥΤ�f /// 1.���M���e�@���A�P�@�ϥΪ̰��檺�פJ�Ȧs��T�P���~��T�C /// ����Table: /// B=VDS_STM_ROUTE_STORE_TMP /// 2.Ū���פJ�ɮר�ȦsDataSet�C /// B.EFF_START=�e@�ҥΤ�f�A��L���ѷ��ɮ榡�C /// 3.�ˬd�פJ�ɮ榡���e�O�_���T�A�p�������~�A�h����W�Ǭy�{�A�æ^�ǿ��~�T���C /// �yXX�ɮסA�ɮפ��e���~�G@���~�����z (�榡�аѦҸ�ƮwTable Shcema) /// * ����G�ˬd����榡�C /// * �Ʀr�G�ˬd���e�O�_���Ʀr�C /// * ��r�G�ˬd���O�_����C /// * �ɮ����ƬO�_�����C /// * ��Ӥu�@��פJ���e����@�����A�ҵ������~�A�����C /// * �פJ���Ӹ`�����аѦҡGWEB UI SPEC ��� /// 4. �榡�ˬd���T�L�~�� /// a) �Ȧs�ɤ���[���A]���վ㬰1:FILE TO TMP /// b) �I�s [CheckData] �A�ˬd��Ƥ��e�西�T�� /// 5. �L��CheckData()�ˬd���G�O�_��True�A /// �ұN�W���ɮפ��e�s�W���ƮwTmp Table:�A /// �ðO�����~��]�B�פJ�̡B�פJ����B�B�z�ɮצW��=�W���ɦW�C /// c)�W�z�פJ�ݤ@��Commit�A�B�z�����������~�A�ҵ������`�A���Rollback�A�æ^�ǿ��~�T���C /// 6. �W�Ǭy�{�����A�^�dzB�z���ưT���G�W���`���ơB���\���ơB���ѵ��ơC /// 7.�p�GCheckData()�ˬd���G��True�A�I�s [ProcessImportRoute.TmpToDB]�A�B�z�פJ�������C /// * �פJ�ɮ����A�аѦҤu�@��GSTM24 ��u����פJ(�ɮ榡)�C /// </summary> public void FileToTmp(DataTable dt, DbTransaction RootDBT, string V_DATA_SOURCE, string V_CREATEUID, out string ErrorMsg) { bool IsRootTranscation = false; try { OUT05 dbo = new OUT05(ref USEDB); ErrorMsg = ""; //�P�_�O�_���ǤJRoot Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region �Ұʥ���Ϋ��wRootTranscation if (IsRootTranscation) { //�W�ߩI�s�Ұ�Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion #region �M��VDS_OUT_VENDOR_TMP dbo.doDeleteItemTmp(V_CREATEUID, DBT); #endregion #region FileToTmp ArrayList ParameterList = new ArrayList(); string V_RESULT = "1"; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (V_RESULT == "1") { string[] V_DATA = dt.Rows[i][0].ToString().Split(','); if (V_DATA.Length != 4) { ErrorMsg = "��J�~�����ʳ��ɮץ��ѡA���ӼƤ��� 4 �ӡA���˵����`����I"; throw new Exception(ErrorMsg); } else { int[] V_LENGTH_ARRAY = { 15, 6, 8, 5 }; string V_LENGTH_LIMIT = "4"; // �i�H���ŭȪ����(�ӫ~�T��) // Ū�J�}�C����� string VENDOR = V_DATA[0]; string BARCODE = V_DATA[1]; string PURCHASE_QTY = V_DATA[2]; string PLAN_ACCEPT_DATE = V_DATA[3]; string MSG = V_DATA[2]; // ��ƪ����ˬd for (int j = 0; j < V_LENGTH_ARRAY.Length;j++ ) { // ���o���ŭȪ�����ˬd if (V_DATA[j].Length <= 0 && V_LENGTH_LIMIT.IndexOf((j+1).ToString()) == -1) { ErrorMsg = string.Format("��J�~�����ʳ��ɮץ��ѡA��{0}����ơA��{1}�����A�H�Ϥ��o���ŭȪ�����", i+1, j+1); throw new Exception(ErrorMsg); } // �����ת��ˬd if (V_DATA[j].Length > V_LENGTH_ARRAY[j]) { ErrorMsg = string.Format("��J�~�����ʳ��ɮץ��ѡA��{0}����ơA��{1}�����A��ƪ��W�L����", i+1, j+1); throw new Exception(ErrorMsg); } } // ��ƫ��O�ˬd int V_IntTryParse; DateTime V_DateTryParse; if (!int.TryParse(PURCHASE_QTY, out V_IntTryParse) && !DateTime.TryParse(PLAN_ACCEPT_DATE, out V_DateTryParse)) { ErrorMsg = "��J�~�����ʳ��ɮץ��ѡA��ƫ��O�����T�A���˵����`����I"; throw new Exception(ErrorMsg); } ParameterList.Clear(); ParameterList.Add(V_DATA_SOURCE); ParameterList.Add(System.DateTime.Now); ParameterList.Add(dt.Rows[i][0].ToString()); ParameterList.Add(V_CREATEUID); ParameterList.Add(System.DateTime.Now); dbo.doCreateTemp(ParameterList, DBT, out V_RESULT); } } } } #endregion #region TmpToDB dbo.doCreateData(V_CREATEUID, DBT, out V_RESULT); if (V_RESULT == "0") ErrorMsg = "��J�~�����ʳ��ɮץ��ѡA���˵����`����I"; #endregion if (IsRootTranscation) { //�W�ߩI�sTranscation���� DBT.Commit(); } } catch (Exception ex) { #region ������� DBT.Rollback(); #endregion throw ex; } finally { #region �P�_�O�_��������s�u if (IsRootTranscation) { //�W�ߩI�sTranscation,�����s�u if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
/// <summary> /// �ت�:�d�߿��~�T����� /// Table: /// B=VDS_STM_ROUTE_STORE_TMP /// ����:[��ƫ��A]=2:���~��ơB[�إߤH��]= /// </summary> public DataTable QueryErrorByFind(string V_CREATEUID, DateTime V_CREATEDATE_S, DateTime V_CREATEDATE_E) { try { OUT05 dbo = new OUT05(ref USEDB); return dbo.doQueryItemTmpError(V_CREATEUID, V_CREATEDATE_S, V_CREATEDATE_E); } catch (Exception ex) { throw ex; } }