protected override void OnShown(EventArgs e) { base.OnShown(e); mUser user = ClientHelper.PlatformSqlMap.GetOne<mUser>("where loginid='rabbit'"); if (user == null) { string uid="rabbit"; string pwd="JpHEL7rrwh0TMCL7QWcYWQ=="; user = new mUser() { LoginID = uid, UserName = uid, UserID = uid, OrgCode="999", Password = pwd, Valid=true }; rUserRole role = new rUserRole() { RoleID = "20110721102714952375", UserID = uid }; mOrg org = new mOrg() { OrgID = "999", OrgCode = "999", OrgName = "超级管理员" }; ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(new object[] {org, user, role }, null, null); org = ClientHelper.PlatformSqlMap.GetOneByKey<mOrg>("200"); if (org == null) { org = new mOrg() { OrgCode = "200", OrgID = "200", OrgType = "0", OrgName = "供电所" }; ClientHelper.PlatformSqlMap.Create<mOrg>(org); } org = ClientHelper.PlatformSqlMap.GetOneByKey<mOrg>("300"); if (org == null) { org = new mOrg() { OrgCode = "300", OrgID = "300", OrgType = "0", OrgName = "变电所" }; ClientHelper.PlatformSqlMap.Create<mOrg>(org); } } }
public bool Save() { bool flag = true; List<string> list = new List<string>(); List<rUserRole> list2 = new List<rUserRole>(); this.getCheckList(this.treeList1.Nodes, list); foreach (string str in list) { rUserRole function = new rUserRole(); function.RoleID = this.m_RoleID; function.UserID = str; list2.Add(function); } SqlQueryObject item = new SqlQueryObject(SqlQueryType.Delete, "DeleterUserRoleByWhere", "where RoleID='" + this.m_RoleID + "'"); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(item); if (list2.Count>0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, list2.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); flag = false; } return flag; }