コード例 #1
0
        private static Defaultlogin GetOldData(int id, string OldDB)
        {
            string q = "USE " + OldDB + "; ";

            q += "SELECT * FROM " + DEFAULTLOGIN.DEFAULTLOGIN_TBL + " WHERE " + DEFAULTLOGIN.DEFAULTLOGIN_ID + " = '" + id + "'; ";

            using (IDataReader redr = new DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    Defaultlogin obj = new Defaultlogin
                    {
                        Defaultlogin_name = redr[DEFAULTLOGIN.DEFAULTLOGIN_NAME].ToString(),
                        Default_password  = redr[DEFAULTLOGIN.DEFAULT_PASSWORD].ToString(),
                        Createon          = redr[DEFAULTLOGIN.CREATEON].ToString(),
                        Notes             = redr[DEFAULTLOGIN.NOTES].ToString(),
                        Active_id         = redr[DEFAULTLOGIN.ACTIVE_ID].ToString(),
                        User_id           = "1"
                    };

                    return(obj);
                }
                return(null);
            }
        }
コード例 #2
0
 private static void InsertData(Defaultlogin obj, string newDB)
 {
     if (CheckData(obj, newDB) == false)
     {
         CDefaultlogin.Insert(obj, new DAL());
     }
     ;
 }
コード例 #3
0
 private static string AttachParams(string q, Defaultlogin v)
 {
     q = q.Replace("@" + DEFAULTLOGIN.DEFAULTLOGIN_ID + "@", "" + ConvertTO.SqlString(v.Defaultlogin_id) + "");
     q = q.Replace("@" + DEFAULTLOGIN.DEFAULTLOGIN_NAME + "@", "" + ConvertTO.SqlString(v.Defaultlogin_name) + "");
     q = q.Replace("@" + DEFAULTLOGIN.DEFAULT_PASSWORD + "@", "" + ConvertTO.SqlString(v.Default_password) + "");
     q = q.Replace("@" + DEFAULTLOGIN.CREATEON + "@", "" + ConvertTO.SqlDateTime(v.Createon) + "");
     return(q);
 }
コード例 #4
0
        public static void Update(Defaultlogin v, DAL dalsession)
        {
            string q = "UPDATE " + DEFAULTLOGIN.DEFAULTLOGIN_TBL + " SET";

            q += " " + DEFAULTLOGIN.DEFAULTLOGIN_NAME + " = @" + DEFAULTLOGIN.DEFAULTLOGIN_NAME + "@ \r\n ";
            q += "," + DEFAULTLOGIN.DEFAULT_PASSWORD + " = @" + DEFAULTLOGIN.DEFAULT_PASSWORD + "@ \r\n ";
            q += "," + DEFAULTLOGIN.CREATEON + " = @" + DEFAULTLOGIN.CREATEON + "@ \r\n ";
            q += "  WHERE " + DEFAULTLOGIN.DEFAULTLOGIN_ID + " = @" + DEFAULTLOGIN.DEFAULTLOGIN_ID + "@ ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
コード例 #5
0
        public void SetDefault()
        {
            Defaultlogin obj = CDefaultlogin_exten.PKId("1", new DAL());

            if (obj.Defaultlogin_name != null)
            {
                txt_user_name.Text     = obj.Defaultlogin_name;
                txt_user_password.Text = obj.Default_password;
                login_checkBox.Checked = true;
            }
            txt_errorUserPassword.Text = "";
            errorcount = 0;
        }
コード例 #6
0
        public static void Insert(Defaultlogin v, DAL dalsession)
        {
            string q = " INSERT INTO " + DEFAULTLOGIN.DEFAULTLOGIN_TBL + " ( ";

            q += " " + DEFAULTLOGIN.DEFAULTLOGIN_ID + " \r\n ";
            q += "," + DEFAULTLOGIN.DEFAULTLOGIN_NAME + " \r\n ";
            q += "," + DEFAULTLOGIN.DEFAULT_PASSWORD + " \r\n ";
            q += "," + DEFAULTLOGIN.CREATEON + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + DEFAULTLOGIN.DEFAULTLOGIN_ID + "@ \r\n ";
            q += ", @" + DEFAULTLOGIN.DEFAULTLOGIN_NAME + "@ \r\n ";
            q += ", @" + DEFAULTLOGIN.DEFAULT_PASSWORD + "@ \r\n ";
            q += ", @" + DEFAULTLOGIN.CREATEON + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
コード例 #7
0
 private static Defaultlogin EntityData(string q)
 {
     using (IDataReader redr = new DAL().Listreader(q))
     {
         while (redr.Read() == true)
         {
             Defaultlogin obj = new Defaultlogin()
             {
                 Defaultlogin_id   = redr[DEFAULTLOGIN.DEFAULTLOGIN_ID].ToString(),
                 Defaultlogin_name = redr[DEFAULTLOGIN.DEFAULTLOGIN_NAME].ToString(),
                 Default_password  = redr[DEFAULTLOGIN.DEFAULT_PASSWORD].ToString(),
                 Createon          = redr[DEFAULTLOGIN.CREATEON].ToString()
             };
             return(obj);
         }
         redr.Close();
         return(new Defaultlogin());
     }
 }
コード例 #8
0
        private static bool CheckData(Defaultlogin obj, string newDB)
        {
            string q = "USE " + newDB + "; ";

            q += "SELECT * FROM " + DEFAULTLOGIN.DEFAULTLOGIN_TBL + " WHERE " + DEFAULTLOGIN.DEFAULTLOGIN_NAME + " = '" + obj.Defaultlogin_name + "'; ";

            using (IDataReader redr = new DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    obj.Defaultlogin_id = redr[DEFAULTLOGIN.DEFAULTLOGIN_ID].ToString();

                    CDefaultlogin.Update(obj, new DAL());

                    return(true);
                }
                return(false);
            }
        }
コード例 #9
0
        private void Login_checkBox_CheckedChanged(object sender, EventArgs e)
        {
            Defaultlogin obj = CDefaultlogin_exten.PKId("1", new DAL());

            if (login_checkBox.Checked == true)
            {
                if (obj.Defaultlogin_name != null)
                {
                    if ((txt_user_name.Text == obj.Defaultlogin_name) && (txt_user_password.Text == obj.Default_password))
                    {
                        return;
                    }
                    else
                    {
                        obj.Defaultlogin_id   = "1";
                        obj.Defaultlogin_name = txt_user_name.Text;
                        obj.Default_password  = txt_user_password.Text;
                        obj.Createon          = Current.Datetime;

                        CDefaultlogin.Update(obj, new DAL());
                    }
                }
                else
                {
                    if ((txt_user_name.Text != "") || (txt_user_password.Text != ""))
                    {
                        obj.Defaultlogin_id   = "1";
                        obj.Defaultlogin_name = txt_user_name.Text;
                        obj.Default_password  = txt_user_password.Text;
                        obj.Createon          = Current.Datetime;

                        CDefaultlogin.Insert(obj, new DAL());
                    }
                }
            }
            else if (login_checkBox.Checked == false)
            {
                CDefaultlogin.Delete("1", new DAL());
            }
        }