public void FillControls()
{
try
{
if (dgvlist.Rows.Count > 0)
{
List <Dept> deptlist = DeptDAL.getlist();
int empId = Convert.ToInt32(this.dgvlist[0, this.dgvlist.CurrentCell.RowIndex].Value.ToString());
Dept dept = deptlist.Find(x => x.EmpId == empId);
Employee model = EmployeeDAL.getEntryById <Employee, long>(empId);
txtEmpName.Text = model.RealName.ToString();
txtEmpLoginName.Text = string.IsNullOrEmpty(model.EmpName) ? "" : model.EmpName.ToString();
cbxsex.Text = model.Sex.ToString();
daEmpBirthday.Value = model.BirthDay;
cmbEmpDept.Text = deptlist.Find(x => x.DeptId == model.DepId).DeptName.ToString();
cmbEmpPost.Text = dept == null ? "员工" : "组长";
txtEmpPhone.Text = string.IsNullOrEmpty(model.Phone) ? "" : model.Phone.ToString();
txtAddress.Text = string.IsNullOrEmpty(model.Address) ? "" : model.Address.ToString();
txtEmpLoginPwd.Text = "******";
txtEmpLoginPwd.Enabled = false;//禁止改密码
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
/// <summary>
/// Deletes Record from Database.
/// </summary>
/// <param name="objDept">Object containing all data values.</param>
/// <returns>boolean value True if Record is deleted successfully
/// otherwise returns False.</returns>
public static bool Delete(Department objDept)
{
bool recDel;
recDel = DeptDAL.Delete(objDept.DBID);
return(recDel);
}
/// <summary>
/// Saves current Object Values into Database.
/// </summary>
/// <param name="objDept">Current Department Object.</param>
/// <returns>Boolean value True if record is saved successfully
/// otherwise returns 'False' indicating record is not saved.</returns>
public static bool Save(Department objDept, User objCurUser)
{
bool flgSave;
try
{
using (TransactionScope objTScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
if (objDept.IsEdited || objDept.IsNew)
{
if (IsDeptExist(objDept))
{
throw new Exception("Dept. Already Exists.");
}
else
{
DeptDAL.Save(objDept, objCurUser);
}
}
flgSave = true;
objTScope.Complete();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(flgSave);
}
public Department GetDepartmentsById(int id)
{
Department dept = new Department();
DeptDAL dal = new DeptDAL();
dept = dal.GetDepartmentById(id);
return(dept);
}
public List <Department> GetDepartmentsList()
{
List <Department> list = new List <Department>();
DeptDAL dal = new DeptDAL();
list = dal.GetAllDepartment();
return(list);
}
private void txtr_cDepName_ButtonCustomClick(object sender, EventArgs e)
{
IRefDAL dal = new DeptDAL(Information.UserInfo.ConnU8);
RefForm frm = new RefForm(dal);
if (frm.ShowDialog() == DialogResult.OK)
{
this.model.cDepCode = frm.rows[0]["cDepCode"].ToString();
this.txtr_cDepName.Text = frm.rows[0]["cDepName"].ToString();
}
}
private void BindDropList()
{
List <Dept> list = DeptDAL.getlist();
if (list != null && list.Count > 0)
{
cmbEmpDept.DataSource = list;
cmbEmpDept.DisplayMember = "DeptName";
cmbEmpDept.ValueMember = "DeptId";
}
}
public ActionResult GetVendorReturnList(Vendor model)
{
var list = DeptDAL.GetVendorReturnList(model);
int rows_total = 0;
if (list.Count > 0)
{
Vendor item = new Vendor();
item = list[0];//取出list中第一筆記錄即可,目的是取到總記錄數
rows_total = item.rows_total;
}
var result = new { rows = list, total = rows_total };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDeptReturnList(Dept model)
{
var list = DeptDAL.GetDeptReturnList(model);
int rows_total = 0;
if (list.Count > 0)
{
Dept item = new Dept();
item = list[0];
rows_total = item.rows_total;
}
var result = new { rows = list, total = rows_total };
return(Json(result, JsonRequestBehavior.AllowGet));
}
//public ActionResult GetDeptReturnList(Brand model)
public ActionResult GetBrandtReturnList(Brand model)
{
//int pageindex = int.Parse(Request.Form["page"].ToString());
//int pagesize = int.Parse(Request.Form["rows"].ToString());
var list = DeptDAL.GetBrandReturnList(model);
//var oBrand = list.Where(t => t.row_number >= pageindex && t.row_number <= pagesize).ToList();
//var result = new { rows = list, total = list.Count };
//return Json(result, JsonRequestBehavior.AllowGet);
//构造成Json的格式传递
//var result = new { iTotalRecords = list.Count, iTotalDisplayRecords = 10, data = list };
//var result = new { total = list.Count, rows = 10, data = list };
int rows_total = 0;
if (list.Count > 0)
{
Brand item = new Brand();
item = list[0];
rows_total = item.rows_total;
}
var result = new { total = rows_total, rows = list };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void FillControls()
{
try
{
if (dgvlist.Rows.Count > 0)
{
List <Dept> deptlist = DeptDAL.getlist();
int empId = Convert.ToInt32(this.dgvlist[0, this.dgvlist.CurrentCell.RowIndex].Value.ToString());
Dept dept = deptlist.Find(x => x.EmpId == empId);
Supplier model = EmployeeDAL.getEntryById <Supplier, long>(empId);
this.txtCompanyName.Text = model.Name.ToString();
txtCompanyDirector.Text = string.IsNullOrEmpty(model.Director) ? "" : model.Director.ToString();
txtCompanyAddress.Text = string.IsNullOrEmpty(model.Address) ? "" : model.Address.ToString();
txtTel.Text = string.IsNullOrEmpty(model.Tel) ? "" : model.Tel.ToString();
txtCompanyPhone.Text = string.IsNullOrEmpty(model.Phone) ? "" : model.Phone.ToString();
txtCompanyRemark.Text = string.IsNullOrEmpty(model.Remark) ? "" : model.Remark.ToString();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
/// <summary>
/// Checks whether current Record already exists or not.
/// </summary>
/// <param name="objDept">Object containing all Data Values.</param>
/// <returns>boolean value True if Record already Exists into Database
/// otherwise returns False.</returns>
public static bool IsDeptExist(Department objDept)
{
return(DeptDAL.IsDeptExist(objDept));
}
/// <summary>
/// Retrieves Department Detail for Specified Record.
/// </summary>
/// <param name="dbid">Unique ID for Record in Database.</param>
/// <returns>Object Department containing Data values.</returns>
public static Department GetItem(int dbid)
{
return(DeptDAL.GetItem(dbid));
}
/// <summary>
/// Retrieves List of Departments availble.
/// </summary>
/// <param name="strWhere">Condition for filtering the list.</param>
/// <returns>Collection Object DepartmentList.</returns>
public static DepartmentList GetList(string strWhere)
{
return(DeptDAL.GetList(strWhere));
}
