Ext.js项目（二）

人事管理模块：

     1.机构管理

     2.部门管理

     3.人员管理

一：用例图

 

二：数据表分析

三：需要涉及到的类：

需要涉及到的类：（完成一个模块时只需要修改包含：（----）即可）
ExtOA.Ent->BranchInfoBase
ExtOA.Ent->BranchInfo（----）
ExtOA.IDal->IBranchInfoDR（----）
ExtOA.SqlServerDal ->BranchInfoDRBase
ExtOA.SqlServerDal ->BranchInfoDR（-----）
ExtOA.Biz->BranchInfoBiz（-----）

四：在BranchInfoBiz中写两个重写的方法（Json格式）：

引入的命名空间：





?
1
2
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;








?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
/// <summary>
       /// 添加一条 BranchInfo   通过重写的方法
       /// </summary>
       /// <param name="ent">BranchInfo实体</param>
       /// <returns>1成功,-1失败,0异常　主键从实体里返回</returns>
       /// <exception cref="ex">异常信息</exception>
       /// <remarks>
       /// <para>Author: "fwy"</para>
       /// </remarks>
       public int AddBranchInfo(string entJson)
       {
           try
           {
               //自动转换成泛型对象
               BranchInfo branch = Newtonsoft.Json.JsonConvert.DeserializeObject<BranchInfo>(entJson);
               IBranchInfoDR dal = BranchInfoDal.Create(Config.Instance().Dal, Config.Instance().MyConnectstring);
               return dal.Add(branch);
           }
           catch (Exception ex)
           {
               ////log.Error("AddBranchInfo err:",ex);
               return 0;
           }
       }
 
 
  /// <summary>
       /// 更新一条 BranchInfo
       /// </summary>
       /// <param name="ent">BranchInfo实体</param>
       /// <returns>1成功,-1失败,0异常</returns>
       /// <exception cref="ex">异常信息</exception>
       /// <remarks>
       /// <para>Author: "fwy"</para>
       /// </remarks>
       public int SetBranchInfo(BranchInfo entJson)
       {
           try
           {
               BranchInfo branch = Newtonsoft.Json.JsonConvert.DeserializeObject<BranchInfo>(entJson);
               IBranchInfoDR dal = BranchInfoDal.Create(Config.Instance().Dal, Config.Instance().MyConnectstring);
               return dal.Set(branch);
           }
           catch (Exception ex)
           {
               ////log.Error("SetBranchInfo err:",ex);
               return 0;
           }
       }




 五：四种构造返回到前台数据的方法




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
/// <summary>  四种构造返回到前台数据的方法
       /// 得到所有机构列表(Json格式）格式如下：
       /// {
       ///    total:5,
       ///    rows:[{},{},...]
       /// }
       /// </summary>
       /// <returns></returns>
       public string GetJsonBranchInfo()
       {
           JArray ja = new JArray();
           IList<BranchInfo> branchInfos = this.GetBranchInfo();
           //创建了一个json格式的对象
           foreach (BranchInfo branch in branchInfos)
           {
               JObject sj = new JObject();
               //与实体类中的一一对应
               JProperty Id = new JProperty("Id", branch.Id);
               sj.Add(Id);
               JProperty BranchName = new JProperty("BranchName", branch.BranchName);
               sj.Add(BranchName);
               JProperty BranchAddr = new JProperty("BranchAddr", branch.BranchAddr);
               sj.Add(BranchAddr);
               JProperty BranchPhone = new JProperty("BranchPhone", branch.BranchAddr);
               sj.Add(BranchPhone);
               JProperty BranchUrl = new JProperty("BranchUrl", branch.BranchAddr);
               sj.Add(BranchUrl);
               JProperty BranchMaster = new JProperty("BranchMaster", branch.BranchMaster);
               sj.Add(BranchMaster);
 
               UserInfo userinfo = (new UserInfoBiz()).GetUserInfoById(branch.BranchMaster);
               JProperty BranchMasterName = new JProperty("BranchMasterName", userinfo.UserName);
               sj.Add(BranchMasterName);
               //把对象添加到数组中去
               ja.Add(sj);
           }
           JObject j = new JObject();
 
           //给json对象中添加了一个属性
           JProperty total = new JProperty("total", branchInfos.Count);
           j.Add(total);
           JProperty rows = new JProperty("rows", ja);
           j.Add(rows);
 
           return j.ToString();
       }
 
 
       /// <summary>
       /// 得到所有机构列表(Json格式）格式如下：
       /// {
       ///    total:5,
       ///    rows:[{},{},...]
       /// }
       /// </summary>
       /// <returns></returns>
       public string GetJsonBranchInfo2()
       {
           JArray ja = new JArray();
           IList<BranchInfo> branchInfos = this.GetBranchInfo();
           foreach (BranchInfo branch in branchInfos)
           {
               JObject sj = new JObject();
               JProperty Id = new JProperty("Id", branch.Id);
               sj.Add(Id);
               JProperty BranchName = new JProperty("BranchName", branch.BranchName);
               sj.Add(BranchName);
               JProperty BranchAddr = new JProperty("BranchAddr", branch.BranchAddr);
               sj.Add(BranchAddr);
               JProperty BranchPhone = new JProperty("BranchPhone", branch.BranchAddr);
               sj.Add(BranchPhone);
               JProperty BranchUrl = new JProperty("BranchUrl", branch.BranchAddr);
               sj.Add(BranchUrl);
               UserInfo userinfo = (new UserInfoBiz()).GetUserInfoById(branch.BranchMaster);
               string BranchMasterJson = Newtonsoft.Json.JsonConvert.SerializeObject(userinfo);
 
               // JProperty BranchMaster = new JProperty("BranchMaster", BranchMasterJson);
               //把json对象还原成JObject
               JProperty BranchMaster = new JProperty("BranchMaster", JObject.Parse(BranchMasterJson));
               sj.Add(BranchMaster);
 
               ja.Add(sj);
           }
 
           JObject j = new JObject();
           JProperty total = new JProperty("total", branchInfos.Count);
           j.Add(total);
           JProperty rows = new JProperty("rows", ja);
           j.Add(rows);
 
           return j.ToString();
 
       }
 
       /// <summary>
       /// 得到所有机构列表(Json格式）格式如下：
       /// {
       ///    total:5,
       ///    rows:[{},{},...]
       /// }
       /// </summary>
       /// <returns></returns>
       public string GetJsonBranchInfo3()
       {
           JArray ja = new JArray();
           IList<BranchInfo> branchInfos = this.GetBranchInfo();
           foreach (BranchInfo branch in branchInfos)
           {
               JObject sj = new JObject();
               JProperty Id = new JProperty("Id", branch.Id);
               sj.Add(Id);
               JProperty BranchName = new JProperty("BranchName", branch.BranchName);
               sj.Add(BranchName);
               JProperty BranchAddr = new JProperty("BranchAddr", branch.BranchAddr);
               sj.Add(BranchAddr);
               JProperty BranchPhone = new JProperty("BranchPhone", branch.BranchPhone);
               sj.Add(BranchPhone);
               JProperty BranchUrl = new JProperty("BranchUrl", branch.BranchUrl);
               sj.Add(BranchUrl);
 
               UserInfo userinfo = (new UserInfoBiz()).GetUserInfoById(branch.BranchMaster);
               //去拼接所需要的格式
               string BranchMasterJson = "{" + string.Format("Id:{0},UserName:'{1}'", userinfo.Id, userinfo.UserName) + "}";
               JProperty BranchMaster = new JProperty("BranchMaster", JObject.Parse(BranchMasterJson));
               sj.Add(BranchMaster);
 
               ja.Add(sj);
           }
 
           JObject j = new JObject();
           JProperty total = new JProperty("total", branchInfos.Count);
           j.Add(total);
           JProperty rows = new JProperty("rows", ja);
           j.Add(rows);
 
           return j.ToString();
 
       }
 
 
       /// <summary>
       /// 得到所有机构列表(Json格式）格式如下：
       /// {
       ///    total:5,
       ///    rows:[{},{},...]
       /// }
       /// </summary>
       /// <returns></returns>
       public string GetJsonBranchInfo4()
       {
           JArray ja = new JArray();
           IList<BranchInfo> branchInfos = this.GetBranchInfo();
           foreach (BranchInfo branch in branchInfos)
           {
               var branchJson = Newtonsoft.Json.JsonConvert.SerializeObject(branch);
               JObject sj = JObject.Parse(branchJson);
 
               //外键的时候 先把外键删除  再重新构建
               sj.Remove("BranchMaster");
               UserInfo userinfo = (new UserInfoBiz()).GetUserInfoById(branch.BranchMaster);
               string BranchMasterJson = "{" + string.Format("Id:{0},UserName:'{1}'", userinfo.Id, userinfo.UserName) + "}";
               JProperty BranchMaster = new JProperty("BranchMaster", JObject.Parse(BranchMasterJson));
               sj.Add(BranchMaster);
 
               //UserInfo userinfo = (new UserInfoBiz()).GetUserInfoById(branch.BranchMaster);
               //JProperty BranchMasterName = new JProperty("BranchMasterName", userinfo.UserName);
               //sj.Add(BranchMasterName);
 
 
 
               ja.Add(sj);
           }
 
           JObject j = new JObject();
           JProperty total = new JProperty("total", branchInfos.Count);
           j.Add(total);
           JProperty rows = new JProperty("rows", ja);
           j.Add(rows);
 
           return j.ToString();
 
       }




 


 六：全局的Global.js中的代码




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
Ext.ns("Ext.OA");//基类的命名空间
Ext.ns("Ext.OA.HrManager"); //人事管理的命名空间
Ext.ns("Ext.OA.ScheduleManage"); //日常管理的命名空间
Ext.Msg.minWidth = 300;  // 设置Ext.Msg弹窗口的最小宽度
// 初始化错误提示
Ext.QuickTips.init();
// 统一指定错误信息提示方式
Ext.form.Field.prototype.msgTarget = 'side';
 
