public static void SetChecked(bool state)
{
if (state)
OperatorFile.WriteIniFileString("Login", "Checked", "y", file);
else
OperatorFile.WriteIniFileString("Login", "Checked", "n", file);
}
public DataBase()
{
string strServer = OperatorFile.GetIniFileString("DataBase", "Server", "", Application.StartupPath + "\\Config.ini");
//获取登录用户
string strUserID = OperatorFile.GetIniFileString("DataBase", "User", "",
Application.StartupPath + "\\Config.ini");
//获取登录密码
string strPwd = OperatorFile.GetIniFileString("DataBase", "Password", "", Application.StartupPath + "\\Config.ini");
//获取数据库名
string strDb = OperatorFile.GetIniFileString("DataBase", "DbName", "", Application.StartupPath + "\\Config.ini");
//数据库连接字符串
// string strConn = "Server = " + strServer + ";Database=ctl;User id=" + strUserID + ";PWD=" + strPwd;
string strConn = "Database=" + strDb + ";Data Source=" + strServer + ";User Id=" + strUserID + ";Password="******";charset='utf8';pooling=true";
try
{
m_Conn = new MySqlConnection(strConn);
m_Cmd = new MySqlCommand();
m_Cmd.Connection = m_Conn;
}
catch (Exception e)
{
throw e;
}
}
static ServerInfo()
{
try
{
strServer = OperatorFile.GetIniFileString("DataBase", "Server", "", Environment.CurrentDirectory + "\\AmbleAppServer.ini");
}
catch (Exception ex)
{
Logger.Error(ex.Message);
MessageBox.Show("Please check the AmbleAppServer.ini file.");
}
try
{
ChannelServices.RegisterChannel(new TcpClientChannel(), false);
dbinfo = (DatabaseInfo)Activator.GetObject(typeof(DatabaseInfo), "tcp://192.168.1.101:1111/DatabaseInfo");
userId = DecryptDES(dbinfo.GetDbUser(), desKey);
password = DecryptDES(dbinfo.GetDbPassword(), desKey);
}
catch (Exception ex)
{
Logger.Error(ex.Message);
Logger.Error(ex.StackTrace);
// MessageBox.Show("Can not Connected to the Server---------, Please contact the Admin.");
}
}
public void LoadFromFile(string fnIni)
{
ClientName = OperatorFile.GetIniFileString("client", "name", ClientName, fnIni);
ServerName = OperatorFile.GetIniFileString("server", "name", ServerName, fnIni);
ServerIp = OperatorFile.GetIniFileString("server", "ip", ServerIp, fnIni);
ServerPort = OperatorFile.GetIniFileString("server", "port", "50000", fnIni);
}
public void SaveToFile(string fnIni)
{
OperatorFile.WriteIniFileString("server", "port", ClientName, fnIni);
OperatorFile.WriteIniFileString("server", "name", ServerName, fnIni);
OperatorFile.WriteIniFileString("server", "ip", ServerIp, fnIni);
OperatorFile.WriteIniFileString("server", "port", ServerPort, fnIni);
}
public static bool isChecked()
{
string isChecked=OperatorFile.GetIniFileString("Login", "Checked", "",file);
if (isChecked == "y"||isChecked=="Y")
return true;
else
return false;
}
private void LoadIniFile()
{
string iniName = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "server.ini");
try
{
Title = OperatorFile.GetIniFileString("server", "name", defaultTitle, iniName);
}
catch (Exception ex)
{
Title = defaultTitle;
}
}
public DataBase()
{
string strServer = OperatorFile.GetIniFileString
("DataBase", "Server", "", Application.StartupPath.ToString() + "//ERP-LIJUN.ini");
string strConn = "Server = " + strServer + ";Database=db_ERP;integrated security = SSPI";
try
{
m_Conn = new SqlConnection(strConn);
m_Cmd = new SqlCommand();
m_Cmd.Connection = m_Conn;
}catch (Exception e)
{
throw e;
}
}
public static void printWord(DataRow row)
{
string path = Application.StartupPath + @"\钠离子检测.docx";
string hospitalName = OperatorFile.GetIniFileString("patientCheck", "name", "", Application.StartupPath + "\\setting.ini");
Report report = new Report();
report.CreateNewDocument(path);
report.InsertValue("hospitalname", hospitalName);
report.InsertValue("name", row["name"].ToString());
report.InsertValue("hospitalnumber", row["hospitalnumber"].ToString());
report.InsertValue("age", row["age"].ToString());
report.InsertValue("sex", row["sex"].ToString());
report.InsertValue("category", row["category"].ToString());
report.InsertValue("bednumber", row["bednumber"].ToString());
report.InsertValue("time", row["time"].ToString());
report.InsertPicture("picture", row["picturepath"].ToString(), 460, 160);
report.InsertValue("remark", row["remark"].ToString());
report.printWord();
}
public static void printWord(Patient p)
{
string path = Application.StartupPath + @"\钠离子检测.docx";
string hospitalName = OperatorFile.GetIniFileString("patientCheck", "name", "", Application.StartupPath + "\\setting.ini");
Report report = new Report();
report.CreateNewDocument(path);
report.InsertValue("hospitalname", hospitalName);
report.InsertValue("name", p.name);
report.InsertValue("hospitalnumber", p.hostipalNumber.ToString());
report.InsertValue("age", p.age.ToString());
report.InsertValue("sex", p.sex);
report.InsertValue("category", p.cateGory);
report.InsertValue("bednumber", p.bedNumber.ToString());
report.InsertValue("time", p.dateTime.ToString("yyyy-MM-dd hh:mm:ss"));
report.InsertPicture("picture", p.picturePath, 460, 160);
report.InsertValue("remark", p.remark);
report.printWord();
}
public DataBase()
{
string strServer = OperatorFile.GetIniFileString("Database", "Server", "", Application.StartupPath + "\\ERP_Learning.ini");
string strUserID = OperatorFile.GetIniFileString("Database", "UserID", "", Application.StartupPath + "\\ERP_Learning.ini");
string strPwd = OperatorFile.GetIniFileString("Database", "Pwd", "", Application.StartupPath + "\\ERP_Learning.ini");
string strDB = OperatorFile.GetIniFileString("Database", "Database", "", Application.StartupPath + "\\ERP_Learning.ini");
string strConn = "Server = " + strServer + "; Database = " + strDB + "; User id = " + strUserID + "; PWD =" + strPwd;
try
{
m_Conn = new SqlConnection(strConn);
m_Cmd = new SqlCommand();
m_Cmd.Connection = m_Conn;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 创建数据库连接和SqlCommand实例
/// </summary>
public DataBase()
{
string strServer = OperatorFile.GetIniFileString("DataBase", "Server", "", Environment.CurrentDirectory + "\\AmbleAppServer.ini");
//获取登录用户
string strUserID = OperatorFile.GetIniFileString("DataBase", "UserID", "", Environment.CurrentDirectory + "\\AmbleAppserver.ini");
//获取登录密码
string strPwd = OperatorFile.GetIniFileString("DataBase", "Pwd", "", Environment.CurrentDirectory + "\\AmbleAppserver.ini");
//数据库连接字符串
string strConn = "Server = " + strServer + ";Database=shenzhenerp;User id=" + strUserID + ";PWD=" + strPwd;
try
{
m_Conn = new MySqlConnection(strConn);
m_Cmd = new MySqlCommand();
m_Cmd.Connection = m_Conn;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 创建数据库连接和SqlCommand实例
/// </summary>
public DataBase()
{
string strServer = OperatorFile.GetIniFileString("DataBase", "Server", "", Application.StartupPath + "\\SMALLERP.ini");
//获取登录用户
string strUserID = OperatorFile.GetIniFileString("DataBase", "UserID", "", Application.StartupPath + "\\SMALLERP.ini");
//获取登录密码
string strPwd = OperatorFile.GetIniFileString("DataBase", "Pwd", "", Application.StartupPath + "\\SMALLERP.ini");
//数据库连接字符串
string strConn = "Server = " + strServer + ";Database=SMALLERP;User id=" + strUserID + ";PWD=" + strPwd;
try
{
m_Conn = new SqlConnection(strConn);
m_Cmd = new SqlCommand();
m_Cmd.Connection = m_Conn;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 创建数据库连接和SqlCommand实例
/// </summary>
public DataBase()
{
//获取服务器名
string strServer = OperatorFile.GetIniFileString("DataBase", "Server", "", Application.StartupPath + "\\ERP.ini");
//获取登录用户
string strUserID = OperatorFile.GetIniFileString("DataBase", "UserID", "", Application.StartupPath + "\\ERP.ini");
//获取登录密码
string strPwd = OperatorFile.GetIniFileString("DataBase", "Pwd", "", Application.StartupPath + "\\ERP.ini");
//数据库连接字符串
string strConn = "Server = " + strServer + ";Database=db_ERP;User id=" + strUserID + ";PWD=" + strPwd;
try
{
m_Conn = new SqlConnection(strConn); //产生数据库连接
m_Cmd = new SqlCommand(); //实例化SqlCommand
m_Cmd.Connection = m_Conn; //设置SqlCommand的Connection属性
}
catch (Exception e) //捕获异常
{
throw e; //抛出异常
}
}
public static string GetAccount()
{
return OperatorFile.GetIniFileString("Login", "Account", "", file);
}
public static string GetPassword()
{
return DesOp.DecryptDES(OperatorFile.GetIniFileString("Login", "Pwd", "", file));
}
public static void SetPassword(string password)
{
OperatorFile.WriteIniFileString("Login", "Pwd",DesOp.EncryptDES(password), file);
}
public static void SetAccount(string account)
{
OperatorFile.WriteIniFileString("Login", "Account", account, file);
}
