/// <summary> /// Update /// </summary> private void UpdateData() { Mst_BuildingData data = new Mst_BuildingData(); ITransaction tran = factory.GetLoadObject(data, txtBuildingId.Text.Trim()); Execute(tran); if (!HasError) { //Get Data data = (Mst_BuildingData)tran.Result; data.BuildingId = txtBuildingId.Text.Trim(); data.Name = txtName.Text.Trim(); data.Investor = txtInvestor.Text.Trim(); data.Address = txtAddress.Text.Trim(); data.Phone = txtPhone.Text.Trim(); data.Owner = txtOwner.Text.Trim(); data.ManagerCompany = txtManagerCompany.Text.Trim(); data.ManagerCompanyAgent = txtManagerCompanyAgent.Text.Trim(); data.ManagerCompanyPhone = txtManagerCompanyPhone.Text.Trim(); data.Comment = txtComment.Text.Trim(); data.Bank = txtBank.Text.Trim(); data.Account = txtAccount.Text.Trim(); data.AccountName = txtAccountName.Text.Trim(); data.Office = txtOffice.Text.Trim(); data.OfficePhone = txtOfficePhone.Text.Trim(); data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); data.DelFlag = true.Equals(chkDelFlag.Checked) ? "0" : "1"; 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> /// Load data /// </summary> private void LoadData() { Mst_BuildingData data = new Mst_BuildingData(); ITransaction tran = factory.GetLoadObject(data, txtBuildingId.Text.Trim()); Execute(tran); if (!HasError) { //Get Data data = (Mst_BuildingData)tran.Result; txtName.Text = data.Name; txtComment.Text = data.Comment; chkDelFlag.Checked = "1".Equals(data.DelFlag) ? false : true; txtBuildingId.Text = data.BuildingId; txtName.Text = data.Name; txtInvestor.Text = data.Investor; txtAddress.Text = data.Address; txtPhone.Text = data.Phone; txtOwner.Text = data.Owner; txtManagerCompany.Text = data.ManagerCompany; txtManagerCompanyAgent.Text = data.ManagerCompanyAgent; txtManagerCompanyPhone.Text = data.ManagerCompanyPhone; txtBank.Text = data.Bank; txtAccount.Text = data.Account; txtAccountName.Text = data.AccountName; txtOffice.Text = data.Office; txtOfficePhone.Text = data.OfficePhone; lblCreated.Text = !"".Equals(data.Created) ? data.CreatedBy + "(" + Func.Formatdmyhms(data.Created) + ")" : ""; lblModified.Text = !"".Equals(data.Modified) ? data.ModifiedBy + "(" + Func.Formatdmyhms(data.Modified) + ")" : ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PopupWidth = 850; PopupHeight = 450; ShowData(); Mst_BuildingData data = new Mst_BuildingData(); ITransaction tran = factory.GetLoadObject(data, Func.ParseString(Session["__BUILDINGID__"])); Execute(tran); if (!HasError) { //Get Data data = (Mst_BuildingData)tran.Result; lblName.Text = data.Name; lblComment.Text = data.Comment; lblBuildingId.Text = data.BuildingId; lblName.Text = data.Name; lblInvestor.Text = data.Investor; lblAddress.Text = data.Address; lblPhone.Text = data.Phone; lblOwner.Text = data.Owner; lblManagerCompany.Text = data.ManagerCompany; lblManagerCompanyAgent.Text = data.ManagerCompanyAgent; lblManagerCompanyPhone.Text = data.ManagerCompanyPhone; } } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAutoId_Click(object sender, EventArgs e) { Mst_BuildingData data = new Mst_BuildingData(); string prefix = "BD"; int length = 5; string tmp = String.Format("", length); string sql = "SELECT max(maxid) from (SELECT SUBSTRING(BuildingId, " + (prefix.Length + 1) + ", " + length + ") as maxid FROM Mst_Building) as tmp WHERE maxid < '100'"; int key = 0; try { key = Convert.ToInt32(DbHelper.GetScalar(sql)); key++; } catch { key = 1; } bool keyFlg = true; while (keyFlg) { string tmpKey = prefix + key.ToString().PadLeft(length - prefix.Length, '0'); sql = "SELECT count(*) from Mst_Building WHERE BuildingId = '" + tmpKey + "'"; if (Convert.ToInt32(DbHelper.GetScalar(sql)) != 1) { keyFlg = false; } else { key--; } } txtAutoId.Text = prefix + key.ToString().PadLeft(length - prefix.Length, '0'); }
protected void Page_Load(object sender, EventArgs e) { hidId.Value = Func.ParseString(Request["id"]); hidYearMonth.Value = Func.ParseString(Request["yearmonth"]); if (!IsPostBack) { txtCustomerId.Text = hidId.Value; hidBillId.Value = DbHelper.GetScalar("Select id from PaymentBillInfo where customerid = '" + hidId.Value + "' and YearMonth = '" + hidYearMonth.Value + "' and BuildingId= '" + Func.ParseString(Session["__BUILDINGID__"]) + "'"); if (Func.ParseInt(hidBillId.Value) > 0) { PaymentBillInfoData data = new PaymentBillInfoData(); ITransaction tran = factory.GetLoadObject(data, hidBillId.Value); Execute(tran); if (!HasError) { data = (PaymentBillInfoData)tran.Result; txtName.Text = data.Name; txtContactName.Text = data.ContactName; txtBank.Text = data.Bank; txtAccount.Text = data.Account; txtAccountName.Text = data.AccountName; txtOffice.Text = data.Office; txtOfficePhone.Text = data.OfficePhone; txtBillDate.Text = data.BillDate; txtUsdExchangeDate.Text = Func.FormatDMY(data.UsdExchangeDate); txtUsdExchange.Text = data.UsdExchange; } } if (String.IsNullOrEmpty(hidBillId.Value)) { CustomerData data = new CustomerData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (CustomerData)tran.Result; txtCustomerId.Text = data.CustomerId; txtName.Text = data.Name; //txtComment.Text = data.Comment; txtContactName.Text = data.ContactName; } Mst_BuildingData dataB = new Mst_BuildingData(); ITransaction tranB = factory.GetLoadObject(dataB, Func.ParseString(Session["__BUILDINGID__"])); Execute(tranB); if (!HasError) { //Get Data dataB = (Mst_BuildingData)tranB.Result; txtBank.Text = dataB.Bank; txtAccount.Text = dataB.Account; txtAccountName.Text = dataB.AccountName; txtOffice.Text = dataB.Office; txtOfficePhone.Text = dataB.OfficePhone; } } } }