private void frmCompany_Load(object sender, EventArgs e) { #region 权限控制 tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118"; string sErr = ""; StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'"); if (UserInformation.UserName != "Admin5118") { sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')"); } DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } if (UserInformation.UserName != "Admin5118") { CheckRights(tlbMain, dsX.Tables["UserRights"]); } #endregion strConnFix = ""; if (UserInformation.UType != UserType.utSupervisor) { strConnFix = " where cComptId='" + UserInformation.UnitId + "'"; } else { sbConndition.Remove(0, sbConndition.Length); } OpenMainDataSet(strConnFix); }
private void FrmStockInfo_Load(object sender, EventArgs e) { #region 权限控制 tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118"; string sErr = ""; StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'"); if (UserInformation.UserName != "Admin5118") { sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')"); } DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } CheckRights(tlbMain, dsX.Tables["UserRights"]); #endregion LoadCommboxItemByValue(); LoadStockList(""); LoadCheckType(""); dtp_To.Value = DateTime.Now; dtp_From.Value = DateTime.Now.AddDays(-30); BandDataSet("", this.dataGridView_Main); }
private void frmCuSuAvailability_Load(object sender, EventArgs e) { #region 权限控制 tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118"; string sErr = ""; StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'"); if (UserInformation.UserName != "Admin5118") { sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')"); } DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } if (UserInformation.UserName != "Admin5118") { CheckRights(tlbMain, dsX.Tables["UserRights"]); } #endregion LoadItemToComb(); DisplayCSInfo(_CSId.Trim()); OpenMainDataSet(); }
private void frmSupplier_Load(object sender, EventArgs e) { string sErr = ""; #region 权限控制 tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118"; StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'"); if (UserInformation.UserName != "Admin5118") { sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')"); } DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } if (UserInformation.UserName != "Admin5118") { CheckRights(tlbMain, dsX.Tables["UserRights"]); } #endregion //自动更新客户和供应商的可用性 string sX = DBFuns.sp_UpdateCuSupplyerUseful(AppInformation.SvrSocket, out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show("自动更新客户及供应商合法性时出错:" + sErr); } else { if (sX.Trim() != "0") { MessageBox.Show("新增了" + sX + " 个 不可用客户或供应商(包括生产商)"); } } OpenMainDataSet(); }