public void setdepartment()
{
DBFunctions db = new DBFunctions();
DeptList.DataSource = db.getalldepartments();
DeptList.DataTextField = "Department";
DeptList.DataValueField = "ID";
DeptList.DataBind();
}
protected void populateDeptList()
{
string getDeptsQuery = DataProvider.DiscDeptWard.getDepartments();
DataTable dt = HospitalClass.getDataTable(getDeptsQuery);
DeptList.DataSource = dt;
DeptList.DataTextField = "DEPT_NAME";
DeptList.DataBind();
DeptList.Items.Insert(0, new ListItem("Please select..."));
}
/// <summary>
/// 根据部门ID取得部部门名字
/// </summary>
/// <param name="DeptId"></param>
/// <returns></returns>
public string GetDeptName(long DeptId)
{
var re = DeptList.SingleOrDefault(p => p.DeptID == DeptId);
if (re != null)
{
return(re.DeptName);
}
return("");
}
private void LoadDept()
{
DeptList.Clear();
foreach (var model in SharedPreference.Instance.DeptList)
{
DeptList.Add(model);
Title = "DEPT";
}
var list = DeptList.OrderBy(p => p.DEPT_CODE);
DeptList = new ObservableCollection <DeptModel>(list);
}
private void PopulateDropdown()
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["developmentserver"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand fetchCommand = new SqlCommand("Select * from DEPT", conn);
SqlDataReader reader = fetchCommand.ExecuteReader();
DeptList.DataSource = reader;
DeptList.DataTextField = "DNAME";
DeptList.DataValueField = "DEPTNO";
DeptList.DataBind();
PopulateGrid(this, null);
}
/// <summary>
/// 取得本社團之科系限制
/// </summary>
private void GetDept()
{
if (!string.IsNullOrEmpty(_ClubObj.DeptRestrict))
{
FISCA.DSAUtil.DSXmlHelper dsx = new FISCA.DSAUtil.DSXmlHelper();
dsx.Load(_ClubObj.DeptRestrict);
foreach (System.Xml.XmlElement xml in dsx.BaseElement.SelectNodes("Dept"))
{
if (!DeptList.Contains(xml.InnerText))
{
DeptList.Add(xml.InnerText);
}
}
}
}
protected void deptdatafilter()
{
if (EntiyList.SelectedValue != null && EntiyList.SelectedIndex != 0)
{
DeptList.Enabled = true;
Edit_Entity_btn.Enabled = true;
DeptList.DataSource = deptds(Convert.ToInt16(EntiyList.SelectedValue.ToString()));
DeptList.DataValueField = "ID";
DeptList.DataTextField = "Department Name";
DeptList.DataBind();
DeptList.Items.Insert(0, "Select the Department");
}
else
{
DeptList.Enabled = false;
Edit_Entity_btn.Enabled = false;
}
}
private void btnListDept_Click(object sender, EventArgs e)
{
DepartmentRepository repository = new DepartmentRepository();
List <Department> departments = repository.GetDepartments().ToList();
if (departments.Count == 0)
{
MessageBox.Show("No Records To Display.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ReportDocument report = new DeptList();
report.SetDataSource(departments);
report.SetParameterValue("@Company", Properties.Settings.Default.COMPANYNAME.ToUpper());
report.SetParameterValue("@Branch", Properties.Settings.Default.BRANCHNAME.ToUpper());
report.SetParameterValue("@Username", Properties.Settings.Default.USERNAME.ToUpper());
Form form = new frmPrint(report);
form.Text = "Department Master List";
form.Show();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (LastADEntities b = new LastADEntities())
{
//To generate data for DropDownList1
var itemcat = (from ic in b.ItemCategories select ic.CategoryName).ToList();
itemcat.Insert(0, "---Select---");
//DropDownList1.SelectedIndex = 0;
DropDownList1.DataSource = itemcat;
DropDownList1.DataBind();
//To generate the options for departments
var depts = from dept in b.Departments select dept.DepartmentName;
DeptList.DataSource = depts.ToArray();
DeptList.DataBind();
DeptList.Items.Remove(DeptList.Items.FindByText("Stationary Store Dept"));
}
}
}
/// <summary>
/// 设置部门
/// </summary>
/// <param name="depts"></param>
public void SetDept(List <Dept> depts)
{
DeptList.Clear();
depts.ForEach(p => DeptList.Add(p));
}
