Exemplos de KJ128NDataBase.DBAcess em C# (CSharp)

Exemplo n.º 1

Arquivo: RealTimeInOutStation.cs Projeto: wwkkww1983/128_5.6_2010

        private void ShowDate()
        {
            KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
            DataTable dtInStationTable     = dbAcess.GetDataSet("select * from KJ128N_RT_InStation_Table order by 发码器地址").Tables[0];

            dgvInOutStationInfo.DataSource = dtInStationTable.DefaultView;
        }

Exemplo n.º 2

Arquivo: RealTimeEmployeeInfo.cs Projeto: ZoeCheck/128_5.6_2010

 private void timer1_Tick(object sender, EventArgs e)
 {
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     using (DataSet ds = dbAcess.GetDataSet("Select * from KJ128_RealTimeEmployee_Info_Table"))
     {
         dgvRealTimeEmployeeInfo.DataSource=ds.Tables[0].DefaultView;
     }
     dgvRealTimeEmployeeInfo.EnableHeadersVisualStyles = false;
     timer1.Interval = 5000;
 }

Exemplo n.º 3

 private void timer1_Tick(object sender, EventArgs e)
 {
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     using (DataSet ds = dbAcess.GetDataSet("Select * from KJ128_RealTimeEmployee_Info_Table"))
     {
         dgvRealTimeEmployeeInfo.DataSource = ds.Tables[0].DefaultView;
     }
     dgvRealTimeEmployeeInfo.EnableHeadersVisualStyles = false;
     timer1.Interval = 5000;
 }

Exemplo n.º 4

Arquivo: FrmLogin.cs Projeto: wwkkww1983/128_5.6_2010

 // 将所有菜单添加到表中
 private void SetMenuAll(ToolStripItemCollection items)
 {
     KJ128NDataBase.DBAcess dba = new KJ128NDataBase.DBAcess();
     foreach (ToolStripMenuItem tsi in items)
     {
         string str = string.Format("insert into menus1(PMenuID,Title,name) values({2},'{0}','{1}')", tsi.Text.Substring(0, tsi.Text.Length - 4), tsi.Name
                                    , tsi.Text.IndexOf("1") > -1 ? "-1" : dba.ExecuteScalarSql("select id from menus1 where name ='" + tsi.OwnerItem.Name + "'"));
         dba.ExecuteSql(str);
         System.IO.File.AppendAllText("c:/sql.txt", str + "\r\n", Encoding.Default);
         if (tsi.DropDownItems.Count > 0)
         {
             SetMenuAll(tsi.DropDownItems);
         }
     }
 }

Exemplo n.º 5

Arquivo: A_AddEmpDAL.cs Projeto: wwkkww1983/128_5.6_2010

 public DataTable GetPhotoTab(int PhotoID)
 {
     sqlString = string.Format("select * from Emp_Photo where PhotoID={0}", PhotoID);
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     using (DataSet ds = dbAcess.GetDataSet(sqlString))
     {
         if (ds != null)
         {
             return(ds.Tables[0]);
         }
         else
         {
             return(null);
         }
     }
 }

Exemplo n.º 6

Arquivo: AddEmpDAL.cs Projeto: wwkkww1983/128_5.6_2010

 /// <summary>
 /// 获取职务Table
 /// </summary>
 /// <returns>返回职务Table</returns>
 public DataTable GetEmpDutyTab()
 {
     sqlString = "select DutyID,职务名称 from KJ128N_Duty_Info_Table";
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     using (DataSet ds = dbAcess.GetDataSet(sqlString))
     {
         if (ds != null)
         {
             return(ds.Tables[0]);
         }
         else
         {
             return(null);
         }
     }
 }

Exemplo n.º 7

Arquivo: A_FrmLogin.cs Projeto: ZoeCheck/128_5.6_2010

        // 将所有菜单添加到表中
        private void SetMenuAll(ToolStripItemCollection items)
        {
            KJ128NDataBase.DBAcess dba = new KJ128NDataBase.DBAcess();
            foreach (ToolStripMenuItem tsi in items)
            {
                string str = string.Format("insert into menus1(PMenuID,Title,name) values({2},'{0}','{1}')", tsi.Text.Substring(0, tsi.Text.Length - 4), tsi.Name
                , tsi.Text.IndexOf("1") > -1 ? "-1" : dba.ExecuteScalarSql("select id from menus1 where name ='" + tsi.OwnerItem.Name + "'"));
                dba.ExecuteSql(str);
                System.IO.File.AppendAllText("c:/sql.txt", str + "\r\n", Encoding.Default);
                if (tsi.DropDownItems.Count > 0)
                {
                    SetMenuAll(tsi.DropDownItems);
                }
            }

        }

Exemplo n.º 8

Arquivo: A_AddEmpDAL.cs Projeto: ZoeCheck/128_5.6_2010

 public DataTable GetPhotoTab(int PhotoID)
 {
     sqlString = string.Format("select * from Emp_Photo where PhotoID={0}", PhotoID);
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     using (DataSet ds = dbAcess.GetDataSet(sqlString))
     {
         if (ds != null)
         {
             return ds.Tables[0];
         }
         else
         {
             return null;
         }
     }
 }

Exemplo n.º 9

Arquivo: AddEmpDAL.cs Projeto: ZoeCheck/128_5.6_2010

        /// <summary>
        /// 获取职务Table
        /// </summary>
        /// <returns>返回职务Table</returns>
        public DataTable GetEmpDutyTab()
        {

            sqlString = "select DutyID,职务名称 from KJ128N_Duty_Info_Table";
            KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
            using (DataSet ds = dbAcess.GetDataSet(sqlString))
            {
                if (ds != null)
                {
                    return ds.Tables[0];
                }
                else
                {
                    return null;
                }
            }
        }

Exemplo n.º 10

Arquivo: RealTimeInOutStation.cs Projeto: ZoeCheck/128_5.6_2010

 private void ShowDate()
 {
     KJ128NDataBase.DBAcess dbAcess = new KJ128NDataBase.DBAcess();
     DataTable dtInStationTable = dbAcess.GetDataSet("select * from KJ128N_RT_InStation_Table order by 发码器地址").Tables[0];
     dgvInOutStationInfo.DataSource = dtInStationTable.DefaultView;
 }