private void btnImprot()
{
string sSQL = "insert into dbo._UserInfo(vchrUid,vchrName,vchrPwd,vchrRemark,dtmCreate,dtmClose)select cUser_Id,cUser_Name,'999','','1900-01-01','2099-12-31' from UFSystem..UA_User where cUser_Id not in (select vchrUid from _UserInfo)";
clsSQL.ExecSql(sSQL);
GetGridView();
MessageBox.Show("同步U8账号成功，请进入系统设置权限！");
}
private bool Login(out string sEr)
{
bool b = false;
sEr = "";
try
{
string sSQL = "";
if (txtUID.Text.ToLower().Trim() != "admin" || txtUID.Text.ToLower().Trim() != "system")
{
sSQL = "select vchrUid, vchrPwd, vchrRemark, tstamp, dtmCreate, dtmClose from _UserInfo " +
"where vchrUid = '" + txtUID.Text.Trim() + "' and vchrPwd = '" + clsDES.Encrypt(txtPWD.Text.Trim()) + "'";
}
else
{
sSQL = "select vchrUid, vchrPwd, vchrRemark, tstamp, dtmCreate, dtmClose from _UserInfo " +
"where vchrUid = '" + txtUID.Text.Trim() + "' and (vchrPwd = '" + (txtPWD.Text.Trim()) + "' or vchrPwd = '" + clsDES.Encrypt(txtPWD.Text.Trim()) + "')";
}
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
int iCou = dt.Rows.Count;
if (iCou == 1)
{
if (DateTime.Parse(Convert.ToDateTime(dt.Rows[0]["dtmClose"]).ToString("yyyy-MM-dd")) < DateTime.Today.AddDays(+1))
{
sEr = "帐号已被停用！";
}
else
{
sSQL = "insert into Define1(S1,s6,SysCreateDate)values('" + txtUID.Text.Trim() + "','系统登录',getdate())";
clsSQLCommond.ExecSql(sSQL);
b = true;
}
}
else
{
sEr = "帐号或者密码错误！";
}
}
catch (Exception ee)
{
sEr = ee.Message;
b = false;
}
return(b);
}
public bool BuckUpDataBase(string sPathInfo)
{
bool b = false;
try
{
string sSQL = "BACKUP DATABASE [" + 系统服务.ClsBaseDataInfo.sDataBaseName + "] TO DISK = N'" + sPathInfo + "' " +
"WITH NOFORMAT, NOINIT, NAME = N'TH_Test-完整 数据库 备份', " +
"SKIP, NOREWIND, NOUNLOAD, STATS = 10";
clsSQLCommond.ExecSql(sSQL);
b = true;
}
catch
{
throw new Exception("备份数据库操作失败！");
}
return(b);
}
private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
string sInfo = this.Name + "|" + e.ClickedItem.Name;
if (e.ClickedItem.Name.ToLower().Trim() == "exit")
{
//if (MessageBox.Show("是否关闭当前窗体？\n是：关闭\n否：取消", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
//{
sSQL = "insert into Define1(S1,s2,S3,S4,S5,S6,SysCreateDate)values('" + 系统服务.ClsBaseDataInfo.sUid + "','" + 系统服务.ClsBaseDataInfo.sUserName + "','" + this.Name + "','" + this.Text + "','" + e.ClickedItem.Name.Trim() + "','" + e.ClickedItem.Text.Trim() + "',getdate())";
clsSQLCommond.ExecSql(sSQL);
this.Close();
// return;
//}
}
clsSQLCommond = 系统服务.ClsDataBaseFactory.Instance();
string sSQL2 = @"select count(*) from dbo._UserRoleInfo where vchrRoleID = 'administrator' and vchrUserID = '" + sUid + "'";
bool b = false;
if (sUid == "admin" || sUid == "system")
{
b = true;
}
if (Convert.ToInt32(clsSQLCommond.ExecGetScalar(sSQL2)) != 0)
{
b = true;
}
if (!b)
{
if (!sInfo.ToLower().EndsWith("exit") && !hasRight(sInfo, sUid))
{
e.ClickedItem.Enabled = false;
MessageBox.Show("权限不足！");
return;
}
}
sSQL = "insert into Define1(S1,s2,S3,S4,S5,S6,SysCreateDate)values('" + 系统服务.ClsBaseDataInfo.sUid + "','" + 系统服务.ClsBaseDataInfo.sUserName + "','" + this.Name + "','" + this.Text + "','" + e.ClickedItem.Name.Trim() + "','" + e.ClickedItem.Text.Trim() + "',getdate())";
clsSQLCommond.ExecSql(sSQL);
BtnClick(e.ClickedItem.Name, e.ClickedItem.Text);
if (dtBtnInfo != null && dtBtnInfo.Rows.Count > 0)
{
for (int i = 0; i < dtBtnInfo.Rows.Count; i++)
{
if (dtBtnInfo.Rows[i]["vchrBtnID"].ToString().Trim().ToLower() == e.ClickedItem.Name.ToLower().Trim())
{
if (Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 0)
{
btnEnable = true;
SetBtnEnable(btnEnable);
}
else if (Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 1 || Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 2)
{
SetBtnEnable(btnEnable);
}
else if (Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 3)
{
SetBtnEnable(true);
}
else if (Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 4)
{
SetBtnEnable(false);
}
else if (Convert.ToInt32(dtBtnInfo.Rows[i]["bEnable"]) == 5)
{
//SetBtnEnable(false);
}
}
}
}
Cursor.Current = Cursors.Default;
}
catch (Exception ee)
{
MsgBox("操作失败", ee.Message);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (bU8Improt && lookUpAcc.Text.Trim() == string.Empty)
{
MessageBox.Show("请选择帐套", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
lookUpAcc.Focus();
return;
}
if (!chkBaseInfo())
{
MessageBox.Show("请检查信息是否完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string sErrInfo;
if (!Login(out sErrInfo))
{
MessageBox.Show("登陆失败！\n\n原因:\n " + sErrInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUID.Focus();
return;
}
if (chkPWD.Checked)
{
string sPWD = "";
FrmChangePWD frmChgPWD = new FrmChangePWD();
frmChgPWD.ShowDialog();
if (frmChgPWD.DialogResult == DialogResult.OK)
{
sPWD = frmChgPWD.sNewPWD;
string sSQL = "update _UserInfo set vchrPwd = '" + clsDES.Encrypt(sPWD) + "' where vchrUid = '" + txtUID.Text.Trim() + "'";
clsSQLCommond.ExecSql(sSQL);
MessageBox.Show("修改密码成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
//string sPWD = "";
//FrmChangePWD frmChgPWD = new FrmChangePWD();
//frmChgPWD.ShowDialog();
//if (frmChgPWD.DialogResult == DialogResult.OK)
//{
// sPWD = frmChgPWD.sNewPWD;
// string sSQL = "update _UserInfo set vchrPwd = '" + clsDES.Encrypt(sPWD) + "' where vchrUid = '" + txtUID.Text.Trim() + "'";
// clsSQLCommond.ExecSql(sSQL);
// //string s = clsWeb.saveUserInfoPwd(txtUID.Text.Trim(), clsDES.Encrypt(sPWD));
// if (s != "")
// {
// throw new Exception(s);
// }
// MessageBox.Show("修改密码成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//}
}
WriteConfig();
try
{
系统服务.ClsBaseDataInfo.sUid = txtUID.Text.Trim();
系统服务.ClsBaseDataInfo.sLogDate = dtmLogin.Text.Trim();
系统服务.ClsBaseDataInfo.sDataBaseName = txtDataBase.Text;
if (bU8Improt)
{
系统服务.ClsBaseDataInfo.sUFDataBaseName = "UFDATA_" + lookUpAcc.EditValue.ToString().Trim() + "_" + dtmLogin.DateTime.ToString("yyyy").Trim();
系统服务.ClsBaseDataInfo.sUFDataBaseText = lookUpAcc.Text.Trim();
系统服务.ClsBaseDataInfo.sConnString2 = 系统服务.ClsBaseDataInfo.sConnString.Replace(系统服务.ClsBaseDataInfo.sDataBaseName, 系统服务.ClsBaseDataInfo.sUFDataBaseName);
}
string sSQL = "select vchrName from dbo._UserInfo where vchrUid = '" + txtUID.Text.Trim() + "' ";
系统服务.ClsBaseDataInfo.sUserName = clsSQLCommond.ExecGetScalar(sSQL).ToString().Trim();
//系统服务.ClsBaseDataInfo.sUserName = clsWeb.svchrName(txtUID.Text.Trim());
if (bU8Improt)
{
sSQL = "select count(*) from Master.dbo.sysdatabases where name='" + 系统服务.ClsBaseDataInfo.sUFDataBaseName + "'";
int iCou = Convert.ToInt32(clsSQLCommond.ExecGetScalar(sSQL));
//int iCou = 系统服务.规格化.ReturnInt(clsWeb.sbU8Improt(系统服务.ClsBaseDataInfo.sUFDataBaseName));
if (iCou == 0)
{
MessageBox.Show("年度帐不存在，日期请选择" + dtmLogin.DateTime.AddYears(-1).ToString("yyyy").Trim() + "-12-31");
return;
}
}
}
catch
{ }
DialogResult = DialogResult.OK;
}
catch (Exception ee)
{
MessageBox.Show("登陆失败！ " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
clsSQLCommond = 系统服务.ClsDataBaseFactory.Instance();
//if (lookUpAcc.Text.Trim() == string.Empty)
//{
// MessageBox.Show("请选择帐套", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// lookUpAcc.Focus();
// return;
//}
if (!chkBaseInfo())
{
MessageBox.Show("请检查信息是否完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string sErrInfo;
if (!Login(out sErrInfo))
{
MessageBox.Show("登陆失败！\n\n原因:\n " + sErrInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUID.Focus();
return;
}
if (chkPWD.Checked)
{
string sPWD = "";
FrmChangePWD frmChgPWD = new FrmChangePWD();
frmChgPWD.ShowDialog();
if (frmChgPWD.DialogResult == DialogResult.OK)
{
sPWD = frmChgPWD.sNewPWD;
string sSQL = "update _UserInfo set vchrPwd = '" + clsDES.Encrypt(sPWD) + "' where vchrUid = '" + txtUID.Text.Trim() + "'";
clsSQLCommond.ExecSql(sSQL);
MessageBox.Show("修改密码成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
WriteConfig();
try
{
系统服务.ClsBaseDataInfo.sUid = txtUID.Text.Trim();
系统服务.ClsBaseDataInfo.sLogDate = dtmLogin.Text.Trim();
系统服务.ClsBaseDataInfo.sDataBaseName = txtDataBase.Text;
string sSQL = "select vchrName from dbo._UserInfo where vchrUid = '" + txtUID.Text.Trim() + "' ";
系统服务.ClsBaseDataInfo.sUserName = clsSQLCommond.ExecGetScalar(sSQL).ToString().Trim();
}
catch
{ }
DialogResult = DialogResult.OK;
}
catch (Exception ee)
{
MessageBox.Show("登陆失败！ " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}