public static int GetSysParaFromIni(string sIniFileName)
{
string str = "";
short sI;
sI = MyIniFile.GetIniKeyString(sIniFileName, "Sys", "Login", ref MyStart.gszSysLogin);
if (sI < 0)
{
MyStart.gszSysLogin = "******";
}
sI = MyIniFile.GetIniKeyString(sIniFileName, "Sys", "Code", ref MyStart.gszSysCode);
if (sI < 0)
{
MyStart.gszSysCode = "37601008";
}
sI = MyIniFile.GetIniKeyString(sIniFileName, "Sys", "Pwd", ref str);
if (sI < 0)
{
MyStart.gszSysPwd = "1234567890";
}
else
{
if (str.Length == 16 && MyTools.StringIsHex(str))
{
MyStart.gszSysPwd = MyTools.HideString_To_OpenString(str, MyIniFile.mszIniKey);
MyStart.gszSysPwd = MyStart.gszSysPwd.Trim();
}
else
{
MyStart.gszSysPwd = "1234567890";
}
}
// DB
sI = MyIniFile.GetIniKeyString(sIniFileName, "Db", "IP", ref MyStart.gszDbIp);
if (sI < 0)
{
MyStart.gszDbIp = "rm-wz9767aj327o0ai0ro.mysql.rds.aliyuncs.com";
}
//MyStart.gszDbIp = "183.58.24.209";//生产IP
sI = MyIniFile.GetIniKeyString(sIniFileName, "Db", "Port", ref MyStart.gszDbPort);
if (sI < 0)
{
MyStart.gszDbPort = "3306";
}
//MyStart.gszDbPort = "8878";//生产端口
sI = MyIniFile.GetIniKeyString(sIniFileName, "Db", "Srv", ref MyStart.gszDbSrv);
if (sI < 0)
{
MyStart.gszDbSrv = "zsmkt";
}
sI = MyIniFile.GetIniKeyString(sIniFileName, "Db", "Login", ref MyStart.gszDbLogin);
if (sI < 0)
{
MyStart.gszDbLogin = "******";
}
/*sI = MyIniFile.GetIniKeyString(sIniFileName, "Db", "Pwd", ref str);
* if (sI < 0)
* {
* MyStart.gszDbPwd = "Ztb_1324";// ThisSqlAly02&&";
* }
* else
* {
* if (str.Length == 16 && MyTools.StringIsHex(str))
* {
* MyStart.gszDbPwd = MyTools.HideString_To_OpenString(str, MyIniFile.mszIniKey);
* MyStart.gszDbPwd = MyStart.gszDbPwd.Trim();
* }
* else
* MyStart.gszDbPwd = "Ztb_1324";//ThisSqlAly02&&";
* }*/
if (MyStart.gszDbIp == "139.159.212.93")
{
MyStart.gszDbPwd = "4077232";
}
else
{
MyStart.gszDbPwd = "Ztb_1324";
}
return(0);
}
private void button_Login_Click(object sender, EventArgs e)
{
//String szYear = System.DateTime.Now.Year.ToString();
//int iMonth = System.DateTime.Now.Month;
//if (System.DateTime.Now > DateTime.Parse("2018.12.31"))
//{
// MessageBox.Show("读程序参数错误，请检查!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
//}
DataSet ds = new DataSet();
string szErr = "";
string szSql = "select user_pwd,user_id,USER_APP,USER_NAME,USER_STAT from sys_users where user_login='******'";// and USER_STAT='STOP'";
int iRst = MyStart.oMyDb.ReadData(szSql, "tableA", ref ds, ref szErr);
MyStart.oMyDb.Close();
if (iRst != 0)
{
MessageBox.Show("连接数据库失败（错误原因：" + szErr + "）", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
MyIniFile.WriteLog("登录", "SQL=" + szSql + ",Err=" + szErr);
return;
}
int iNum = ds.Tables[0].Rows.Count;
if (iNum != 1)
{
MessageBox.Show("没有用户信息", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
MyIniFile.WriteLog("登录", "SQL=" + szSql + ",Err=没有用户信息");
return;
}
DataRow dr = ds.Tables[0].Rows[0];
if (dr[4].ToString().ToUpper() == "STOP")
{
MessageBox.Show("该帐号已停用，请重新登录", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
MyIniFile.WriteLog("登录", "SQL=" + szSql + ",Err=该帐号已停用，请重新登录");
textBox_Name.Focus();
return;
}
string szPwd = MyTools.HideString_To_OpenString(dr[0].ToString(), MyStart.gszPwdKey);
if (textBox_PW.Text.Trim() == szPwd.Trim())
{
MyStart.giUserID = Convert.ToInt16(dr[1]);
MyStart.gszUserPwd = textBox_PW.Text.Trim();
MyStart.gszUserApp = dr[2].ToString();
MyStart.gszUsername = dr[3].ToString();
MyStart.UserCheckIn = true;
string sIniFileName = Application.StartupPath + "\\YTB.ini";
int sI = 0;
string sErrorMessage = "";
MyStart.gszSysLogin = textBox_Name.Text;
sI = MyIniFile.SetIniKeyValue(sIniFileName, "Sys", "Login", MyStart.gszSysLogin);
if (sI < 0)
{
sErrorMessage = "保存 " + sIniFileName + "文件的操作员信息" + " 项时出错";
MessageBox.Show("操作错误：" + sErrorMessage + "。", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
else
{
MessageBox.Show("登录信息错误，请重新输入", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox_Name.Focus();
return;
}
}