public repairmanTable GetEntityById(int Id)
{
SqlParameter param = new SqlParameter("@repairmanID", Id);
string strSQL = "select * from [repairmanTable] where repairmanID = @repairmanID ";
System.Data.SqlClient.SqlDataReader dr;
dr = SQLHelper.ExecuteReader(strSQL, param);
try
{
repairmanTable entity = new repairmanTable();
entity = SQLHelper.ReaderToList <repairmanTable>(dr)[0];
return(entity);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return(null);
}
finally
{
if (!dr.IsClosed)
{
dr.Close();
}
}
}
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;
}
}
}
}
public string getProjectRepairMan(int projID)
{
DataTable dt = getDetailDataTableByProjID(projID);
repairmanBLL rmBLL = new repairmanBLL();
if (dt.Rows.Count == 0)
{
return("");
}
else if (dt.Rows.Count == 1)
{
repairmanTable rm = rmBLL.getRMinfoById(Convert.ToInt32(dt.Rows[0]["repairmanID"]));
return(rm == null ? "" : rm.repairmanName);
}
else
{
List <string> rmList = dt.AsEnumerable().Select(row => row["repairmanID"].ToString()).ToList <string>();
List <string> rmNameList = new List <string>();
foreach (string rmID in rmList)
{
repairmanTable rm = rmBLL.getRMinfoById(Convert.ToInt32(rmID));
if (rm != null)
{
rmNameList.Add(rm.repairmanName);
}
}
return(string.Join(", ", rmNameList));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["CurrentRole"] == null || Session["CurrentRole"].ToString().Equals("1"))
{
return;
}
repairmanTable currentUser = new repairmanTable();
if (Session["CurrentLoginUser"] == null)
{
return;
}
else
{
currentUser = Session["CurrentLoginUser"] as repairmanTable;
hiddenRMID.Value = currentUser.repairmanID.ToString();
if (ViewState["isQuery"] == null || ViewState["isQuery"].ToString() == "false")
{
getMyProjectData(currentUser.repairmanID);
}
}
if (!IsPostBack)
{
ViewState["isQuery"] = "false";
cmb_BindData();
}
}
public repairmanTable checkLoginInfo(repairmanTable loginUser)
{
var loginFilter = Builders <repairmanTable> .Filter.Eq(rm => rm.repairmanName, loginUser.repairmanName)
& Builders <repairmanTable> .Filter.Eq(rm => rm.password, loginUser.password);
var rminfo = collection.Find(loginFilter).FirstOrDefault();
return(rminfo);
}
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 bool addNewRepairMan(string name)
{
repairmanTable entity = new repairmanTable();
entity.repairmanID = -1;
entity.repairmanName = name;
entity.password = "******";
return(dal.SaveEntity(entity) > 0);
}
public repairmanTable checkLoginInfo(repairmanTable loginUser)
{
string strSQL = " select * from repairmanTable where deleteStatus=1 and repairmanName=@repairmanName and password=@password ";
SqlParameter[] paramArr = new SqlParameter[] {
new SqlParameter("@repairmanName", loginUser.repairmanName),
new SqlParameter("@password", loginUser.password)
};
System.Data.SqlClient.SqlDataReader dr = SQLHelper.ExecuteReader(strSQL, paramArr);
IList <repairmanTable> list = SQLHelper.ReaderToList <repairmanTable>(dr);
return(list.Count > 0 ? list[0] : loginUser);
}
public repairmanTable UserLogin(string userName, string password)
{
if (userName != "" && password != "")
{
repairmanTable loginUser = new repairmanTable();
loginUser.repairmanID = -1;
loginUser.repairmanName = userName;
loginUser.password = password;
loginUser = dal.checkLoginInfo(loginUser);
if (loginUser != null && loginUser.repairmanID > -1)
{
return(loginUser);
}
}
return(new repairmanTable());
}
public int SaveEntity(repairmanTable entity)
{
List <SqlParameter> paramList = new List <SqlParameter>();
var repairmanID_parameter = new SqlParameter("@repairmanID", SqlDbType.Int);
if (entity.repairmanID > 0)
{
repairmanID_parameter.Value = entity.repairmanID;
}
else
{
repairmanID_parameter.Value = DBNull.Value;
}
SqlParameter repairmanName_parameter = new SqlParameter("@repairmanName", entity.repairmanName);
paramList.Add(repairmanName_parameter);
SqlParameter password_parameter = new SqlParameter("@password", entity.password);
paramList.Add(password_parameter);
string sql = "";
SqlParameter identityParameter = new SqlParameter("@IdentityId", SqlDbType.Int);
if ((entity.repairmanID == -1))
{
identityParameter.Direction = ParameterDirection.Output;
paramList.Add(identityParameter);
sql = "insert into repairmanTable(repairmanName,password,deleteStatus) ";
sql += "values(@repairmanName,@password,1) Select @IdentityId = @@identity ";
}
else
{
paramList.Add(repairmanID_parameter);
sql = "update repairmanTable set repairmanName = @repairmanName,password = @password where repairmanID =@repairmanID ";
}
int count = SQLHelper.ExecuteonQuery(sql, paramList.ToArray());
if (entity.repairmanID == -1 && identityParameter != null)
{
entity.repairmanID = Convert.ToInt32(identityParameter.Value);
}
return(count);
}
public int SaveEntity(repairmanTable entity)
{
if (entity.repairmanID == -1)
{
entity.repairmanID = 1 + MongoHelper.GetMaxId(collection);
entity.deleteStatus = 1;
try
{
collection.InsertOne(entity);
return(1);
}
catch (Exception)
{
return(0);
}
}
else
{
var idFilter = Builders <repairmanTable> .Filter.Eq(rm => rm.repairmanID, entity.repairmanID);
var updateResult = collection.UpdateOne(idFilter, Builders <repairmanTable> .Update.Set("repairmanName", entity.repairmanName).Set("password", entity.password));
return(updateResult.IsAcknowledged ? Convert.ToInt32(updateResult.ModifiedCount) : 0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
cmb_BindData();
setInputEnable(false);
int detailID;
if (int.TryParse(Request.QueryString["detailID"], out detailID))
{
tbDetailID.Text = detailID.ToString();
getRepairInfoByID(detailID);
}
else
{
lblWarning.Visible = true;
btnEdit.Enabled = false;
}
}
if (Session["CurrentRole"] != null)
{
if (Session["CurrentRole"].ToString() == "1")
{
btnEdit.Visible = true;
}
else
{
btnEdit.Visible = false;
if (Session["CurrentLoginUser"] != null)
{
repairmanTable currentUser = Session["CurrentLoginUser"] as repairmanTable;
btnEdit.Visible = currentUser.repairmanName.Equals(tbRepairmanID.Text.Trim());
}
}
}
}
public bool updateRMinfo(repairmanTable entity)
{
return(entity.repairmanID > 0 && dal.SaveEntity(entity) > 0);
//if (entity.repairmanID > 0) return dal.SaveEntity(entity) > 0;
//else return false;
}