//隐藏提示进度条
function hideMessageBox() {
    setTimeout(function () { Ext.MessageBox.hide() }, 1000);
}
 
//显示提示进度条
function showMessageBox() {
    Ext.MessageBox.show
                            (
                                {
                                    msg: '数据加载中...',
                                    progressText: 'Loading...',
                                    width: 300,
                                    wait: true,
                                    waitConfig: { interval: 200 },
                                    icon: Ext.MessageBox.INFO
                                    //animEl: 'saving'
                                }
                            );
}
 
// 中文排序问题解决
// 重载 Ext.data.Store.prototype.applySort 函数以修复 DataStore 对汉字排序异常的问题
// var _applySort = Ext.data.Store.prototype.applySort;
// 如有需要，保存原 applySort 函数的引用
 
Ext.data.Store.prototype.applySort = function () { // 重载 applySort
    if (this.sortInfo && !this.remoteSort) { // sortInfo对象存在并且不是远程排序
        var s = this.sortInfo, f = s.field;
        var st = this.fields.get(f).sortType;
        var fn = function (r1, r2) {
            var v1 = st(r1.data[f]), v2 = st(r2.data[f]);
            // 添加:修复汉字排序异常的Bug
            if (typeof (v1) == "string") { // 若为字符串类型，
                // 则用 localeCompare 比较汉字字符串, Firefox 与 IE 均支持
                return v1.localeCompare(v2);
            }
            // 若不是字符串类型
            return v1 > v2 ? 1 : (v1 < v2 ? -1 : 0);
        };
        this.data.sort(s.direction, fn);
        if (this.snapshot && this.snapshot != this.data) { // 数据快照
            this.snapshot.sort(s.direction, fn);
        }
    }
};
NodeClick = function (node) {
    
    if (node.id == 93) { //考勤统计
        var userNode = { id: "93", text: "考勤统计" };
        KQTJ(userNode);
    } else if (node.id == 74) {
        //var userNode = { id: "74", text: "工单考核" };
        ZXKS();
    }
    else {
        Ext.Msg.alert("提示", "此操作还没有开发");
    }
}
// 关闭TabPanel标签
Ext.ux.TabCloseMenu = function () {
    var tabs, menu, ctxItem;
    this.init = function (tp) {
        tabs = tp;
        tabs.on('contextmenu', onContextMenu);
    }
 
    function onContextMenu(ts, item, e) {
        if (!menu) { // create context menu on first right click
            menu = new Ext.menu.Menu([{
                id: tabs.id + '-close',
                text: '关闭标签',
                iconCls: "closeone",
                handler: function () {
                    tabs.remove(ctxItem);
                }
            }, {
                id: tabs.id + '-close-others',
                text: '关闭其他标签',
                iconCls: "closeother",
                handler: function () {
                    tabs.items.each(function (item) {
                        if (item.closable && item != ctxItem) {
                            tabs.remove(item);
                        }
                    });
                }
            }, {
                id: tabs.id + '-close-all',
                text: '关闭全部标签',
                iconCls: "closeall",
                handler: function () {
                    tabs.items.each(function (item) {
                        if (item.closable) {
                            tabs.remove(item);
                        }
                    });
                }
            }]);
        }
        ctxItem = item;
        var items = menu.items;
        items.get(tabs.id + '-close').setDisabled(!item.closable);
        var disableOthers = true;
        tabs.items.each(function () {
            if (this != item && this.closable) {
                disableOthers = false;
                return false;
            }
        });
        items.get(tabs.id + '-close-others').setDisabled(disableOthers);
        var disableAll = true;
        tabs.items.each(function () {
            if (this.closable) {
                disableAll = false;
                return false;
            }
        });
        items.get(tabs.id + '-close-all').setDisabled(disableAll);
        menu.showAt(e.getPoint());
    }
};
 
