public employeeTable GetEntityById(int Id) { SqlParameter param = new SqlParameter("@employeeID", Id); string strSQL = "select * from [employeeTable] where employeeID = @employeeID "; System.Data.SqlClient.SqlDataReader dr; dr = SQLHelper.ExecuteReader(strSQL, param); try { employeeTable entity = new employeeTable(); entity = SQLHelper.ReaderToList <employeeTable>(dr)[0]; return(entity); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.StackTrace); return(null); } finally { if (!dr.IsClosed) { dr.Close(); } } }
private void testInsert2() { System.Diagnostics.Debug.WriteLine("----insert----"); employeeTable einfo = new employeeTable(); einfo.employeeID = -1; einfo.employeeName = "Leila"; einfo.password = "******"; System.Diagnostics.Debug.WriteLine("Success? " + eBLL.testInsert(einfo).ToString()); System.Diagnostics.Debug.WriteLine(einfo.employeeID); System.Diagnostics.Debug.WriteLine("----update----"); employeeTable eupd = new employeeTable(); eupd = eBLL.getEEinfoById(1); eupd.password = "******"; System.Diagnostics.Debug.WriteLine("Success? " + eBLL.testUpdateOne(eupd).ToString()); System.Diagnostics.Debug.WriteLine(eupd.password); System.Diagnostics.Debug.WriteLine("----update id12----"); employeeTable eupd12 = new employeeTable(); eupd12 = eBLL.getEEinfoById(12); eupd12.password = "******"; System.Diagnostics.Debug.WriteLine("Success? " + eBLL.testUpdateOne(eupd12).ToString()); System.Diagnostics.Debug.WriteLine(eupd12.password); }
protected void GridPhoto_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { GridDataItem item = e.Item as GridDataItem; Button btn = item["Delete"].Controls[0] as Button; btn.Enabled = isEditable; int roleId, userId; if (int.TryParse(item["roleID"].Text, out roleId) && int.TryParse(item["userID"].Text, out userId)) { if (roleId == 1) { item["roleID"].Text = "管理员"; employeeTable ee = eeBLL.getEEinfoById(userId); item["userID"].Text = ee.employeeName; } else { item["roleID"].Text = "维修人员"; repairmanTable rm = rmBLL.getRMinfoById(userId); item["userID"].Text = rm.repairmanName; } } } }
protected void Page_Load(object sender, EventArgs e) { UserRole = -1; if (Session["CurrentRole"] != null) { RadMenu1.Items.Clear(); UserRole = Convert.ToInt32(Session["CurrentRole"]); if (UserRole == 0) // 维修人员 { RadMenuItem item1 = new RadMenuItem("我的项目", "./ManageSystem/MyRepairProject.aspx"); RadMenu1.Items.Add(item1); } else // 管理员 { RadMenuItem[] items = new RadMenuItem[] { new RadMenuItem("待分配项目", "./ManageSystem/AssignProject.aspx?Status=0"), new RadMenuItem("已分配项目", "./ManageSystem/AssignProject.aspx?Status=1"), new RadMenuItem("待跟进项目", "./ManageSystem/RepairProject.aspx?Status=2"), new RadMenuItem("已完成项目", "./ManageSystem/RepairProject.aspx?Status=3"), new RadMenuItem("维修人员管理", "./ManageSystem/RepairMan.aspx") }; RadMenu1.Items.AddRange(items); } } if (UserRole > -1 && Session["CurrentLoginUser"] != null) { if (UserRole == 0) { currentRepairMan = Session["CurrentLoginUser"] as repairmanTable; UserName = currentRepairMan.repairmanName; } else { currentEmployee = Session["CurrentLoginUser"] as employeeTable; UserName = currentEmployee.employeeName; } lblWelcome.Text = string.Format("您好, <br /> {0} {1}.", (UserRole == 0 ? "维修员" : "管理员"), UserName); } string pagename = ContentPlaceHolder1.Page.GetType().ToString().ToLower(); string redirectURL = "alert('此页面无权限访问。'); window.location.href='./Login.aspx';"; if (pagename.Contains("MyRepairProject".ToLower())) //ASP.managesystem_myrepairproject_aspx { if (UserRole != 0) { ContentPlaceHolder1.Page.ClientScript.RegisterClientScriptBlock(GetType(), "ToLogin", redirectURL, true); } } else { if (UserRole != 1) { ContentPlaceHolder1.Page.ClientScript.RegisterClientScriptBlock(GetType(), "ToLogin", redirectURL, true); } } }
public employeeTable checkLoginInfo(employeeTable loginUser) { var loginFilter = Builders <employeeTable> .Filter.Eq(e => e.employeeName, loginUser.employeeName) & Builders <employeeTable> .Filter.Eq(e => e.password, loginUser.password); var einfo = collection.Find(loginFilter).FirstOrDefault(); return(einfo); }
public bool testUpdateOne(employeeTable entity) { if (entity.employeeID > 0) { return(dal.SaveEntity(entity) > 0); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { employeeTable Antonio = eBLL.getEEinfoById(1); if (Antonio.employeeID == 0) { testInsert(); } } }
public employeeTable getEEinfoById(int id) { employeeTable e = dal.GetEntityById(id); if (e != null) { return(e); } else { return(new employeeTable()); } }
public employeeTable checkLoginInfo(employeeTable loginUser) { string strSQL = " select * from employeeTable where deleteStatus=1 and employeeName=@employeeName and password=@password "; SqlParameter[] paramArr = new SqlParameter[] { new SqlParameter("@employeeName", loginUser.employeeName), new SqlParameter("@password", loginUser.password) }; System.Data.SqlClient.SqlDataReader dr = SQLHelper.ExecuteReader(strSQL, paramArr); IList <employeeTable> list = SQLHelper.ReaderToList <employeeTable>(dr); return(list.Count > 0 ? list[0] : loginUser); }
private void testInsert() { employeeTable einfo = new employeeTable(); einfo.employeeID = -1; einfo.employeeName = "Antonio"; einfo.password = "******"; System.Diagnostics.Debug.WriteLine("----insert----"); System.Diagnostics.Debug.WriteLine("Success? " + eBLL.testInsert(einfo).ToString()); if (einfo.employeeID != 1) { RadAjaxManager1.Alert("Antonio needs to be updated."); } }
public employeeTable UserLogin(string userName, string password) { if (userName != "" && password != "") { employeeTable loginUser = new employeeTable(); loginUser.employeeID = -1; loginUser.employeeName = userName; loginUser.password = password; loginUser = dal.checkLoginInfo(loginUser); if (loginUser != null && loginUser.employeeID > -1) { return(loginUser); } } return(new employeeTable()); }
public int SaveEntity(employeeTable entity) { //var client = new MongoClient("mongodb://121.41.24.118:27017"); //var database = client.GetDatabase("test0520"); //var collection = database.GetCollection<employeeTable>("employee"); // insert if (entity.employeeID == -1) { entity.employeeID = 1 + MongoHelper.GetMaxId(collection); entity.deleteStatus = 1; try { collection.InsertOneAsync(entity); return(1); } catch (Exception) { return(0); } } else // update { var idFilter = Builders <employeeTable> .Filter.Eq(e => e.employeeID, entity.employeeID); var oldInfo = collection.Find(idFilter).FirstOrDefault(); if (oldInfo == null) { return(0); } else { try { var updateResult = collection.UpdateOne(idFilter, Builders <employeeTable> .Update.Set("employeeName", entity.employeeName) .Set("password", entity.password) .Set("deleteStatus", entity.deleteStatus)); return(Convert.ToInt32(updateResult.IsAcknowledged && updateResult.ModifiedCount > 0)); } catch (Exception) { return(0); } } } }
public int SaveEntity(employeeTable entity) { List <SqlParameter> paramList = new List <SqlParameter>(); var employeeID_parameter = new SqlParameter("@employeeID", SqlDbType.Int); if (entity.employeeID > 0) { employeeID_parameter.Value = entity.employeeID; } else { employeeID_parameter.Value = DBNull.Value; } SqlParameter employeeName_parameter = new SqlParameter("@employeeName", entity.employeeName); paramList.Add(employeeName_parameter); SqlParameter password_parameter = new SqlParameter("@password", entity.password); paramList.Add(password_parameter); string sql = ""; SqlParameter identityParameter = new SqlParameter("@IdentityId", SqlDbType.Int); if (entity.employeeID == -1) { identityParameter.Direction = ParameterDirection.Output; paramList.Add(identityParameter); sql = "insert into employeeTable(employeeName,password,deleteStatus) "; sql += "values(@employeeName,@password,1) Select @IdentityId = @@identity "; } else { paramList.Add(employeeID_parameter); sql = "update employeeTable set employeeName = @employeeName,password = @password where employeeID =@employeeID "; } int count = SQLHelper.ExecuteonQuery(sql, paramList.ToArray()); if (entity.employeeID == -1 && identityParameter != null) { entity.employeeID = Convert.ToInt32(identityParameter.Value); } return(count); }
public int testInsert(employeeTable e) { return(dal.SaveEntity(e)); }
private void testGetOne() { int eid = 12; employeeTable einfo = eBLL.getEEinfoById(eid); }