예제 #1
0
        private void buttonMasterData_Click(object sender, EventArgs e)
        {
            string    MasterDataQuery = "DECLARE @StoreID int = 0 SELECT @StoreID = ISNULL(redStoreID, 0) FROM redStoreOverride WHERE redStoreID = " + StoreID + " SELECT @StoreID StoreID";
            DataTable MasterDataDT    = Catman_Class_Library.SqlFunctions_RedReport.GetData(MasterDataQuery);
            DataRow   MasterDataDR    = MasterDataDT.Rows[0];

            if (MasterDataDR["StoreID"].ToString() == "0")
            {
                FormCreateStoreData formCreateStoreData = new FormCreateStoreData();
                formCreateStoreData._StoreID = StoreID;
                formCreateStoreData.ShowDialog();
            }
            else
            {
                string    MasterDataUpdateQuery = "SELECT redStoreOverrideID FROM redStoreOverride WHERE redStoreID = " + StoreID;
                DataTable MasterDataUpdateDT    = Catman_Class_Library.SqlFunctions_RedReport.GetData(MasterDataUpdateQuery);
                DataRow   MasterDataUpdateDR    = MasterDataUpdateDT.Rows[0];

                FormUpdateStoreData formUpdateStoreData = new FormUpdateStoreData();
                formUpdateStoreData._StoreID = MasterDataUpdateDR["redStoreOverrideID"].ToString();
                formUpdateStoreData.ShowDialog();
            }
        }
예제 #2
0
        private void buttonOverrideAS400_Click(object sender, EventArgs e)
        {
            if (buttonOverrideAS400.Text == "Edit")
            {
                //FormUpdateStoreOverride updateStoreOverride = new FormUpdateStoreOverride();
                //updateStoreOverride._StoreID = Convert.ToInt32(StoreID);
                //updateStoreOverride.ShowDialog();

                string    MasterDataQuery = "DECLARE @StoreID int = 0 SELECT @StoreID = ISNULL(redStoreID, 0) FROM redStoreOverride WHERE redStoreID = " + StoreID + " SELECT @StoreID StoreID";
                DataTable MasterDataDT    = Catman_Class_Library.SqlFunctions_RedReport.GetData(MasterDataQuery);
                DataRow   MasterDataDR    = MasterDataDT.Rows[0];

                if (MasterDataDR["StoreID"].ToString() == "0")
                {
                    FormCreateStoreData formCreateStoreData = new FormCreateStoreData();
                    formCreateStoreData._StoreID = StoreID;
                    formCreateStoreData.ShowDialog();
                }
                else
                {
                    string    MasterDataUpdateQuery = "SELECT redStoreOverrideID FROM redStoreOverride WHERE redStoreID = " + StoreID;
                    DataTable MasterDataUpdateDT    = Catman_Class_Library.SqlFunctions_RedReport.GetData(MasterDataUpdateQuery);
                    DataRow   MasterDataUpdateDR    = MasterDataUpdateDT.Rows[0];

                    FormUpdateStoreData formUpdateStoreData = new FormUpdateStoreData();
                    formUpdateStoreData._StoreID = MasterDataUpdateDR["redStoreOverrideID"].ToString();
                    formUpdateStoreData.ShowDialog();
                }
            }
            else
            {
                FormViewStore viewStore = new FormViewStore();
                viewStore._StoreID = Convert.ToInt32(StoreID);
                viewStore.ShowDialog();
            }
        }