// 内容为grid
GridAdd = function (node, grid) {
    var tab = center.add({
        id: node.id,
        iconCls: "tabicon",
        xtype: "panel",
        title: node.text,
        closable: true,
        layout: "fit",
        frame: true,
        items: [grid]
    });
    center.setActiveTab(tab);
    grid.show();
}
// 写cookies函数
function setCookie(name, value)// 两个参数，一个是cookie的名子，一个是值
{
    var Days = 30; // 此 cookie 将被保存 30 天
    var exp = new Date(); // new Date("December 31, 9998");
    exp.setTime(exp.getTime() + Days * 24 * 60 * 60 * 1000);
    document.cookie = name + "=" + escape(value) + ";expires="
            + exp.toGMTString();
}
// 取cookies函数
function getCookie(name) {
    var arr = document.cookie
            .match(new RegExp("(^| )" + name + "=([^;]*)(;|$)"));
    if (arr != null)
        return unescape(arr[2]);
    return null;
 
}
// 删除cookie
function delCookie(name) {
    var exp = new Date();
    exp.setTime(exp.getTime() - 1);
    var cval = getCookie(name);
    if (cval != null)
        document.cookie = name + "=" + cval + ";expires=" + exp.toGMTString();
}






 七：DeskTop调用机构管理Window
     1.编写机构管理窗体JS类


