public void AccesstoUIFunctinality()
{
ConfigurationButton.Enabled = false;
QualityControlButton.Enabled = false;
ExportButton.Enabled = false;
StatusChangeButton.Enabled = false;
VFRSearchButton.Enabled = false;
BatchRegistrationButton.Enabled = false;
// Get User Information to control Accesst to Functionality
if (Environment.UserName.ToUpper() == "ADMINISTRATOR")
{
ConfigurationButton.Enabled = true;
QualityControlButton.Enabled = true;
ExportButton.Enabled = true;
StatusChangeButton.Enabled = true;
VFRSearchButton.Enabled = true;
BatchRegistrationButton.Enabled = true;
}
else
{
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
resultUsers = DBTransactions.GetUserByName(Environment.UserName);
users = resultUsers.ReturnValue;
foreach (UIFunctionality functionality in users[0].UIFunctionality)
{
switch (functionality.Description)
{
case "System Configuration":
ConfigurationButton.Enabled = true;
break;
case "Quality Control":
QualityControlButton.Enabled = true;
break;
case "Export":
ExportButton.Enabled = true;
break;
case "Batch Administration":
StatusChangeButton.Enabled = true;
break;
case "VFR Search":
VFRSearchButton.Enabled = true;
break;
case "Batch Registration":
BatchRegistrationButton.Enabled = true;
break;
}
}
}
}
public ResultUsers LoginUser(User inUser)
{
// 3. send the input down to the database and check username/password
// 3.d create a user operations dal object
UserOperationsDAL _userOperationsDAL = new UserOperationsDAL(this._connection);
// 3.e need a method that takes a User object and return a Result object
ResultUsers _result = _userOperationsDAL.LoginUserToDatabase(inUser);
// 3.f return the Result
return(_result);
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ResultUsers GetUserList(QueryUserContact query)
{
ExecuteResult resultInfo = new ExecuteResult();
try
{
ResultUsers resultUsers = new ResultUsers();
resultUsers.Page = new Padding();
resultUsers.UserList = new List <User>();
var result = userOperator.GetUserList(" order by id desc");
if (result.Count > 0)
{
resultUsers.Page.Current = query.PageCurrent;
resultUsers.Page.Total = result.Count;
resultUsers.UserList = result.Select(p =>
new Model.User
{
GroupId = p.GroupId,
GroupName = userOperator.GetUserGroupName(int.Parse(p.GroupId)),
Id = p.Id,
PassWord = p.PassWord,
Status = p.Status,
UserName = p.Name
}).Skip((query.PageCurrent - 1) * query.PageSize).Take(query.PageSize).ToList();
resultInfo.Success = true;
resultInfo.ExceptionMsg = string.Empty;
resultUsers.ResultInfo = resultInfo;
return(resultUsers);
}
else
{
resultInfo.Success = false;
resultInfo.ExceptionMsg = "暂无数据！";
return(new ResultUsers {
ResultInfo = resultInfo
});
}
}
catch (Exception ex)
{
resultInfo.Success = false;
resultInfo.ExceptionMsg = ex.Message;
return(new ResultUsers {
ResultInfo = resultInfo
});
}
}
private void FormLoad()
{
UserNameTextBox.Text = "";
UserEmailTextBox.Text = "";
ActiveCheckBox.Checked = false;
UserTitleTextBox.Text = "";
UsersListView.Items.Clear();
AvaliableFunctionalityListView.Items.Clear();
ResultUIFunctionalities uiFunctionalities = new ResultUIFunctionalities();
uiFunctionalities = DBTransactions.GetUIFunctionalities();
foreach (UIFunctionality uiFunctionality in uiFunctionalities.ReturnValue)
{
ListViewItem item = new ListViewItem(new string[] { "", Convert.ToString(uiFunctionality.FunctionalityID), uiFunctionality.Description });
item.Tag = uiFunctionality.FunctionalityID;
AvaliableFunctionalityListView.Items.Add(item);
}
AvaliableFunctionalityListView.Columns[1].Width = 0;
// Load User List View
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
resultUsers = DBTransactions.GetUsers();
users = resultUsers.ReturnValue;
string functionalities = "";
foreach (User user in users)
{
if (user.UIFunctionality.Count > 0)
{
List <int> functionalityList = new List <int>();
foreach (UIFunctionality functionality in user.UIFunctionality)
{
functionalityList.Add(functionality.FunctionalityID);
}
functionalities = String.Join(", ", functionalityList.ToArray());
}
else
{
functionalities = "";
}
ListViewItem item = new ListViewItem(new string[] { Convert.ToString(user.UserID), Convert.ToString(user.ActiveFlag), user.UserName, user.Title, user.Email, functionalities });
UsersListView.Items.Add(item);
}
}
private void ApplyButton_Click(object sender, EventArgs e)
{
ResultBatches resultBatches = new ResultBatches();
ResultGeneric resultGeneric = new ResultGeneric();
string originalBatchStatus = "";
Batch batch = new Batch();
DialogResult result = DialogResult.No;
string action = "";
DateTime currentDate = DateTime.Now;
ResultUsers resultUsers = new ResultUsers();
List <User> users = new List <User>();
Boolean allowDeletion = false;
Boolean allowRecall = false;
Boolean allowRejection = false;
try
{
// Get User Information to control Accesst to Functionality
resultUsers = DBTransactions.GetUserByName(Environment.UserName);
users = resultUsers.ReturnValue;
foreach (UIFunctionality functionality in users[0].UIFunctionality)
{
switch (functionality.Description)
{
case "Batch Rejection":
allowRejection = true;
break;
case "Batch Recall":
allowRecall = true;
break;
case "Batch Removal":
allowDeletion = true;
break;
}
}
nlogger.Trace(" QC Transaction (Apply Action) for Batch: " + BatchNameTextBox.Text);
resultBatches = DBTransactions.GetBatchesInformation("BatchNumber = \"" + BatchNameTextBox.Text + "\"", ""); // OR BatchAlias = \"" + BatchNumber.Text + "\"", "");
batch = resultBatches.ReturnValue[0];
originalBatchStatus = batch.StatusFlag;
if (RejectedRadioButton.Checked)
{
action = "Rejected";
}
if (RecallRadioButton.Checked)
{
action = "Recall";
}
if (DeleteRadioButton.Checked)
{
action = "Delete";
}
switch (action)
{
case "Rejected":
if (allowRejection)
{
result = MessageBox.Show(this, "Do you want to Reject this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
batch.RejectedBy = OperatorTextBox.Text;
batch.RejectionReason = RejectCommentsTextBox.Text;
batch.LastTimeRejected = currentDate;
batch.RejectedTimes = batch.RejectedTimes + 1;
batch.StatusFlag = "Rejected";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Rejected", "Batch Rejected", OperatorTextBox.Text);
}
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
case "Recall":
if (allowRecall)
{
result = MessageBox.Show(this, "Do you want to request a Recall this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
batch.RecallBy = OperatorTextBox.Text;
batch.RecallReason = RecallCommentsTextBox.Text;
batch.RecallDate = currentDate;
batch.RecallTimes = batch.RecallTimes + 1;
batch.StatusFlag = "Recall";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Recall", "Batch tagged for Recall", OperatorTextBox.Text);
}
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
case "Delete":
if (allowDeletion)
{
result = MessageBox.Show(this, "Do you want to Delete this Batch : " + BatchNameTextBox.Text + " ?", "Confirmation...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
// Tag Batch for deletion
batch.StatusFlag = "Waiting for Deletion";
// Update Batch Information
nlogger.Trace(" Updating Batch information in Database ...");
resultGeneric = DBTransactions.BatchUpdate(batch);
if (resultGeneric.ReturnCode == 0)
{
// Batch Event Tracking
nlogger.Trace(" Adding transaction in Tracking Database Table ...");
DBTransactions.BatchTrackingEvent(batch.BatchNumber, originalBatchStatus, "Waiting for Deletion", "Batch tagged for Deletion", OperatorTextBox.Text);
}
MessageBox.Show(this, "This operation is under Construction", "Alert...", MessageBoxButtons.YesNo, MessageBoxIcon.Hand);
}
}
else
{
result = MessageBox.Show(this, "You are not auhorized to perform this operation.", "Information ...", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
break;
}
ResetValues();
DisableButtons();
DisableOptions();
ExitButton.Enabled = true;
}
catch (Exception ex)
{
General.ErrorMessage(ex);
}
}
