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);
}
