public void wf_str_sys_dws2(string user_name)
{
string sql = string.Format(@"
select dw_2_3
,header_color
,header_fontcolor
,header_fontsize
,header_fontface
,header_height
,detail_fontsize
,detail_fontface
,detail_height
,detail_color1
,detail_color2
,detail_color3
,detail_fontcolor1
,detail_fontcolor2
,detail_fontcolor3
,detail_input_bcolorm
,dw_color
from mis_dw_argument WITH (NOLOCK) where user_name1 = '{0}' and window1 = '' and dataobject = ''" , user_name);
DataSet ds = DBAccess.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
global.g5_dws2.dw_2_3 = Convert.ToString(dr[0]);
global.g5_dws2.header_color = Convert.ToString(dr[1]);
global.g5_dws2.header_fontcolor = Convert.ToString(dr[2]);
global.g5_dws2.header_fontsize = Convert.ToString(dr[3]);
global.g5_dws2.header_fontface = Convert.ToString(dr[4]);
global.g5_dws2.header_height = Convert.ToString(dr[5]);
global.g5_dws2.detail_fontsize = Convert.ToString(dr[6]);
global.g5_dws2.detail_fontface = Convert.ToString(dr[7]);
global.g5_dws2.detail_height = Convert.ToString(dr[8]);
global.g5_dws2.detail_color1 = Convert.ToString(dr[9]);
global.g5_dws2.detail_color2 = Convert.ToString(dr[10]);
global.g5_dws2.detail_color3 = Convert.ToString(dr[11]);
global.g5_dws2.detail_fontcolor1 = Convert.ToString(dr[12]);
global.g5_dws2.detail_fontcolor2 = Convert.ToString(dr[13]);
global.g5_dws2.detail_fontcolor3 = Convert.ToString(dr[14]);
global.g5_dws2.detail_input_bcolorm = Convert.ToString(dr[15]);
global.g5_dws2.dw_color = Convert.ToString(dr[16]);
}
global.gu_dw1.f_constr_color0_get(ref global.g5_dws2);
if (global.g5_dws2.detail_color1 == null || global.g5_dws2.detail_color1 == "")
{
global.g5_dws2 = global.g5_dws1;
}
}
private void Login()
{
if (string.IsNullOrEmpty(txtUser.Text))
{
MessageBox.Show("请输入用户名！", "提示");
txtUser.Focus();
return;
}
if (string.IsNullOrEmpty(txtPassword.Text))
{
MessageBox.Show("请输入密码！", "提示");
txtPassword.Focus();
return;
}
if (txtUser.Text.Contains(" "))
{
MessageBox.Show("用户名中输入的有空格！", "提示");
txtUser.Focus();
return;
}
if (txtPassword.Text.Contains(" "))
{
MessageBox.Show("密码中输入的有空格！", "提示");
txtPassword.Focus();
return;
}
if (global.gu_dw1.f_sql_filter(txtUser.Text) == 0)
{
MessageBox.Show("用户名中输入的有不合法的字符！", "提示");
txtUser.Focus();
return;
}
if (global.gu_dw1.f_sql_filter(txtPassword.Text) == 0)
{
MessageBox.Show("密码中输入的有不合法的字符！", "提示");
txtPassword.Focus();
return;
}
if (txtPassword.Text == "88888888")
{
MessageBox.Show("请修改密码，88888888 不能登录！", "提示");
txtPassword.Focus();
return;
}
// 初始化变量
string[] ls_sle;
string ls_password, ls_logid;
ls_logid = "";
ls_password = "";
ls_logid = txtUser.Text.ToLower();
ls_password = txtPassword.Text;
//----------------------------------修改此段程序-----------------//
string ls_return = string.Empty, ls_truename, ls_msg = string.Empty, ls_ip_hostname;
long ll_pass_ts = 0, ll_i = 0;
long ll_bmcj_count;
long return_value = 0;
bool lb_sql;
lb_sql = false;
List <IDbDataParameter> outparas = new List <IDbDataParameter>();
SqlParameter para = new SqlParameter("@ls_return", SqlDbType.VarChar, 2000);
para.Direction = ParameterDirection.Output;
outparas.Add(para);
para = new SqlParameter("@return_value", SqlDbType.Int);
para.Direction = ParameterDirection.ReturnValue;
outparas.Add(para);
List <IDbDataParameter> paras = new List <IDbDataParameter>();
para = new SqlParameter("@leibie", 52);
paras.Add(para);
para = new SqlParameter("@user_name1", ls_logid);
paras.Add(para);
para = new SqlParameter("@page_name", "");
paras.Add(para);
para = new SqlParameter("@pass", ls_password);
paras.Add(para);
para = new SqlParameter("@pass_new", "shlx9");
paras.Add(para);
para = new SqlParameter("@ip", global.g5_sys.ip);
paras.Add(para);
try
{
Dictionary <string, string> dict = DBAccess.ExecSP("login_gnqx_pass", paras, ref outparas);
ls_return = dict["@ls_return"];
return_value = Convert.ToInt64(dict["@return_value"]);
lb_sql = true;
}
catch (Exception e)
{
lb_sql = false;
}
if (!lb_sql)
{
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
MessageBox.Show("返回值：" + return_value, "提示!");
return;
}
switch (ls_return)
{
case "pass_time_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//global.w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，同一IP地址在1分钟内不能登录两次！", "登录不成功提示1!");
return;
case "pass_date_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，您的密码已过期，请修改密码！", "登录不成功提示2!");
return;
case "pass_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，密码或用户名有误，密码区分大小写！", "登录不成功提示3!");
return;
case "leixing_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，计算机类型不正确，请把类型更改为“台式机”或“笔记本”！", "登录不成功提示4!");
return;
case "admi_user_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，管理员设置不正确或计算机异常，请联系信息部！", "登录不成功提示5!");
return;
case "wan_false":
global.g5_sys.username = "";
global.g5_sys.truename = "";
global.g5_shlx.chengben = false;
//w_pub_init.st_truename.text="使用者："
MessageBox.Show("登录不成功，您没有开通外网访问权限，请联系信息部！", "登录不成功提示6!");
return;
default:
if (ls_return.Substring(0, 2) == "p_" || ls_return.Substring(0, 2) == "p!")
{
global.g5_sys.username = ls_logid;
global.gu_dw1.wf_str_sys_dws2(global.g5_sys.username);
if (ls_return.Substring(0, 2) == "p_")
{
ls_truename = ls_return.Substring(ls_return.Length - 2, 2);
ll_pass_ts = Convert.ToInt64(ls_truename.Substring(0, ls_truename.IndexOf("!")));
global.g5_sys.truename = ls_truename.Substring(ls_truename.IndexOf("!") + 1);
}
else
{
global.g5_sys.truename = ls_return.Substring(ls_return.Length - 2, 2);
}
if (global.g5_sys.truename == "管理员")
{
global.g5_sys.truename = "李华锋";
}
string sql = @"
select bumen, chejian from login_user where user_name1 = :g5_sys.username ;" ;
DataSet ds = DBAccess.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
global.g5_sys.bumen = Convert.ToString(dr[0]);
global.g5_sys.chejian = Convert.ToString(dr[1]);
}
//w_pub_init.st_truename.text="使用者："+g5_sys.truename+" "+g5_sys.username
//w_pub_init.st_chejian.text="车间：" + g5_sys.bumen + " " + g5_sys.chejian
if (global.g5_sys.bumen != global.g5_shlx.com_bumen || global.g5_sys.chejian != global.g5_shlx.com_chejian)
{
sql = string.Format(@"
insert into com_user_bmcj (computer,ip,mac,bumen_com,chejian_com,
user_name1,true_name,bumen,chejian,login_sj)
values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',getdate()) ;" , global.g5_sys.hostname,
global.g5_sys.ip,
global.g5_sys.mac,
global.g5_shlx.com_bumen,
global.g5_shlx.com_chejian,
global.g5_sys.username,
global.g5_sys.truename,
global.g5_sys.bumen,
global.g5_sys.chejian);
DBAccess.ExecuteSql(sql);
; if (global.g5_shlx.com_bumen == "会议室" && global.g5_shlx.com_chejian == "会议室")
{
ll_bmcj_count = 0;
}
else if (global.g5_sys.hostname == "三环乐喜1" || global.g5_sys.hostname == "三环乐喜2")
{
ll_bmcj_count = 0;
}
else
{
ll_bmcj_count = 0;
sql = @"
select count(com_user_id) from com_user_bmcj
where login_sj >= getdate() - 30 and ip = :g5_sys.ip and user_name1 = :g5_sys.username ;" ;
ds = DBAccess.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
ll_bmcj_count = Convert.ToInt64(dr[0]);
}
ls_msg = "计算机 " + global.g5_sys.hostname + " 所在部门车间为 " + global.g5_shlx.com_bumen + "/" + global.g5_shlx.com_chejian;
ls_msg += "\r\n用户 " + global.g5_sys.truename + "/" + global.g5_sys.username + " 所在部门车间为 " + global.g5_sys.bumen + "/" + global.g5_sys.chejian;
if (ll_bmcj_count >= 30)
{
ls_msg += "\r\n两者不一致，您将不能使用shlx9，请找您们领导在shlx9中报修！";
MessageBox.Show(ls_msg, "部门车间不一致提示");
}
else if (ll_bmcj_count >= 20)
{
ls_msg += "\r\n两者不一致，请在shlx9中报修，否则将会导致您不能使用shlx9！";
for (ll_i = 19; ll_i < ll_bmcj_count; ll_i++)
{
MessageBox.Show((ll_bmcj_count - ll_i + 1).ToString() + "\r\n" + ls_msg, "部门车间不一致提示" + (ll_bmcj_count - ll_i + 1).ToString());
}
}
else if (ll_bmcj_count >= 8)
{
ls_msg += "\r\n两者不一致，如果是临时使用请不予处理，否则请与信息部联系！";
MessageBox.Show(ls_msg, "部门车间不一致提示");
}
}
}
}
if (ls_return.Substring(0, 2) == "p!")
{
if (ll_pass_ts >= 20) //20天提醒
{
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！\r\n1.建议同时修改windows的登录密码！\r\n2.建议同时修改邮箱密码！", "密码快过期提示");
}
else if (11 - ll_pass_ts <= 1) // 10天提醒
{
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！1\r\n1.建议同时修改windows的登录密码！\r\n2.建议同时修改邮箱密码！", "密码快过期提示1");
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！2\r\n1.建议同时修改windows的登录密码！\r\n2.建议同时修改邮箱密码！", "密码快过期提示2");
}
else
{
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！4\r\n1.建议同时修改windows的登录密码！~r~n2.建议同时修改邮箱密码！", "密码快过期提示4");
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！5\r\n1.建议同时修改windows的登录密码！~r~n2.建议同时修改邮箱密码！", "密码快过期提示5");
MessageBox.Show("密码快过期提示，还有 " + ll_pass_ts + " 天！6\r\n1.建议同时修改windows的登录密码！~r~n2.建议同时修改邮箱密码！", "密码快过期提示6");
}
}
if (global.gu_pub1.gf_gnqx_1(global.g5_sys.username, "成本-详细成本-0浏览") == 1)
{
global.g5_shlx.chengben = true;
}
// 记录登录的用户名
//gu_pub1.f_txt_save(g5_sys.app_path,"pb9_save_ini","w_dljm","sle_1","username",g5_sys.winusername,g5_sys.username)
//wf_quanxian_user()
//if wf_quanxian_page() then open(w_xxzx_quanxian_page)
// choose case g5_sys.chejian
// case "销售部"
// // 不强行添加快捷方式
// case else
// wf_desktop_lnk()
// end choose
// close(w_dljm);
// else
// g5_sys.username=""
// g5_sys.truename=""
// g5_shlx.chengben = false
// messagebox("登录不成功提示7!",ls_return)
// return
// end if
//end choose
break;
}
this.Hide();
frmMain main = new frmMain();
main.Show();
}
public void ue_db()
{
string pwd = fe_wf("dGF6#$78,", wf_encode(), true);
pwd = fe_wf(pwd, wf_encode(), false);
string ls_password = "******";
//string ls_pswkey = "lSpUqFGiRYoVKlSoUaJFihoyddq1a+XNjBYxb8+aPXn9+vjy4rZr5b5+Dg4UK2nFP";
string ls_serverip = string.Empty;
string ls_database = "shlx";
string ls_server = "192.168.1.5";
string ls_loginid = string.Empty;
//ls_password = fe_wf(ls_password, wf_encode(), false);
if (ls_server == "127.0.0.1" || ls_server == "192.168.1.36")
{
ls_serverip = "127.0.0.1";
ls_loginid = "sa";
}
else
{
ls_serverip = global.g5_sys.ip_db;
ls_loginid = "mis_pub";
ls_password = "******";
}
if (ls_loginid != "sa")
{
ls_password = global.gu_pub1.fe_wf(ls_password, wf_encode(), false);
global.g5_sys.connStr = string.Format(ConfigurationManager.ConnectionStrings[1].ConnectionString, ls_serverip, ls_database, ls_loginid, ls_password);
//global. gu_pub1.f_sql_connect(global.g5_sys.hostname,global.g5_sys.app_name,global.g5_sys.ip,ls_database,ls_server,ls_loginid,ls_password,ls_serverip,sqlca)
// 连接数据库成功
// 获取版本号和服务器时间 开始
string sql = @"
SELECT top 1 ver, modi_date, getdate()
FROM mis_ver with (nolock)
where modi_date >= dateadd(day, -500, getdate())
order by ver desc ;";
DataSet ds = DBAccess.Query(sql, "mis_ver");
if (ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
global.g5_sys.version_new = Convert.ToDecimal(dr[0]);
global.g5_sys.version_date = Convert.ToDateTime(dr[1]);
global.gu_pub1.idt_getdate = Convert.ToDateTime(dr[2]);
global.gu_pub1.il_getdate = cpu();
}
else
{
sql = @"
insert mis_ver (ver,modi_date) values (0, getdate()) ;
SELECT top 1 getdate() FROM mis_ver with (nolock) ;";
ds = DBAccess.Query(sql);
if (ds.Tables[0].Rows.Count > 0)
{
global.gu_pub1.idt_getdate = Convert.ToDateTime(ds.Tables[0].Rows[0][0]);
global.gu_pub1.il_getdate = cpu();
global.g5_sys.version_new = 0;
}
else
{
MessageBox.Show("数据库操作发生错误，系统版本号和服务器时间获取失败！", "提示");
}
}
}
if (ls_loginid != "sa")
{
if (global.g5_sys.is_debug)
{
//正式连接数据库
global.gu_dw1.fe_encode2(ref ls_loginid, ref ls_password, global.g5_sys.app_name, global.g5_sys.winusername, global.g5_sys.ip, global.g5_sys.mac, global.g5_sys.hostname);
global.g5_sys.connStr = string.Format(ConfigurationManager.ConnectionStrings[1].ConnectionString, ls_serverip, ls_database, ls_loginid, ls_password);
//global. gu_pub1.f_sql_connect(g5_sys.hostname,g5_sys.app_name,g5_sys.ip,ls_database,ls_server,ls_loginid,ls_password,ls_serverip,sqlca)
string sql = "select * from login_user";
DataSet ds = DBAccess.Query(sql);
}
else
{
string ls_ver, ls_comp_user;
//// 检验是否升级
if (global.g5_sys.version_now > global.g5_sys.version_new)
{
global.gu_dw1.fe_encode2(ref ls_loginid, ref ls_password, global.g5_sys.app_name, global.g5_sys.winusername, global.g5_sys.ip, global.g5_sys.mac, global.g5_sys.hostname);
global.g5_sys.connStr = string.Format(ConfigurationManager.ConnectionStrings[1].ConnectionString, ls_serverip, ls_database, ls_loginid, ls_password);
//正式连接数据库
// global. gu_dw1.fe_encode2(ref ls_loginid,ref ls_password,global.g5_sys.app_name,global.g5_sys.winusername,global.g5_sys.ip,global.g5_sys.mac,global.g5_sys.hostname);
// global. gu_pub1.f_sql_connect(g5_sys.hostname,g5_sys.app_name,g5_sys.ip,ls_database,ls_server,ls_loginid,ls_password,ls_serverip,sqlca)
// if al_pid_app >= 1 then Halt Close
// ls_ver = string(g5_sys.version_now,"0.000000000000")
// update mis_ver set mess = :ls_ver, modi_date = getdate() where ver = 0 ;
// if not (sqlca.sqlcode = 0 and sqlca.sqlnrows = 1) then
// insert mis_ver (ver,modi_date,mess) values (0, getdate(), :ls_ver) ;
// end if
// ls_comp_user = g5_sys.hostname + g5_sys.winusername + gu_pub1.f_disk_getserialnumber()
// update mis_ip_ver set ver = :g5_sys.version_now , lrsj = getdate() where ip = :ls_comp_user ;
// if not (sqlca.sqlcode = 0 and sqlca.sqlnrows = 1) then
// insert mis_ip_ver (ip,ver,lrsj) values (:ls_comp_user,:g5_sys.version_now,getdate()) ;
// end if
// delete mis_ip_ver where lrsj <= getdate() - 400 ;
// run(g5_sys.app_path + "\mis_updt.exe " + g5_sys.app_name + " " + string(gu_pub1.f_sys_process_curpid()) )
// halt close
//elseif g5_sys.version_now < g5_sys.version_new then
// if al_pid_app >= 1 then Halt Close
// ls_comp_user = g5_sys.hostname + g5_sys.winusername + gu_pub1.f_disk_getserialnumber()
// update mis_ip_ver set ver = :g5_sys.version_now , lrsj = getdate() where ip = :ls_comp_user ;
// if not (sqlca.sqlcode = 0 and sqlca.sqlnrows = 1) then
// insert mis_ip_ver (ip,ver,lrsj) values (:ls_comp_user,:g5_sys.version_now,getdate()) ;
// end if
// run(g5_sys.app_path + "\mis_updt.exe " + g5_sys.app_name + " " + string(gu_pub1.f_sys_process_curpid()) )
// halt close
//else
// //正式连接数据库
// gu_dw1.fe_encode2(ls_loginid,ls_password,g5_sys.app_name,g5_sys.winusername,g5_sys.ip,g5_sys.mac,g5_sys.hostname)
// gu_pub1.f_sql_connect(g5_sys.hostname,g5_sys.app_name,g5_sys.ip,ls_database,ls_server,ls_loginid,ls_password,ls_serverip,sqlca)
}
}
}
}