private void btnLogin_Click(object sender, EventArgs e) { try { DateTime d1 = dtmLogin.DateTime; if (d1 < Convert.ToDateTime("2014-1-1")) { DialogResult d = MessageBox.Show("新年度帐已经创立,请登录新年度操作", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); if (d == DialogResult.Yes) { return; } } 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); } } WriteConfig(); try { FrameBaseFunction.ClsBaseDataInfo.sUid = txtUID.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sLogDate = dtmLogin.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sDataBaseName = txtDataBase.Text; if (bU8Improt) { FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName = "UFDATA_" + lookUpAcc.EditValue.ToString().Trim() + "_2015"; FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseText = lookUpAcc.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sConnString2 = FrameBaseFunction.ClsBaseDataInfo.sConnString.Replace(FrameBaseFunction.ClsBaseDataInfo.sDataBaseName, FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName); } string sSQL = "select * from dbo._UserInfo where vchrUid = '" + txtUID.Text.Trim() + "' "; DataTable dtUser = clsSQLCommond.ExecQuery(sSQL); FrameBaseFunction.ClsBaseDataInfo.sUserName = dtUser.Rows[0]["vchrName"].ToString().Trim(); FrameBaseFunction.ClsBaseDataInfo.sDepCode = dtUser.Rows[0]["cDepCode"].ToString().Trim(); if (bU8Improt) { sSQL = "select count(*) from Master.dbo.sysdatabases where name='" + FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName + "'"; int iCou = Convert.ToInt32(clsSQLCommond.ExecGetScalar(sSQL)); if (iCou == 0) { MessageBox.Show("年度帐不存在,日期请选择" + dtmLogin.DateTime.AddYears(-1).ToString("yyyy").Trim() + "-12-31"); return; } } } catch { } string s提示 = ""; #region 公告 string s_SQL = @" select count(1) as iCou from UFDLImport..杜乐公告 a inner join UFDLImport..杜乐公告明细 b on a.guid = b.guid where 1=1 and b.供应商编码 in (111111) and isnull(a.发布人,'') <> '' and isnull(b.阅读人,'') = '' "; s_SQL = s_SQL.Replace("111111", "select distinct vendcode from UFDLImport.._vendUid where uid = '222222' and accid = '200'"); s_SQL = s_SQL.Replace("222222", FrameBaseFunction.ClsBaseDataInfo.sUid); int iCount = 0; try { iCount = Convert.ToInt32(clsSQLCommond.ExecGetScalar(s_SQL)); } catch { iCount = 9999; } if (iCount == 9999) { MessageBox.Show("加载公告失败"); } else if (iCount > 0) { s提示 = s提示 + "存在 " + iCount.ToString().Trim() + " 条公告未看\n"; } #endregion #region 8D报告 try { s_SQL = @" select cast(0 as bit) as 选择 ,* from DolleDatabase.dbo._Bai_到货不良品处理流程 a left join UFDLImport.._8D报告 b on a.id = b.idhead where 是否提交8D改进报告 = '是' and 1=1 and a.厂商编码 in (111111) and isnull(b.状态,0) <> 1 Order by id "; s_SQL = s_SQL.Replace("111111", "select distinct vendcode from UFDLImport.._vendUid where uid = '222222' and accid = '200'"); s_SQL = s_SQL.Replace("222222", FrameBaseFunction.ClsBaseDataInfo.sUid); DataTable dt8D = clsSQLCommond.ExecQuery(s_SQL); if (dt8D != null && dt8D.Rows.Count > 0) { s提示 = s提示 + "存在 " + dt8D.Rows.Count.ToString().Trim() + " 条8D改进报告未处理完成\n"; } } catch { } #endregion if (s提示.Trim() != "") { MessageBox.Show(s提示); } DialogResult = DialogResult.OK; } catch (Exception ee) { MessageBox.Show("登陆失败! " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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); } } WriteConfig(); try { FrameBaseFunction.ClsBaseDataInfo.sUid = txtUID.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sLogDate = dtmLogin.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sDataBaseName = txtDataBase.Text; if (bU8Improt) { FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName = "UFDATA_" + lookUpAcc.EditValue.ToString().Trim() + "_" + dtmLogin.DateTime.ToString("yyyy").Trim(); FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseText = lookUpAcc.Text.Trim(); FrameBaseFunction.ClsBaseDataInfo.sConnString2 = FrameBaseFunction.ClsBaseDataInfo.sConnString.Replace(FrameBaseFunction.ClsBaseDataInfo.sDataBaseName, FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName); } string sSQL = "select vchrName from dbo._UserInfo where vchrUid = '" + txtUID.Text.Trim() + "' "; FrameBaseFunction.ClsBaseDataInfo.sUserName = clsSQLCommond.ExecGetScalar(sSQL).ToString().Trim(); if (bU8Improt) { sSQL = "select count(*) from Master.dbo.sysdatabases where name='" + FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName + "'"; int iCou = Convert.ToInt32(clsSQLCommond.ExecGetScalar(sSQL)); 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); } }