/// <summary> /// Load data /// </summary> private void LoadData() { id = Request["id"]; hidID.Value = id; BD_StaffEvalInfoData data = new BD_StaffEvalInfoData(); ITransaction tran = factory.GetLoadObject(data, id); Execute(tran); if (!HasError) { //Get Data data = (BD_StaffEvalInfoData)tran.Result; txtContentEval.Text = data.ContentEval; txtEvalDate.Text = Func.FormatDMY(data.EvalDate); txtComment.Text = data.Comment; BD_StaffData dataS = new BD_StaffData(); ITransaction tranS = factory.GetLoadObject(dataS, data.StaffId); Execute(tranS); if (!HasError) { //Get Data dataS = (BD_StaffData)tranS.Result; lblStaffId.Text = dataS.StaffId; lblName.Text = dataS.Name; } } }
/// <summary> /// Load data /// </summary> private void LoadData() { BD_StaffData data = new BD_StaffData(); ITransaction tran = factory.GetLoadObject(data, id); Execute(tran); if (!HasError) { //Get Data data = (BD_StaffData)tran.Result; lblStaffId.Text = data.StaffId; lblName.Text = data.Name; } ShowData(); }
/// <summary> /// Load data /// </summary> private void LoadData() { BD_StaffData data = new BD_StaffData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_StaffData)tran.Result; txtStaffId.Text = data.StaffId; txtName.Text = data.Name; txtComment.Text = data.Comment; txtPhone.Text = data.Phone; txtAddress.Text = data.Address; txtMail.Text = data.Mail; txtJobBegin.Text = data.JobBegin; txtJobEnd.Text = !"".Equals(data.JobEnd) ? Func.Formatdmyhms(data.JobEnd) : ""; txtJobBegin.Text = Func.FormatDMY(data.JobBegin); txtJobEnd.Text = Func.FormatDMY(data.JobEnd); DbHelper.FillList(drpPosition, "Select * from Mst_Position Where Jobtype = '" + data.JobTypeId + "'", "Position", "id"); DbHelper.FillListSearch(drpWorkingPlace, "Select WorkingPlaceId + '('+ Name +')' As Name, ID from BD_WorkingPlace Where JobTypeId = '" + data.JobTypeId + "' and BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "' and DelFlag = 0", "Name", "id"); drpWorkingPlace.SelectedValue = data.WorkingPlaceId; drpPosition.SelectedValue = data.Position; txtJobContent.Text = data.JobContent; chkDelFlag.Checked = "1".Equals(data.DelFlag) ? false : true; lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : ""; lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : ""; } }
/// <summary> /// Update /// </summary> private void UpdateData() { BD_StaffData data = new BD_StaffData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (BD_StaffData)tran.Result; data.Name = txtName.Text.Trim(); data.Comment = txtComment.Text.Trim(); data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1"; data.Phone = txtPhone.Text; data.Address = txtAddress.Text; data.Mail = txtMail.Text; data.JobBegin = !"".Equals(txtJobBegin.Text) ? Func.FormatYYYYmmdd(txtJobBegin.Text) : ""; data.JobEnd = !"".Equals(txtJobEnd.Text) ? Func.FormatYYYYmmdd(txtJobEnd.Text) : ""; data.Position = drpPosition.SelectedValue; data.WorkingPlaceId = drpWorkingPlace.SelectedValue; data.JobContent = txtJobContent.Text; tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(updateSuccess); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true); lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : ""; lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : ""; } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name); mvMessage.AddError(updateUnSuccess); } } }
/// <summary> /// Insert data /// </summary> private void InsertData() { //Get and Insert Data BD_StaffData data = new BD_StaffData(); ITransaction tran = factory.GetInsertObject(data); data.Name = txtName.Text.Trim(); data.Comment = txtComment.Text.Trim(); data.ModifiedBy = Page.User.Identity.Name; data.CreatedBy = Page.User.Identity.Name; data.Created = DateTime.Now.ToString("yyyyMMddHHmmss"); data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1"; data.JobContent = txtJobContent.Text; data.Phone = txtPhone.Text; data.Address = txtAddress.Text; data.Mail = txtMail.Text; data.JobBegin = !"".Equals(txtJobBegin.Text) ? Func.FormatYYYYmmdd(txtJobBegin.Text) : ""; data.JobEnd = !"".Equals(txtJobEnd.Text) ? Func.FormatYYYYmmdd(txtJobEnd.Text) : ""; data.JobTypeId = hidJobType.Value; data.Position = drpPosition.SelectedValue; data.WorkingPlaceId = drpWorkingPlace.SelectedValue; data.BuildingId = Func.ParseString(Session["__BUILDINGID__"]); data.StaffId = txtStaffId.Text; Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true); btnRegister.CommandName = "Register"; hidAction.Value = "Edit"; txtStaffId.Enabled = false; hidId.Value = data.id; lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : ""; lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : ""; } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } }