private void SetSmartTags()
{
string[] orderBy = new string[] { "Priority" };
var smartTagList = SmartTag4StaffEx.GetListOrderBy(orderBy, true);
SmartTagHelper oTag = new SmartTagHelper(this);
oTag.StaffSmartTagList = smartTagList;
oTag.SetSmartTags();
}
private bool IsValid()
{
bool result = true;
#region Tag Code 唔可以吉
errorProvider.SetError(txtTagCode, string.Empty);
if (txtTagCode.Text.Length == 0)
{
errorProvider.SetError(txtTagCode, "Cannot be blank!");
return(false);
}
#endregion
#region 新增，要 check Tag Code 係咪 in use
errorProvider.SetError(txtTagCode, string.Empty);
if (_SmartTagId == Guid.Empty && SmartTag4StaffEx.IsTagCodeInUse(txtTagCode.Text.Trim()))
{
errorProvider.SetError(txtTagCode, "Tag Code in use");
return(false);
}
#endregion
return(result);
}
private void Delete()
{
var result = SmartTag4StaffEx.DeleteOptionsToo(_SmartTagId);
MessageBox.Show(result ? "Record Removed" : "Can't Delete Record...", "Delete Result");
}
private void btnFind_Click(object sender, EventArgs e)
{
string whereClause = string.Empty;
EF6.Staff staff = null;
if (!txtStaff.Text.Trim().Equals("*"))
{
staff = StaffEx.GetByStaffNumber(txtStaff.Text.Trim());
}
var smartTag4Staff = SmartTag4StaffEx.GetByTagCode("HKID");
if (!txtHKID.Text.Trim().Equals("*"))
{
if (smartTag4Staff != null)
{
if (staff != null)
{
whereClause = " StaffId = '" + staff.StaffId.ToString() + "' AND TagId = '" + smartTag4Staff.TagId.ToString() + "' AND SmartTagValue = '" + txtHKID.Text.Trim() + "'";
}
else
{
whereClause = " TagId = '" + smartTag4Staff.TagId.ToString() + "' AND SmartTagValue = '" + txtHKID.Text.Trim() + "'";
}
}
}
else
{
if (smartTag4Staff != null)
{
if (staff != null)
{
whereClause = " StaffId = '" + staff.StaffId.ToString() + "' AND TagId = '" + smartTag4Staff.TagId.ToString() + "'";
}
else
{
whereClause = " TagId = '" + smartTag4Staff.TagId.ToString() + "'";
}
}
}
using (var ctx = new EF6.RT2020Entities())
{
var list = ctx.StaffSmartTag.SqlQuery(
String.Format(
"Select * from StaffSmartTag Where {0}",
String.IsNullOrEmpty(whereClause) ? "1 = 1" : whereClause
))
.AsNoTracking()
.ToList();
if (list.Count > 0)
{
int iCount = 1;
foreach (var item in list)
{
ListViewItem objItem = this.lvStaffList.Items.Add(iCount.ToString());
if (staff == null)
{
var sta = StaffEx.GetByStaffId(item.StaffId);
if (sta != null)
{
objItem.SubItems.Add(sta.StaffNumber);
}
}
else
{
objItem.SubItems.Add(txtStaff.Text.Trim());
}
objItem.SubItems.Add(item.SmartTagValue);
iCount++;
}
}
}
}