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); }
public DataTable CheckClosePosition(M_StoreClose_Entity msce) { return(mscdl.M_StoreClose_SelectAll(msce)); }