メモ のバックアップ(No.5)

[ トップ ]   [ 新規 | 一覧 | 単語検索 | 最終更新 | ヘルプ ]

• バックアップ一覧
• ソース を表示
• メモ は削除されています。
  • 1 (2016-08-26 (金) 14:18:46)
  • 2 (2016-08-26 (金) 14:33:35)
  • 3 (2016-09-09 (金) 15:14:43)
  • 4 (2016-09-21 (水) 12:47:39)
  • 5 (2017-02-27 (月) 20:44:06)
  • 6 (2023-09-06 (水) 23:17:38)

---

「.NET 開発基盤部会 Wiki」は、「Open棟梁Project」,「OSSコンソーシアム .NET開発基盤部会」によって運営されています。

覚書(TODO) †

DDL †

継続的に、見直し。

コントロールタイプ †

カスタマイズ画面の入力コントロールに種類の指定が必要か？

その他 †

フラグ初期化タイミング †

• ログイン
  • EnterprisesID
  • StoresID
• 画面生成
  • DevicesID
  • InitializeScreenInfoID

集計処理 †

SQL †

ｘ年の集計（月ごと） †

• 生ログ

  [2016/08/26 14:14:40,341],[INFO ],[29],2,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-1,period_e=2013-2,
  [2016/08/26 14:14:56,555],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-2,period_e=2013-3,
  [2016/08/26 14:15:05,549],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-3,period_e=2013-4,
  [2016/08/26 14:15:06,858],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-4,period_e=2013-5,
  [2016/08/26 14:15:11,251],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-5,period_e=2013-6,
  [2016/08/26 14:15:13,322],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-6,period_e=2013-7,
  [2016/08/26 14:15:16,276],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-7,period_e=2013-8,
  [2016/08/26 14:15:27,959],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-8,period_e=2013-9,
  [2016/08/26 14:15:32,730],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-9,period_e=2013-10,
  [2016/08/26 14:15:38,290],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-10,period_e=2013-11,
  [2016/08/26 14:15:42,468],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-11,period_e=2013-12,
  [2016/08/26 14:16:45,770],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-12,period_e=2014-01,

• commandText

  select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;

• commandParameter

  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-1,period_e=2013-2,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-2,period_e=2013-3,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-3,period_e=2013-4,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-4,period_e=2013-5,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-5,period_e=2013-6,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-6,period_e=2013-7,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-7,period_e=2013-8,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-8,period_e=2013-9,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-9,period_e=2013-10,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-10,period_e=2013-11,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-11,period_e=2013-12,
  enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-12,period_e=2014-01,

†

null 合体演算子 †

左側のオペランドが

• null 値でない場合には左側、
• null 値である場合には右側の

オペランドを返す。

return XXXX ?? YYYY;

     

Site admin: TechInfoOfMicrosoftTech

PukiWiki 1.4.7 Copyright © 2001-2006 PukiWiki Developers Team. License is GPL.
Based on "PukiWiki" 1.3 by yu-ji. Powered by PHP 5.3.3. HTML convert time: 0.009 sec.