复制代码


Ext.OA.HrManager.BranchInfoWin = function() {
    this.main = new Ext.Window({
        id: "rsgl_jggl_win",
        title: "机构管理",
        width: 600,
        iconCls: 'jggl',
        height: 400,
        closeAction: 'hide',
        plain: true,
        modal: true,
        draggable: true,
        closable: true,
        layout: "fit"
    });
}


复制代码


2.在desktop.js中编写调用代码：




?
1
2
3
4
5
6
7
8
9
…
items: [{
                    text: '机构管理',
                    iconCls: 'jggl',
                    handler: this.createWindow,<br>                                        //为了obj.windowId   必须  scope: this,
                    scope: this,
                    windowId: 'rsgl_jggl'
                }
…




 注意：




?
1
2
3
4
5
6
7
8
9
10
11
12
13
createWindow: function(obj) {
            var desktop = this.app.getDesktop();
            var win = desktop.getWindow(obj.windowId);
            var winObj = null;
            if (!win) {
                if (obj.windowId == "rsgl_jggl")
                    winObj =Ext.OA.HrManager.BranchInfoWin;
 
                win = desktop.createWindow(winObj);
            }
 
            win.show();
        }




 


八：机构管理前后台数据的交互：

    1.编写后台管理数据的页面：GetBranchInfo.aspx


 




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
protected void Page_Load(object sender, EventArgs e)
  {<br>        //判断是添加还是修改
      if (Request["act"].ToString() == "create")
      {
          string branchInfoJson = Request["name"].ToString();
          BranchInfoBiz helper = new BranchInfoBiz();
          int result = helper.AddBranchInfo(branchInfoJson);
          if (result > 0)
          {
              Response.Write("{success:true,result:" + result + ",message:'添加机构信息成功'}");
          }
          else
          {
              Response.Write("{success:false,result:0,message:'添加机构信息失败!'}");
          }
      }
      else if (Request["act"].ToString() == "update")
      {
          string branchInfoJson = Request["name"].ToString();
          BranchInfoBiz helper = new BranchInfoBiz();
          int result = helper.SetBranchInfo(branchInfoJson);
          if (result > 0)
          {
              Response.Write("{" + string.Format("success:true,result:{0}", result) + ",message:'修改机构信息成功!'}");
          }
          else
          {
              Response.Write("{success:false,result:0,message:'修改机构信息失败!'}");
          }
 
      }
      else if (Request["act"].ToString() == "delete") {
          int id = int.Parse(Request["name"].ToString());
          BranchInfoBiz helper = new BranchInfoBiz();
          int result = helper.DelBranchInfo(id);
          if (result>0)
              Response.Write("{" + string.Format("success:true,result:{0}", result) + ",message:'删除机构信息成功!'}");
          else
              Response.Write("{success:false,result:0,message:'删除机构信息失败!'}");
 
      }
      else
      {
          BranchInfoBiz helper = new BranchInfoBiz();
          string json = helper.GetJsonBranchInfo3();
          //string json = helper.GetJsonBranchInfo();
          Response.Write(json);
      }
 
  }




 2.编写BranchInfoMgr.js（注意Grid配置项）：




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
Ext.OA.HrManager.BranchInfoWin = function() {
 
    var url = "/Web/Manage/DeskTop/JSON/GetBranchInfo.aspx";
 
    //通过扩展方法创建Grid
    Ext.ux.BranchInfoGrid = Ext.extend(Ext.ux.EasyGrid, {
        //调用父类的构造函数
        initComponent: function() {
            Ext.ux.BranchInfoGrid.superclass.initComponent.call(this);
        }
    });
        //下拉列表分页返回的数据
    var LeaderStore = new Ext.data.Store({
        proxy: new Ext.data.HttpProxy({<br>                        //-1为无条件的
            url: "/Web/Manage/DeskTop/JSON/GetSimpleUserInfo.aspx?condition=-1"
        }),
        reader: new Ext.data.JsonReader(
            { totalProperty: 'totalProperty', root: 'root' },
            [{ name: "LeaderId", type: "int" }, { name: "LeaderName", type: "string"}]
        )
    });
 
    LeaderStore.load();
 
    var cbxLeader = new Ext.form.ComboBox({
        fieldLabel: "负责人",
        labelStyle: "width:130px",
        width: 125,
        editable: false,
        id: "cbxLeader",
        name: "cbxLeader",
        pageSize: 5,
        store: LeaderStore,
        emptyText: "--请选择--",
        mode: "remote",
        displayField: "LeaderName",
        valueField: "LeaderId",
        hiddenName: "BranchMaster",
        triggerAction: "all",
        selectOnFocus: true,
        listWidth: 200
 
    });
 
 
    //获取外键的值
    var renderBranchMaster = function(value) {
        if (value) {
            return value.UserName;
        }
    };
 
    //与扩展的Grid参数一致
    var fnCreate = function(_store, _form, _record) {
        _record.data.Id = 0;
        var params = Ext.encode(_record.data);
        Ext.Ajax.request({
            url: url,
            success: function(response) {
                //alert(response.responseText);
                var json = Ext.decode(response.responseText);
                if (json.success) {
                    var _combo = _form.findField("cbxLeader");
 
                    var branchId = _combo.getValue();
                    var branchName = _combo.getRawValue(); //得到comboBox选中的Text
                    _record.set("BranchMaster", { "Id": branchId, "UserName": branchName });
                    _record.set("Id", json.result);
                    _record.commit();
                    _store.add(_record);
                    //_store.reload();
                } else {
                    Ext.Msg.alert("OA智能办公平台", json.message);
                }
            },
            faiure: function(response) {
                Ext.Msg.alert("OA智能办公平台", "添加机构失败!");
            },
            params: { act: "create", name: params, temp: (new Date()).getTime() }
        });
 
 
    };
 
    var fnUpdate = function(_form, r) {
        var params = Ext.encode(_form.getFieldValues());
        Ext.Ajax.request({
            url: url,
            success: function(response) {
                var json = Ext.decode(response.responseText);
                if (json.success) {
                    var values = _form.getFieldValues();
                    r.beginEdit();
                    for (var name in values) {
                        r.set(name, values[name]);
                    }
                    var _combo = _form.findField("cbxLeader");
                    var branchId = _combo.getValue();
                    var branchName = _combo.getRawValue(); //得到comboBox选中的Text
                    r.set("BranchMaster", { "Id": branchId, "UserName": branchName });
                    r.set("Id", json.result);
                    r.endEdit();
                    r.commit();
 
                    //_store.reload();
                } else {
                    Ext.Msg.alert("OA智能办公平台", json.message);
                }
            },
            faiure: function(response) {
                Ext.Msg.alert("OA智能办公平台", "修改机构失败!");
            },
            params: { act: "update", name: params, temp: (new Date()).getTime() }
        });
 
    };
 
    var fnDelete = function(_store, r) {
        var params = r.data.Id;
        Ext.Ajax.request({
            url: url,
            success: function(response) {<br>                                 //查看返回内容的写法
                //alert(response.responseText);<br>                                //把字符串变成对象  提示弹出
                var json = Ext.decode(response.responseText);<br>                                
                if (json.success) {<br>                                     //删除成功 直接移除store 对象
                    _store.remove(r);
                    //_store.reload();
                } else {
                    Ext.Msg.alert("OA智能办公平台", json.message);
                }
            },
            faiure: function(response) {
                Ext.Msg.alert("OA智能办公平台", "删除失败!");
            },<br>                         //清掉缓存的参数
            params: { act: "delete", name: params, temp: (new Date()).getTime() }
        });
    };
 
    var fnWinModify = function(_form, _record) {
        var _combo = _form.findField("cbxLeader");
        _combo.setValue(_record.data.BranchMaster.Id);
        _combo.setRawValue(_record.data.BranchMaster.UserName);
    };
 
    //直接继承下来的Grid
    var branchInfoGrid = new Ext.ux.BranchInfoGrid({
        title: "机构管理",
        //width: 400,
        autoWidth:true,
        url: url + "?act=read",
        type: "json",
        header: false,
        //去掉头部的标签
        headerAsText: false,
        height: 400,
        fnCreate: fnCreate,
        fnUpdate: fnUpdate,
        fnDelete: fnDelete,
        //修改显示的时候并不是全是文本框
        fnWinModify: fnWinModify,
        subFormConfig: { create: { width: 400, height: 300, title: "添加机构", items: { ids: [5], fields: [cbxLeader] } },<br> update: { width: 400, height: 300, title: "修改机构" } },
        //跟实体类的属性一致
        fields: ['Id', 'BranchName', 'BranchAddr', 'BranchPhone', 'BranchUrl', 'BranchMaster'],
        headers: ['ID', '机构名称', '住址', '联系电话', '网址', '负责人'],
       // 第一种方式的写法
        //fields: ['Id', 'BranchName', 'BranchAddr', 'BranchPhone', 'BranchUrl', 'BranchMaster',"BranchMasterName"],
        //headers: ['ID', '机构名称', '住址', '联系电话', '网址', '负责人ID',"负责人"],
        //隐藏列
        colhidden: [0],
        //colhidden: [0,5],
        //显示的外键
        renderer: { ids: [5], funcs: [renderBranchMaster] }
 
    });
 
    var labelTitle = new Ext.form.Label({
        height: 20,
        html: "<img src='/Web/images/right_arrow.gif' alt='' align='absmiddle'/> 当前位置: 人事管理 > 机构管理"
    });
    this.main = new Ext.Window({
        id: "rsgl_jggl_win",
        title: "机构管理",
        width: 600,
        iconCls: 'jggl',
        height: 400,
        closeAction: 'hide',
        plain: true,
        modal: true,
        draggable: true,
        closable: true,
        //layout: "fit",
        items: [labelTitle, branchInfoGrid]
    });
}




 


 3.下拉列表的加载：


      1.首先创建一个视图（减少对数据的查询    只返回姓名和职位即可）：


      




?
1
2
3
SELECT   a.Id, a.UserName, b.DutyDesc
FROM      dbo.UserInfo AS a INNER JOIN
                dbo.DutyInfo AS b ON a.DutyInfoNo = b.Id




   2.IDal层的代码：




?
1
2
3
4
5
6
7
8
9
10
/// <summary>
   /// 分页获取用户数据(返回用户ID和用户名)
   /// </summary>
   /// <param name="startIndex">起始条数(从第0条开始)</param>
   /// <param name="pagesize">每页几条记录</param>
   /// <param name="condition">条件：默认为'1=1'</param>
   /// <param name="key">主键名称,默认为'id'</param>
   /// <param name="totalcount">分页前的总数</param>
   /// <returns></returns>
   DataTable GetSimpleUserInfoByPager(int startIndex, int pagesize, string condition, string key, out int totalcount);




 


  3.Dal层的代码：




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
/// <summary>
       /// 获取简单用户数据（仅返回ID,UserName）
       /// </summary>
       /// <param name="startIndex"></param>
       /// <param name="pagesize"></param>
       /// <param name="condition"></param>
       /// <param name="key"></param>
       /// <param name="totalcount"></param>
       /// <returns></returns>
       public DataTable GetSimpleUserInfoByPager(int startIndex, int pagesize, string condition, string key, out int totalcount)
       {
 
           using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionString))
           {
                
               string strsql = string.Format("exec GetDataByPager {0},'{1}',{2},'{3}','{4}'", <br>startIndex, "v_SimpleUserInfo", pagesize, condition, key);
 
 
               connection.Open();
 
               SqlDataAdapter da = new SqlDataAdapter(strsql, connection);
               DataSet ds = new DataSet();
               try
               {
                   da.Fill(ds);
                   totalcount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
                   return ds.Tables[0];
               }
               catch
               {
                   totalcount = 0;
                   return null;
               }
           }
 
 
       }




 


