public bool M_StoreClose_SelectAll(M_StoreClose_Entity me)
        {
            M_StoreClose_DL dl = new M_StoreClose_DL();
            DataTable       dt = dl.M_StoreClose_SelectAll(me);

            if (dt.Rows.Count > 0)
            {
                me.FiscalYYYYMM          = dt.Rows[0]["FiscalYYYYMM"].ToString();
                me.ClosePosition1        = dt.Rows[0]["ClosePosition1"].ToString();
                me.ClosePosition2        = dt.Rows[0]["ClosePosition2"].ToString();
                me.ClosePosition3        = dt.Rows[0]["ClosePosition3"].ToString();
                me.ClosePosition4        = dt.Rows[0]["ClosePosition4"].ToString();
                me.ClosePosition5        = dt.Rows[0]["ClosePosition5"].ToString();
                me.MonthlyClaimsFLG      = dt.Rows[0]["MonthlyClaimsFLG"].ToString();
                me.MonthlyClaimsDateTime = dt.Rows[0]["MonthlyClaimsDateTime"].ToString();
                me.MonthlyDebtFLG        = dt.Rows[0]["MonthlyDebtFLG"].ToString();
                me.MonthlyDebtDateTime   = dt.Rows[0]["MonthlyDebtDateTime"].ToString();
                me.MonthlyStockFLG       = dt.Rows[0]["MonthlyStockFLG"].ToString();
                me.MonthlyStockDateTime  = dt.Rows[0]["MonthlyStockDateTime"].ToString();
                return(true);
            }
            else
            {
                if (string.IsNullOrWhiteSpace(me.FiscalYYYYMM))
                {
                    string ymd = GetDate();
                    me.FiscalYYYYMM = ymd.Substring(0, 4) + ymd.Substring(5, 2);
                }
                //レコ―ドが無い場合、 テーブル転送仕様Aに従ってInsert	M_StoreClose
                dl.M_StoreClose_Insert(me);
            }

            return(false);
        }
예제 #2
0
 public DataTable CheckClosePosition(M_StoreClose_Entity msce)
 {
     return(mscdl.M_StoreClose_SelectAll(msce));
 }