/// <summary> /// 查询用户的窗体权限 /// </summary> public bool QueryUserFormPower(string formNameStr) { if (SystemInfo.user.AutoId == 1) { return(true); } string sqlStr = string.Format("select Count(*) from BS_RoleMenu where RoleNo = '{0}' and MenuName in (select MenuName from BS_Menu where FormName = '{1}')", SystemInfo.user.RoleNo, formNameStr); int count = DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr)); if (count > 0) { return(true); } else { sqlStr = string.Format("select MenuText from BS_Menu where FormName = '{0}'", formNameStr); string menuText = DataTypeConvert.GetString(BaseSQL.GetSingle(sqlStr)); if (menuText != "") { MessageHandler.ShowMessageBox(string.Format("您没有查看[{0}]的权限,如果需要查看请联系系统管理员。", menuText)); } return(false); } }
/// <summary> /// 判断站号是否包含在项目号中 /// </summary> /// <param name="projectNoStr">项目号</param> /// <param name="stnNoStr">站号</param> public bool StnNoIsContainProjectNo(string projectNoStr, string stnNoStr) { string sqlStr = string.Format("select Count(*) from BS_StnList where ProjectNo='{0}' and StnNo='{1}'", projectNoStr, stnNoStr); int count = DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr)); return(count == 0 ? false : true); }
/// <summary> /// 查询该登陆ID的用户数量 /// </summary> public int QueryUserInfoCount(string loginIdStr) { string sqlStr = string.Format("select Count(*) from BS_UserInfo where LoginId = '{0}'", loginIdStr); int count = DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr)); return(count); }
/// <summary> /// 查询用户按钮的权限 /// </summary> public static bool QueryUserButtonPower(string formNameStr, string formTextStr, object sender, bool isMessage) { if (sender == null || !SystemInfo.IsCheckUserButtonPower) { return(true); } string buttonNameStr = ""; string buttonTextStr = ""; switch (sender.GetType().ToString()) { case "DevExpress.XtraEditors.SimpleButton": SimpleButton sbtn = (SimpleButton)sender; buttonNameStr = sbtn.Name; buttonTextStr = sbtn.Text; break; case "System.Windows.Forms.Button": Button btn = (Button)sender; buttonNameStr = btn.Name; buttonTextStr = btn.Text; break; default: return(true); } string sqlStr = string.Format("select Count(*) from BS_MenuButton where MenuName in (select MenuName from BS_Menu where FormName = '{0}') and ButtonName = '{1}' and AutoId in (select MenuButtonId from BS_UserMenuButton where UserNo = {2})", formNameStr, buttonNameStr, SystemInfo.user.AutoId); int count = DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr)); if (count > 0) { return(true); } else { sqlStr = string.Format("select Count(*) from BS_Menu where FormName = '{0}'", formNameStr); if (DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr)) == 0) { return(true); } else { if (isMessage) { MessageHandler.ShowMessageBox(string.Format("您没有操作模块【{0}】中按钮【{1}】的操作权限,请联系相关的负责管理员。", formTextStr, buttonTextStr)); } return(false); } } }
//判断用Sql查询的数据是否存在,true表示存在,False表示不存在 public static bool Exists(string strSql) { object obj = BaseSQL.GetSingle(strSql); int cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = 0; } else { cmdresult = int.Parse(obj.ToString()); } if (cmdresult == 0) { return(false); } else { return(true); } }
/// <summary> /// 获得MenuButtonId /// </summary> /// <param name="strMenuName"></param> /// <param name="strButtonName"></param> /// <returns></returns> public static int GetMenuButtonId(string strMenuName, string strButtonName) { string strSql = @"select autoId from BS_MenuButton " + "where menuName like '" + strMenuName + "' and buttonName like '" + strButtonName + "'"; DataTable dt = new DataTable(); dt = BaseSQL.GetTableBySql(strSql); if (dt.Rows.Count == 0) { string sql = string.Format("select Count(*) from BS_Button where ButtonName = '{0}'", strButtonName); string insertSql = ""; if (DataTypeConvert.GetInt(BaseSQL.GetSingle(sql)) == 0) { insertSql = string.Format("Insert into BS_Button (ButtonName, ButtonText) values ('{0}', '{1}')", strButtonName, ""); BaseSQL.ExecuteSql(insertSql); } insertSql = string.Format("Insert Into BS_MenuButton (MenuName, ButtonName) values ('{0}', '{1}')", strMenuName, strButtonName); BaseSQL.ExecuteSql(insertSql); dt = BaseSQL.GetTableBySql(strSql); } return((int)dt.Rows[0]["AutoId"]); }
/// <summary> /// 查询和当前零件编号相同的零件个数 /// </summary> public int QueryPartsCode_CodeFileNameCount(string codeFileNameStr) { string sqlStr = string.Format("select Count(*) from SW_PartsCode where CodeFileName = '{0}'", codeFileNameStr); return(DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr))); }
/// <summary> /// 查询和当前零件编号相同的Bom信息数量 /// </summary> public int QueryBom_CodeFileNameCount(string codeFileNameStr) { string sqlStr = string.Format("select Count(*) from BS_BomManagement where MaterielNo = '{0}'", codeFileNameStr); return(DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr))); }
/// <summary> /// 查询项目状态信息的默认编号 /// </summary> public int GetProjectStatus_DefaultAutoId() { string sqlStr = "select AutoId from BS_ProjectStatus where IsDefault = 1"; return(DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr))); }
/// <summary> /// 查询项目状态信息的默认数量 /// </summary> public int GetProjectStatus_DefaultCount(int autoIdInt) { string sqlStr = string.Format("select Count(*) from BS_ProjectStatus where IsDefault = 1 and AutoId != {0}", autoIdInt); return(DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr))); }
/// <summary> /// 查询单个系统参数值 /// </summary> public static object QuerySystemParameter_Single(string moduleCateStr, string keyStr) { string sqlStr = string.Format("select ParameterValue from BS_SysParameter where ModuleCate = '{0}' and ParameterKey = '{1}'", moduleCateStr, keyStr); return(BaseSQL.GetSingle(sqlStr)); }
/// <summary> /// 刷新所有的系统参数 /// </summary> public void RefreshAllSystemParameter() { DataTable sysParameterTable = new DataTable(); QuerySystemParameter(sysParameterTable); #region 常规 string tmpStr = GetValue(sysParameterTable, "Common", "PageRowCount"); if (tmpStr != "") { SystemInfo.OrderQueryGrid_PageRowCount = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Common", "DateIntervalDays"); if (tmpStr != "") { SystemInfo.OrderQueryDate_DateIntervalDays = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Common", "FormDragDropMaxRecordCount"); if (tmpStr != "") { SystemInfo.FormDragDropMaxRecordCount = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Common", "LeftDockWidth"); if (tmpStr != "") { SystemInfo.DragForm_LeftDock_Width = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Common", "EnableWorkFlowMessage"); if (tmpStr != "") { SystemInfo.EnableWorkFlowMessage = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Common", "ApproveAfterPrint"); if (tmpStr != "") { SystemInfo.ApproveAfterPrint = tmpStr == "1"; } #endregion #region 销售 tmpStr = GetValue(sysParameterTable, "Sale", "QuotationDefaultTax"); if (tmpStr != "") { SystemInfo.Quotation_DefaultTax = DataTypeConvert.GetDouble(tmpStr); } tmpStr = GetValue(sysParameterTable, "Sale", "SalesOrderDefaultTax"); if (tmpStr != "") { SystemInfo.SalesOrder_DefaultTax = DataTypeConvert.GetDouble(tmpStr); } #endregion #region 项目 tmpStr = GetValue(sysParameterTable, "Project", "GanttResourcesPerPage"); if (tmpStr != "") { SystemInfo.Gantt_ResourcesPerPage = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Project", "GanttSchedulerBarHeight"); if (tmpStr != "") { SystemInfo.Gantt_SchedulerBarHeight = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Project", "GanttSchedulerBarColor"); if (tmpStr != "") { SystemInfo.Gantt_SchedulerBarColor = System.Drawing.ColorTranslator.FromHtml(tmpStr); } #endregion #region 采购 tmpStr = GetValue(sysParameterTable, "Purchase", "PrReqIsAlterPSBomAutoId"); if (tmpStr != "") { SystemInfo.PrReqIsAlter_PSBomAutoId = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Purchase", "OrderListDefaultTax"); if (tmpStr != "") { SystemInfo.OrderList_DefaultTax = DataTypeConvert.GetDouble(tmpStr); } tmpStr = GetValue(sysParameterTable, "Purchase", "SettlementDefaultTax"); if (tmpStr != "") { SystemInfo.Settlement_DefaultTax = DataTypeConvert.GetDouble(tmpStr); } tmpStr = GetValue(sysParameterTable, "Purchase", "OrderNoWarehousingDays"); if (tmpStr != "") { SystemInfo.OrderNoWarehousing_Days = DataTypeConvert.GetInt(tmpStr); } tmpStr = GetValue(sysParameterTable, "Purchase", "PrReqApplyBeyondCountIsSave"); if (tmpStr != "") { SystemInfo.PrReqApplyBeyondCountIsSave = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Purchase", "WWApplyBeyondCountIsSave"); if (tmpStr != "") { SystemInfo.WarehouseWarrantApplyBeyondCountIsSave = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Purchase", "PrListDistributionMessage"); if (tmpStr != "") { SystemInfo.PrListDistributionMessage = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Purchase", "PrListDistributionAllHandle"); if (tmpStr != "") { SystemInfo.PrListDistributionAllHandle = tmpStr == "1"; } #endregion #region 库存 tmpStr = GetValue(sysParameterTable, "Warehouse", "OrderApplyBeyondCountIsSave"); if (tmpStr != "") { SystemInfo.OrderApplyBeyondCountIsSave = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "WWIsAlterDate"); if (tmpStr != "") { SystemInfo.WarehouseWarrantIsAlterDate = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "PPApplyBeyondCountIsSave"); if (tmpStr != "") { SystemInfo.PPApplyBeyondCountIsSave = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "WRIsAlterDate"); if (tmpStr != "") { SystemInfo.WarehouseReceiptIsAlterDate = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "DisableProjectNo"); if (tmpStr != "") { SystemInfo.DisableProjectNo = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "DisableShelfInfo"); if (tmpStr != "") { SystemInfo.DisableShelfInfo = tmpStr == "1"; } SystemInfo.DisableShelfInfo_Default_ShelfId = DataTypeConvert.GetInt(BaseSQL.GetSingle(string.Format("select AutoId from BS_ShelfInfo where ShelfNo = '{0}' and RepertoryInfoId is null and RepertoryLocationId is null", defaultShelfNo))); tmpStr = GetValue(sysParameterTable, "Warehouse", "EnableNegativeInventory"); if (tmpStr != "") { SystemInfo.EnableNegativeInventory = tmpStr == "1"; } tmpStr = GetValue(sysParameterTable, "Warehouse", "InventorySaveApproval"); if (tmpStr != "") { SystemInfo.InventorySaveApproval = tmpStr == "1"; } #endregion #region 生产 #endregion #region 人事 #endregion #region 会计 #endregion }
public string QueryPartsCode_FilePath(string codeFileNameStr) { string sqlStr = string.Format("select FilePath from SW_PartsCode where CodeFileName = '{0}'", codeFileNameStr); return(DataTypeConvert.GetString(BaseSQL.GetSingle(sqlStr))); }
/// <summary> /// 批量更新零件信息 /// </summary> public int QueryPartsCode(string queryWhereSqlStr) { string sqlStr = string.Format("select Count(*) from SW_PartsCode where {0}", queryWhereSqlStr); return(DataTypeConvert.GetInt(BaseSQL.GetSingle(sqlStr))); }