public void QueryTest()
        {
            // Arrange-测试设置,创建对象
            DBHelper db = new DBHelper();
            Customer customer = new Customer()
                                               {
                                                   UserName = "User-1",
                                                   Password = "PWDHASH-1 ",
                                                   Email = "EMAIL-1 ",
                                                   PhoneNumber = "PHONE-1 ",
                                                   IsFirstTimeLogin = false,
                                                   AccessFailedCount = 0,
                                                   CreationDate = DateTime.Now,
                                                   IsActive = false
                                               };
            int count = 0;
            List<Customer> customerList = new List<Customer>();

            // 拼接字符串的时候要注意标量的名字要与类中的成员变量名一样（可忽略字母的大小写）
            // 例如：此处sql中的@Password中的Password就必须与Customer类中的成员变量Password名称一样（可忽略大小写）
            string querySQL = @"SELECT * FROM dbo.CICUser WHERE [email protected] AND [email protected]";

            // Act-测试行为,使用功能
            customerList = db.Query<Customer>(querySQL, customer).ToList();
            count = customerList.Count;

            // Assert-测试结果,验证结果
            Assert.AreEqual(1,count);
        }

 public void clearDB(Context context)
 {
     dbHelper = new DBHelper(context);
     SQLiteDatabase db = dbHelper.WritableDatabase;
     db.Delete("general", null, null);
     db.Delete("records", null, null);
 }

        public RecordInfo getRecordsInfo(String difficulty, Context context)
        {
            dbHelper = new DBHelper(context);
            SQLiteDatabase db = dbHelper.WritableDatabase;
            SQLiteCursor gc = (SQLiteCursor)db.Query("general", null, "difficulty = ?", new String[]{difficulty}, null, null, null);
            int avgTimeColIndex = gc.GetColumnIndex("avgTime");
            int gamesCountColIndex = gc.GetColumnIndex("gamesCount");
            int avgTime = 0;
            int gamesCount = 0;
            if (gc.MoveToFirst()){
                avgTime = gc.GetInt(avgTimeColIndex);
                gamesCount = gc.GetInt(gamesCountColIndex);
            }
            RecordInfo result = new RecordInfo(avgTime, gamesCount, new Java.Lang.String(difficulty));
            SQLiteCursor c = (SQLiteCursor)db.Query("records", null, " difficulty = ?", new String[]{difficulty}, null, null, null);
            if (c.MoveToFirst()) {
                int timeColIndex = c.GetColumnIndex("time");

                result.addRecord(c.GetInt(timeColIndex));
                while (c.MoveToNext()) {
                    result.addRecord(c.GetInt(timeColIndex));
                }
            }
            return result;
        }

        public ImportItem(IProject project, DBHelper dbHelper)
        {
            this._TheProject = project;
            this.DBHelper = dbHelper;

            this.TheProject.TargetDateChanged += this.OnDateChanged;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            #region 标签信息
            string strTagInfo = "";

            try
            {
                string sql = "select * from [tb_tag] where tag_ispublic=1";
                DataTable dt = new DataTable();
                DBHelper dbh = new DBHelper(config.DBConn);
                dt = dbh.ExecuteDataTable("", sql);

                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        strTagInfo += "<a href=\"default.aspx?id=" + dt.Rows[i]["tag_id"].ToString() + "\" class=\"tag\" target=\"_blank\">" + dt.Rows[i]["tag_name"].ToString() + "</a>";
                    }
                }

                dbh.Dispose();
                dt.Dispose();
            }
            catch (Exception ex)
            {
                strTagInfo = ex.ToString();
            }

            this.tagBall.InnerHtml = strTagInfo;

            #endregion
        }

    internal DateTime[] GetYourDates(DBHelper db_, TZ tz_)
    {
      string tableName = "eventTimesGMT";

      switch (tz_)
      {
        case TZ.HK: tableName = "eventTimesHK"; break;
        case TZ.LN: tableName = "eventTimesLN"; break;
        case TZ.NY: tableName = "eventTimesNY"; break;
        case TZ.GMT: tableName = "eventTimesGMT"; break;

      }

      var sql = string.Format("select eventTimeLocal from {1} where eventID={0} order by eventTimeGMT", EventID, tableName);

      var ds = db_.Execute(sql);

      if (DBHelper.HasData(ds))
      {
        var list = new List<DateTime>();

        foreach (DataRow row in ds.Tables[0].Rows)
          list.Add((DateTime)row[0]);

        return list.ToArray();
      }

      return null;
    }

        public List<string> GetUserID(string mode, string user_id)
        {
            List<string> lst = new List<string>();

            DBHelper helper = new DBHelper();
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter(CONSTANT.MODE, mode);
            param[1] = new SqlParameter(CONSTANT.USER_ID, user_id);
            DataSet ds = helper.executeSelectQuery(PROCEDURES.DELETE_USER_OPERTAION, param);
            if (ds != null)
            {

                foreach (DataRow item in ds.Tables[0].Rows)
                {


                    lst.Add(item[0].ToString());


                }
            }

            return lst;

        }

        //const double AllowRange = 0.5;
        public static HoborModel HoborAsker(DBHelper DBHelper,  double XAxis, double YAxis)
        {
            HoborModel result=new HoborModel();
            double AllowRange = GetConfig.GetAllowRange();
            double xAxisAbove = XAxis + AllowRange
                , xAxisBelow = XAxis - AllowRange
                , yAxisAbove = YAxis + AllowRange
                , yAxisBelow = YAxis - AllowRange;

            string commandText = "SELECT * FROM Hobor WHERE XAxis BETWEEN @XAxis1 AND @XAxis2 AND YAxis Between @YXias1 AND @YXias2";
            System.Data.DataTable dt = DBHelper.GetData(commandText, new List<Parameter>()
            {
                new Parameter("@XAxis1",xAxisBelow)
                ,new Parameter("@XAxis2",xAxisAbove)
                ,new Parameter("@YXias1",yAxisBelow)
                ,new Parameter("@YXias2", yAxisAbove)
            });
            if (dt != null && dt.Rows.Count > 0)
            {
                result.IsExist = true;
                result.CountryName = dt.Rows[0]["CountryName"].ToString();
                result.Name = dt.Rows[0]["Name"].ToString();
                result.XAxis = Common.ConvertToDouble(dt.Rows[0]["XAxis"]);
                result.YAxis = Common.ConvertToDouble(dt.Rows[0]["YAxis"]);
                result.Info = dt.Rows[0]["Info"].ToString();
            }
            return result;
        }

        public ListHitViewer()
        {
            InitializeComponent();
            db = new DBHelper();

            //load up the app bar
            ApplicationBar = new ApplicationBar();

            ApplicationBar.Mode = ApplicationBarMode.Minimized;
            ApplicationBar.Opacity = 1.0;
            ApplicationBar.IsVisible = true;
            ApplicationBar.IsMenuEnabled = true;

            //get the item from the phone state!  woo!
            if (PhoneApplicationService.Current.State.ContainsKey("CurrentItem") && PhoneApplicationService.Current.State["CurrentItem"] != null)
            {
                _item = PhoneApplicationService.Current.State["CurrentItem"] as OldItem;

                //only show share if the _item is not null
                ApplicationBarIconButton btnShareAppBar = new ApplicationBarIconButton();
                btnShareAppBar.IconUri = new Uri("/Assets/AppBarIcons/share.png", UriKind.Relative);
                btnShareAppBar.Text = "Tap To Share";
                ApplicationBar.Buttons.Add(btnShareAppBar);
                btnShareAppBar.Click += new EventHandler(btnShareAppBar_Click);
            }

            //feedback button
            ApplicationBarIconButton btnFeedbackAppBar = new ApplicationBarIconButton();
            btnFeedbackAppBar.IconUri = new Uri("/Assets/AppBarIcons/questionmark.png", UriKind.Relative);
            btnFeedbackAppBar.Text = "Feedback";
            ApplicationBar.Buttons.Add(btnFeedbackAppBar);
            btnFeedbackAppBar.Click += new EventHandler(btnFeedbackAppBar_Click);
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (string.IsNullOrWhiteSpace(Request.QueryString["Exhibition"])) return;

            string strExhibitionId = Request.QueryString["Exhibition"];

            DBHelper objHelper = new DBHelper();
            General objGen = new General();

            string strSQL = @"SELECT EXHIBITION_NAME,
                                     EXHIBITION_DETAILS,
                                     EXHIBITON_TEXT,
                                     EXHIBITION_IMAGE
                              FROM   INSTA_MST_EXHIBITION
                              WHERE  EXHIBITION_ID =" + objGen.gReplaceQuotes(strExhibitionId);
            IDataReader reader = objHelper.gExecuteReader(CommandType.Text, strSQL);
            while (reader.Read())
            {

                img.Src = "../../upload/images/Exhibition/" + Convert.ToString(reader["EXHIBITION_IMAGE"]);
                ltHeading.Text = Convert.ToString(reader["EXHIBITION_NAME"]) + Convert.ToString(reader["EXHIBITION_DETAILS"]);
                ltDetail.Text = Convert.ToString(reader["EXHIBITON_TEXT"]);
            }
            reader.Close();
            reader.Dispose();

        }
    }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Url.Host.ToLower() == "localhost")
            {
                //base.login_user_id = 40123; //user
                //base.login_user_id = 40110; //exec producer -- skip
                //base.login_user_id = 272; //producer -- elyse
                //base.login_user_id = 205; //coordinator
                base.login_user_id = 144; //administrator -- randy
                theader.Visible = false;
                aheader.Visible = false;
                levaNav.Visible = false;
                tfooter.Visible = false;
                levbNav.Visible = false;
                groupTest = this.TestGroupMembership;
            }
            else
            {
                base.Page_Load("/newallocations/LockAllocations.aspx");
                groupTest = base.testmembership;
            }
            DBHelper db = new DBHelper();
            if (!groupTest.Invoke(ref db, "A3Coordinator") && !groupTest.Invoke(ref db, "A2Administrator"))
                Response.Redirect("/permitError.html");

            int week_num = RGA.Allocations.Data.Utility.CurrectWeek() + 1;
            WeekNumber.Value = week_num.ToString();
            Week.Text = RGA.Allocations.Data.Utility.CurrectWeekStartDate(week_num).ToString("MM/dd/yy");
        }

        DBHelper helper;  // 和数据库打交道

        public AddBudget(string name)
        {
            InitializeComponent();
            currentUser = name;
            helper = new DBHelper();
            initialize();
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            IsInGroup groupTest = null;
            if (Request.Url.Host.ToLower() == "localhost")
            {
                //base.login_user_id = _UserId = 40123; //user
                //base.login_user_id = _UserId = 40110; //exec producer -- skip
                //base.login_user_id = _UserId = 272; //producer -- elyse
                //base.login_user_id = _UserId = 205; //coordinator
                base.login_user_id = _UserId = 144; //administrator -- randy

                theader.Visible = false;
                aheader.Visible = false;
                levaNav.Visible = false;
                tfooter.Visible = false;
                levbNav.Visible = false;
                groupTest = TestGroupMembership;
            }
            else
            {
                base.Page_Load("/newallocations/TeamAllocation.aspx");
                _UserId = base.login_user_id;
                groupTest = base.testmembership;
            }

            // determine if the user's group and set a variable to use when printing out allocations
            DBHelper db = new DBHelper();
            if (groupTest.Invoke(ref db, "A3Coordinator"))
                _secType = RgaWeb.SecurityType.EditAll;
            if (groupTest.Invoke(ref db, "A2Administrator"))
                _secType = RgaWeb.SecurityType.EditAll;
            if (groupTest.Invoke(ref db, "A8Producer"))
                _secType = RgaWeb.SecurityType.EditUpcoming;
            if (groupTest.Invoke(ref db, "A5ExecProducer"))
                _secType = RgaWeb.SecurityType.EditUpcoming;

            if (!Page.IsPostBack)
            {
                LoadRegions();
                LoadDepartments();

                // retrieve current week and date 
                _StartWeek = RgaData.Utility.CurrectWeek();
                _StartDate = RgaData.Utility.CurrectWeekStartDate(_StartWeek);

                // setup week picker
                ctlWeekPicker.CurrentWeek = _StartWeek;
                ctlWeekPicker.CurrectWeekStartDate = _StartDate;
            }
            else
            {
                // set start week
                _StartWeek = ctlWeekPicker.CurrentWeek;
            }

            // set up delegate to rebind the grid when week selection is changed
            DelSelectWeek delSelectWeek = new DelSelectWeek(this.ctlWeekPicker_SelectedIndexChanged);
            ctlWeekPicker.UpdateCurrentWeek = delSelectWeek;
        }

 public bool Test()
 {
     SqlParameter[] param = new SqlParameter[1];
     DBHelper helper = new DBHelper();
     param[0] = new SqlParameter(CONSTANT.CAT_ID, "ZCVV");
     bool ds = helper.InsertQuery(PROCEDURES.CAT_INSERT, param);
     return ds;
 }

        public void putRecord(long time, String difficulty, Context context)
        {
            dbHelper = new DBHelper(context);
            ContentValues cv = new ContentValues();
            SQLiteDatabase db = dbHelper.WritableDatabase;
            SQLiteCursor c = (SQLiteCursor)db.Query("records", null, " difficulty = ?", new String[]{difficulty}, null, null, null);
            int count = 1;
            if (c.MoveToFirst()) {

                int idColIndex = c.GetColumnIndex("id");
                int timeColIndex = c.GetColumnIndex("time");

                int maxDBindex = c.GetInt(idColIndex);
                int maxDBtime = c.GetInt(timeColIndex);
                count++;
                while (c.MoveToNext()) {
                    if (c.GetInt(timeColIndex) > maxDBtime){
                        maxDBtime = c.GetInt(timeColIndex);
                        maxDBindex = c.GetInt(idColIndex);
                    }
                    count++;
                }
                if (count == 6){
                    if (time < maxDBtime){
                        db.Delete("records", " id = ?", new String[]{maxDBindex + ""});
                    } else {
                        c.Close();
                        db.Close();
                        return;
                    }
                }
            }
            cv.Put("time", time);
            cv.Put("difficulty", difficulty);
            db.Insert("records", null, cv);
            cv.Clear();

            SQLiteCursor gc = (SQLiteCursor)db.Query("general", null, "difficulty = ?", new String[]{difficulty}, null, null, null);
            gc.MoveToFirst();
            int avgTimeColIndex = gc.GetColumnIndex("avgTime");
            int gamesCountColIndex = gc.GetColumnIndex("gamesCount");
            int avgTime = 0;
            int gamesCount = 0;
            if (gc.MoveToFirst()){
                avgTime = gc.GetInt(avgTimeColIndex);
                gamesCount = gc.GetInt(gamesCountColIndex);
            }
            int newGamesCount = gamesCount + 1;
            int newAvgTime = (avgTime * gamesCount / newGamesCount) + (int)(time / newGamesCount);
            cv.Put("difficulty", difficulty);
            cv.Put("avgTime", newAvgTime);
            cv.Put("gamesCount", newGamesCount);
            db.Delete("general", " difficulty = ?", new String[]{difficulty});
            db.Insert("general", null, cv);
            db.Close();
            c.Close();
            gc.Close();
        }

       public int deleteProduct(string product_id)
       {
           DBHelper helper = new DBHelper();

           SqlParameter[] param = new SqlParameter[1];
           param[0] = new SqlParameter(CONSTANT.PRODUCT_ID, product_id);
           int res = helper.InsertQuery(PROCEDURES.DELETE_PRODUCT, param);
           return res;
       }

 public frmCMS()
 {
     InitializeComponent();
     this.DBHelper = new DBHelper(new DBHelperConnection(this.ConnectionString ,this.FactoryName ));
     this.cmbApp.DataSource = this.DBHelper.GetDataSet("SELECT * FROM VOD_APP ORDER BY APP_CODE", "VOD_APP").Tables[0];
     this.cmbApp.DisplayMember = "APP_NAME";
     this.cmbApp.ValueMember = "APP_CODE";
     this.LoadList();
 }

 /// <summary>
 /// ����Ĭ�ϵ����ݿ������
 /// </summary>
 /// <returns></returns>
 public static DBHelper Instance()
 {
     if (helper == null)
     {
         helper = new DBHelper(connectionString, dbProviderName);
         return helper;
     }
     return helper;
 }

 public void QueryAllTest()
 {
     // arrange
     DBHelper db = new DBHelper();
     var list = db.QueryAll<DealerServiceLog>().ToList();
     // act
     int count = list.Count;
     // assert
     Assert.AreEqual(4, count);
 }

       public int deleteSubCategory(int id)
       {
           DBHelper helper = new DBHelper();

           SqlParameter[] param = new SqlParameter[1];
           param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, id);
           int res = helper.InsertQuery(PROCEDURES.DELETE_SUB_CATEGORY, param);

           return res;
        
       }