private void btnSwitchSchool_Click(object sender, EventArgs e)
{
chapyEntities db = new chapyEntities(VariableGlobal.connectionString);
if (db.CpSchools.Count() > 0)
{
Thread thread = new Thread(new ThreadStart(ShowFormSchoolSelect)); //Tạo luồng mới
thread.SetApartmentState(ApartmentState.STA);
thread.Start(); //Khởi chạy luồng
this.Close(); //đóng Form hiện tại. (Form1)
}
else
{
MessageBox.Show("Please create schools first");
}
}
private void btn_MakeSchedule_Click(object sender, EventArgs e)
{
chapyEntities db = new chapyEntities(VariableGlobal.connectionString);
var terms = (from t in db.CpTerms where t.SchoolId == VariableGlobal.school_id select t).SingleOrDefault();
if (terms != null)
{
Thread thread = new Thread(new ThreadStart(ShowFormMakeShift)); //Tạo luồng mới
thread.SetApartmentState(ApartmentState.STA);
thread.Start(); //Khởi chạy luồng
this.Close(); //đóng Form hiện tại. (Form1)
}
else
{
MessageBox.Show("法人マスタ及び、施設マスタを登録することが必要です。");
}
}
static void Main()
{
try
{
string keyLink = "";
/*read registry */
if (Environment.Is64BitOperatingSystem)
{
keyLink = "HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Child\\勤務割";
}
else
{
keyLink = "HKEY_LOCAL_MACHINE\\SOFTWARE\\Child\\勤務割";
}
string displayName = (string)Registry.GetValue(keyLink, "DisplayName", "");
if (displayName == "")
{
MessageBox.Show("正しくインストールされていません。お問い合わせは、担当のコンピュータ部運営所まで、お電話をおかけて下さい。");
return;
}
/*end read registry */
string serverName = Environment.MachineName;
string instance = "";
string preFix = "CTaskSchedule";
string sufFix = "";
string user = "******";
string pass = "******";
string port = "2346";
string loginMode = "";
string[] args = Environment.GetCommandLineArgs();
//Environment.GetEnvironmentVariable();
for (int i = 0; i < args.Length; i++)
{
if (i < args.Length)
{
string arg = args[i];
//get serverName
if (arg.ToLower() == "-s")
{
serverName = args[i + 1];
}
//get instance
if (arg.ToLower() == "-i")
{
instance = args[i + 1];
}
//get PreFix
if (arg.ToLower() == "-d")
{
preFix = args[i + 1];
}
//get sufFix
if (arg.ToLower() == "-f")
{
sufFix = args[i + 1];
}
//get user
if (arg.ToLower() == "-u")
{
user = args[i + 1];
}
//get pass
if (arg.ToLower() == "-p")
{
pass = args[i + 1];
}
if (arg.ToLower() == "-po")
{
port = args[i + 1];
}
if (arg.ToLower() == "-l")
{
loginMode = args[i + 1];
}
}
}
/* khoi tao thong tin server*/
//string machineName = Environment.MachineName;
//string sqlInstanceDefault = instance;
//string prefix = "CTaskSchedule";
//dbName = dbName != "" ? dbName : "Child";
//string userSql = user != "" ? user : "******";
//string passSql = pass != "" ? pass : "******";
//string serverName = sqlInstanceDefault != "" ? machineName + "\\" + sqlInstanceDefault : machineName;
//string databaseName = prefix + "_" + dbName;
string databaseName = preFix + "_Child" + sufFix;
string serverSql = instance != "" ? serverName + "\\" + instance : serverName;
string connectionString = "Server=" + serverSql + ";";
connectionString += "Database=" + databaseName + ";";
if (loginMode == "window")
{
connectionString += "Trusted_Connection=True;";
}
else
{
connectionString += "User Id=" + user + ";Password="******";";
}
string connectionStringMaster = "Server=" + serverSql + ";";
connectionStringMaster += "Database=;";
if (loginMode == "window")
{
connectionStringMaster += "Trusted_Connection=True;";
}
else
{
connectionStringMaster += "User Id=" + user + ";Password="******";";
}
/* end khoi tao thong tin server*/
/* connect to master database
* check database exsit?
* neu chua ton tai se tao db moi
*/
//databaseName = "BanHang";
string sqlCheckDb = "IF EXISTS (SELECT * FROM sysdatabases WHERE name = N'" + databaseName + "') BEGIN SELECT 1; END";
SqlConnection conn = new SqlConnection(connectionStringMaster);
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
//if(conn.State ==
SqlCommand sqlCommand = new SqlCommand(sqlCheckDb, conn);
SqlDataReader reader = sqlCommand.ExecuteReader();
var exist = "0";
while (reader.Read())
{
exist = reader[0].ToString();
break;
}
reader.Dispose();
/* chua ton tai */
if (exist == "0")
{
/* create database */
string sqlCreateDb = "IF NOT EXISTS( SELECT * FROM sysdatabases WHERE name = \'" + databaseName + "\')"
+ " BEGIN "
+ " CREATE DATABASE " + databaseName + "; "
+ " END";
SqlCommand cmdCreateDb = new SqlCommand(sqlCreateDb, conn);
var data = cmdCreateDb.ExecuteNonQuery();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
/* create table
change connect to
*/
SqlConnection connChild = new SqlConnection(connectionString);
string linkScript = Application.StartupPath + "\\script.sql";
FileInfo file = new FileInfo(@linkScript);
string script = file.OpenText().ReadToEnd();
if (connChild.State == ConnectionState.Closed)
{
connChild.Open();
}
SqlCommand cmdCreatTables = new SqlCommand(script, connChild);
cmdCreatTables.ExecuteNonQuery();
if (connChild.State == ConnectionState.Open)
{
connChild.Close();
}
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(connectionString);
MessageBox.Show(ex.Message);
return;
}
string dbConnString = @"data source=" + serverSql + ";initial catalog=" + databaseName + ";User Id=" + user + ";Password="******";integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
/*end check database*/
VariableGlobal.connectionString = dbConnString;
chapyEntities db = new chapyEntities(dbConnString);
/* run single instance */
if (SingleApplication.Run() == false)
{
return;
}
/* end run single instance */
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var List_School = from s in db.CpSchools select s;
if (List_School.Any())
{
Application.Run(new FrmSchoolSelect());
}
else
{
Application.Run(new FrmMain());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
private void btn_CreatSchool_Click(object sender, EventArgs e)
{
chapyEntities db = new chapyEntities(VariableGlobal.connectionString);
if (db.CpCorporations.Count() > 0)
{
Thread thread = new Thread(new ThreadStart(ShowSchool)); //Tạo luồng mới
thread.SetApartmentState(ApartmentState.STA);
thread.Start(); //Khởi chạy luồng
this.Close(); //đóng Form hiện tại. (Form1)
}
else
{
MessageBox.Show("施設を登録する前に、法人マスタを登録が必要です。");
}
}