CRM开发记录

CRM中角色的一些功能权限的检查和处理

摘要：CRM中现没有正确处理一个用户对应多个角色,应自已做的时间长了记不清了,应一一检查如下功能:1.建立角色时对所有目录都没有权限检查如下;CRM_RolesAdd,核心代码如下--添加操作 INSERT INTO acl_roles( [id],[created_by],[name],[description],[deleted] )VALUES( @id,@created_by,@name,@d... 阅读全文

posted @ 2007-06-30 06:49 hhq80 阅读(443) 评论(0) 推荐(0)

CRM批注

摘要：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_SchedulePostil]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CRM_SchedulePostil]GO if not exists (select * f... 阅读全文

posted @ 2007-03-20 17:28 hhq80 阅读(172) 评论(0) 推荐(0)

权限模板

摘要：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_LimitTemplet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CRM_LimitTemplet]GO if not exists (select * from ... 阅读全文

posted @ 2007-03-12 20:09 hhq80 阅读(267) 评论(0) 推荐(0)

用户表

摘要：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_LoginUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CRM_LoginUser]GO if not exists (select * from dbo.sy... 阅读全文

posted @ 2007-03-11 20:18 hhq80 阅读(256) 评论(0) 推荐(0)

日程管理

摘要：日程管理主表if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_Schedule]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CRM_Schedule]GO if not exists (select * from db... 阅读全文

posted @ 2007-03-07 16:59 hhq80 阅读(437) 评论(0) 推荐(0)

代理商销售

摘要：在代理商销售时应增加一字段来记录已销售多少在sfmx中增加一字段，用于记录该批次已销售多少ALTER TABLE dbo.ZY_YP1_SFMX ADD CONSTRAINT DF_ZY_YP1_SFMX_yysl DEFAULT 0 FOR yyslGO ALTER TABLE dbo.zy_yp1_proxysalesdetail ADD lsh0 char(18) NULL--存放原始进货批... 阅读全文

posted @ 2007-03-04 15:27 hhq80 阅读(216) 评论(1) 推荐(0)

js中在dotnot中innerText与value的使用区别

摘要：当在主窗口中: private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { if(e.Item.ItemType == ListItemType.Footer) { //id:DataGrid1__ctl8 name:D... 阅读全文

posted @ 2007-03-04 08:28 hhq80 阅读(609) 评论(0) 推荐(0)

代理商销售明细表

摘要：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zy_yp1_proxysalesdetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[zy_yp1_proxysalesdetail]GO CREATE TABLE [d... 阅读全文

posted @ 2007-02-28 10:54 hhq80 阅读(463) 评论(0) 推荐(0)

session访问

摘要：ResinSession so=(ResinSession)Session["obj"]; if ( so != null) { proxyid= so.proxyid; } else { Response.Redirect(Application["appPath"] + "logout.aspx"); }===== Session["_maste... 阅读全文

posted @ 2007-02-26 06:41 hhq80 阅读(237) 评论(0) 推荐(0)

摘要：1.用户信息记录阅读全文

posted @ 2007-01-18 08:40 hhq80 阅读(235) 评论(0) 推荐(0)

医药CRM系统开发

导航

公告

随笔分类 - CRM开发记录