4.BLL层的代码：




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
public DataTable GetSimpleUserInfoByPager(int startIndex, int pagesize, out int totalcount, string condition)
       {
           try
           {
               IUserInfoDR dal = UserInfoDal.Create(Config.Instance().Dal, Config.Instance().MyConnectstring);
               return dal.GetSimpleUserInfoByPager(startIndex, pagesize, condition, "id", out totalcount);
 
           }
           catch (Exception ex)
           {
               //log.Error("GetUserInfoById err:",ex);
               totalcount = 0;
               return null;
           }
       }






 5.页面后台调用代码：




?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
public partial class Manage_desktop_JSON_GetSimpleUserInfo : System.Web.UI.Page
{
    /// <summary>
    /// 起始条数(从0开始)
    /// </summary>
    public int StartIndex
    {
        get
        {
            if (Request["start"] != null)
            {
                return int.Parse(Request["start"].ToString());
            }
            else
            {
                return 0;
            }
        }
    }
    /// <summary>
    /// 分页的条数，默认为5
    /// </summary>
    public int PageSize
    {
        get
        {
            if (Request["limit"] != null)
            {
                return int.Parse(Request["limit"].ToString());
            }
            else
            {
                return 5;
            }
        }
    }
 
     /// <summary>
     /// 最终返回的数据
     /// </summary>
     /// <param name="sender"></param>
     /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        string outputString = this.JsonHeader() + this.JsonBody() + this.JsonFooter();
        Response.Write(outputString);
        Response.End();
    }
 
    private string JsonFooter()
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("],'totalProperty':" + this.TotalRecord.ToString() + "}");
        return sb.ToString();
    }
 
   /// <summary>
   /// 查询条件  -1为无条件
   /// </summary>
    private string Condition
    {
        get
        {
            if (Request["condition"] != null)
                return Request["condition"].ToString();
            else
                return "";
        }
    }
    /// <summary>
    /// 循环输出Json字符串
    /// </summary>
    /// <returns></returns>
    private string JsonBody()
    {
        StringBuilder sb = new StringBuilder();
        int totalcount = 0;
        UserInfoBiz helper = new UserInfoBiz();
 
        DataTable  userinfos = null;
        
        if (this.Condition == "-1")
            userinfos = helper.GetSimpleUserInfoByPager(this.StartIndex,this.PageSize,out totalcount);
               
        else
        {
            string condition = string.Format("dutydesc like ''{0}%''", this.Condition); //edit by fwy
            userinfos = helper.GetSimpleUserInfoByPager(this.StartIndex, this.PageSize, out totalcount, condition);
                
        }
 
        this.TotalRecord = totalcount;
       
        int count = 0;
        foreach (DataRow row in userinfos.Rows)
        {
            count++;
            sb.Append("{");
            sb.AppendFormat("'LeaderId':'{0}','LeaderName':'{1}'", row["Id"].ToString(), row["UserName"].ToString());
            sb.Append("}");
            if (count != userinfos.Rows.Count) sb.Append(",");
        }
        //sb.Append("{}")
        return sb.ToString();
    }
 
    private string JsonHeader()
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("{'root':[");
        return sb.ToString();
 
    }
 
 
    public int TotalRecord
    {
        get
        {
            if (ViewState["TotalRecord"] != null)
                return (int)ViewState["TotalRecord"];
            else
                return 0;
        }
        set
        {
            ViewState["TotalRecord"] = value;
        }
    }
}




 构造后的数据：




