/// <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();
}
}