/// <summary> /// ログインボタンクリックアクション /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void loginBtn_Click(object sender, EventArgs e) { CommonFunction common = new CommonFunction(); common.setDbPath(this.dataSourcePath.Text); using (var context = new MyContext()) { long condtion = Convert.ToInt64(this.UserId.Text); var w = context.UserMst.Where(x => x.EMP_ID == condtion && x.SANKA_KAHI == 0).ToArray(); if (w.Count() == 0) { MessageBox.Show( MessageConst.ERR_007, System.Windows.Forms.Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (w.Count() == 1) { WordConverter.Settings1.Default.UserId = this.UserId.Text; WordConverter.Settings1.Default.DataSource = this.dataSourcePath.Text; WordConverter.Settings1.Default.Save(); UserInfoBo userInfo = new UserInfoBo(); userInfo.kengen = w[0].KENGEN; userInfo.userId = w[0].USER_ID; userInfo.hotKey = WordConverter.Settings1.Default.HotKey; BaseForm form = new BaseForm(userInfo); this.Close(); return; } } }
static void ExecuteDDL() { var path = System.IO.Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "WordConverter.db"); if (File.Exists(path)) { return; } System.Data.SQLite.SQLiteConnection.CreateFile(path); var cnStr = new System.Data.SQLite.SQLiteConnectionStringBuilder() { DataSource = path }; CommonFunction common = new CommonFunction(); common.setDbPath(path); using (var cn = new System.Data.SQLite.SQLiteConnection(cnStr.ToString())) { cn.Open(); // テーブル名は複数形で指定する(Wordではなく、Words) var sql = "CREATE TABLE WORD_DIC( "; sql += " WORD_ID INTEGER PRIMARY KEY AUTOINCREMENT"; sql += " , RONRI_NAME1 TEXT"; sql += " , RONRI_NAME2 TEXT"; sql += " , BUTSURI_NAME TEXT"; sql += " , USER_ID INTEGER"; sql += " , VERSION INTEGER"; sql += " , CRE_DATE TEXT"; sql += " , FOREIGN KEY (USER_ID) REFERENCES USER_MST(USER_ID)"; sql += "); "; sql += "CREATE TABLE WORD_SHINSEI( "; sql += " SHINSEI_ID INTEGER PRIMARY KEY AUTOINCREMENT"; sql += " , RONRI_NAME1 TEXT"; sql += " , RONRI_NAME2 TEXT"; sql += " , BUTSURI_NAME TEXT"; sql += " , WORD_ID INTEGER"; sql += " , STATUS INTEGER"; sql += " , USER_ID INTEGER"; sql += " , VERSION INTEGER"; sql += " , CRE_DATE TEXT"; sql += " , FOREIGN KEY (USER_ID) REFERENCES USER_MST(USER_ID)"; sql += "); "; sql += "CREATE TABLE USER_MST( "; sql += " USER_ID INTEGER PRIMARY KEY AUTOINCREMENT"; sql += " , EMP_ID INTEGER UNIQUE "; sql += " , USER_NAME TEXT"; sql += " , KENGEN INTEGER"; sql += " , MAIL_ID TEXT"; sql += " , PASSWORD TEXT"; sql += " , MAIL_ADDRESS TEXT"; sql += " , SANKA_KAHI INTEGER"; sql += " , DELETE_FLG INTEGER"; sql += " , VERSION INTEGER"; sql += " , CRE_DATE TEXT"; sql += "); "; sql += "insert into USER_MST(USER_ID,EMP_ID,USER_NAME,KENGEN,MAIL_ID,PASSWORD,MAIL_ADDRESS,SANKA_KAHI,DELETE_FLG,VERSION) values (1,999, 'Admin',0,'999','*****@*****.**','*****@*****.**',0,0,0);"; var cmd = new System.Data.SQLite.SQLiteCommand(sql, cn); cmd.ExecuteNonQuery(); cn.Close(); } }
/// <summary> /// 初期表示アクション /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Login_Load(object sender, EventArgs e) { CommonFunction common = new CommonFunction(); this.dataSourcePath.Text = common.getDbPath(); this.UserId.Text = WordConverter.Settings1.Default.UserId; }