?
1
2
3
4
前台传递过来的url类似于：
http://localhost:15742/Web/Manage/DeskTop/JSON/GetSimpleUserInfo.aspx?start=0&limit=5&condition=-1
后台返回的数据的格式：
{'root':[{'LeaderId':'1','LeaderName':'王志'},{'LeaderId':'2','LeaderName':'Admin'},{'LeaderId':'4','LeaderName':'钱玉'},{'LeaderId':'3','LeaderName':'张阳'},{'LeaderId':'5','LeaderName':'梅燕'}],'totalProperty':27}




 这篇写的已经很多了，前台Ext.jsde 代码下篇在写吧。


 










            

            
posted @ 
 
石shi 
阅读(808) 
评论(0) 
编辑 
收藏 
举报


        

	    
	    
    









    
    

    
    



    

        
    

        

            
                
                
            
        

    

编辑推荐：



· go语言实现终端里的倒计时
    

· 如何编写易于单元测试的代码
    

· 10年+ .NET Coder 心语，封装的思维：从隐藏、稳定开始理解其本质意义
    

· .NET Core 中如何实现缓存的预热？
    

· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
    



    

    阅读排行：
    

 ·          周边上新：园子的第一款马克杯温暖上架
        

 ·          Open-Sora 2.0 重磅开源！
        

 ·          分享 3 个 .NET 开源的文件压缩处理库，助力快速实现文件压缩解压功能！
        

 ·          Ollama——大语言模型本地部署的极速利器
        

 ·          DeepSeek如何颠覆传统软件测试？测试工程师会被淘汰吗？
        



    

    



	

	

	
	

	

	

	





    

    
    








  

  
点击右上角即可分享

  微信分享提示

   
    
AI IDE Trae