/// <summary> /// 绑定原数据 /// </summary> void BindData() { DataTable dt = DBHelper.GetTable("", "tb_bill_receivable", "*", string.Format("payable_single_id='{0}'", orderID), "", ""); if (dt == null || dt.Rows.Count == 0) { return; } DataRow dr = dt.Rows[0]; if (windowStatus != WindowStatus.Copy) { txtOrderNum.Caption = CommonCtrl.IsNullToString(dr["order_num"]); } if (dr["order_date"] != null && dr["order_date"] != DBNull.Value) { dtpOrderDate.Value = Common.UtcLongToLocalDateTime(Convert.ToInt64(dr["order_date"])); } txtOrderStatus.Caption = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), dr["order_status"]); txtcCustName.Text = CommonCtrl.IsNullToString(dr["cust_name"]); txtcCustName.Tag = dr["cust_id"]; cust_code = CommonCtrl.IsNullToString(dr["cust_code"]); txtRemark.Caption = CommonCtrl.IsNullToString(dr["remark"]); cboOrderType.SelectedValue = Convert.ToInt32(dr["payment_type"]); txtAdvance.Caption = CommonCtrl.IsNullToString(dr["payment_money"]); txtBalance.Caption = CommonCtrl.IsNullToString(dr["dealings_balance"]); txtBankOfDeposit.Caption = CommonCtrl.IsNullToString(dr["bank_of_deposit"]); txtBankAccount.Caption = CommonCtrl.IsNullToString(dr["bank_account"]); cboOrgId.SelectedValue = dr["org_id"]; cboHandle.SelectedValue = dr["handle"]; if (windowStatus == WindowStatus.Copy) { lblCreateBy.Text = GlobalStaticObj.UserName; lblCreateTime.Text = DateTime.Now.ToString(); lblUpdateBy.Text = string.Empty; lblUpdateTime.Text = string.Empty; } else if (windowStatus == WindowStatus.Edit || windowStatus == WindowStatus.View) { lblCreateBy.Text = CommonCtrl.IsNullToString(dr["create_name"]); string createTime = CommonCtrl.IsNullToString(dr["create_time"]); if (createTime.Length > 0) { lblCreateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(createTime)).ToString(); } lblUpdateBy.Text = CommonCtrl.IsNullToString(dr["update_name"]); string updateTime = CommonCtrl.IsNullToString(dr["update_time"]); if (updateTime.Length > 0) { lblUpdateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(updateTime)).ToString(); } else { lblUpdateTime.Text = string.Empty; } } //复制或编辑,计算预收/付金额和往来余额 if (windowStatus == WindowStatus.Copy || windowStatus == WindowStatus.Edit) { string custID = CommonCtrl.IsNullToString(dr["cust_id"]);//往来单位 txtAdvance.Caption = DBOperation.GetAdvance(custID, orderType).ToString(); if (orderType == DataSources.EnumOrderType.RECEIVABLE) { txtBalance.Caption = DBOperation.GetReceivable(custID).ToString(); } else { txtBalance.Caption = DBOperation.GetPayable(custID).ToString(); } } string auditStatus = CommonCtrl.IsNullToString(dr["order_status"]); DataSources.EnumAuditStatus enumAuditStatus = DataSources.EnumAuditStatus.DRAFT; if (auditStatus != "" && windowStatus != WindowStatus.Copy) { enumAuditStatus = (DataSources.EnumAuditStatus)Convert.ToInt32(auditStatus); } switch (enumAuditStatus) { case DataSources.EnumAuditStatus.DRAFT: case DataSources.EnumAuditStatus.NOTAUDIT: btnVerify.Enabled = false; enumActivation = DataSources.EnumInvalidOrActivation.Invalid; break; case DataSources.EnumAuditStatus.SUBMIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; break; case DataSources.EnumAuditStatus.AUDIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; btnVerify.Enabled = false; break; case DataSources.EnumAuditStatus.Invalid: btnCopy.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Caption = "激活"; btnSubmit.Enabled = false; btnVerify.Enabled = false; btnExport.Enabled = false; btnSet.Enabled = false; btnView.Enabled = false; btnPrint.Enabled = false; break; } //判断是提交 //if (((int)DataSources.EnumAuditStatus.SUBMIT).ToString() == CommonCtrl.IsNullToString(dr["order_status"])) //{ // btnVerify.Enabled = true; //} //else //{ // btnVerify.Enabled = false; //} //不复制明细 if (windowStatus != WindowStatus.Copy) { BindDetail(); BindBalanceDocuments(); } }
/// <summary> /// 绑定数据 /// </summary> void BindData() { DataTable dt = DBHelper.GetTable("", "v_account_verification", "*", string.Format("account_verification_id='{0}'", id), "", ""); if (dt == null || dt.Rows.Count == 0) { return; } DataRow dr = dt.Rows[0]; if (windowStatus != WindowStatus.Copy) { txtOrderNum.Caption = CommonCtrl.IsNullToString(dr["order_num"]); } if (dr["order_date"] != null && dr["order_date"] != DBNull.Value) { dtpOrderDate.Value = Common.UtcLongToLocalDateTime(Convert.ToInt64(dr["order_date"])); } txtOrderStatus.Caption = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), dr["order_status"]); txtcCustName1.Tag = dr["cust_id1"]; cust_code1 = CommonCtrl.IsNullToString(dr["cust_code1"]); txtcCustName1.Text = CommonCtrl.IsNullToString(dr["cust_name1"]); txtcCustName2.Tag = dr["cust_id2"]; cust_code2 = CommonCtrl.IsNullToString(dr["cust_code2"]); txtcCustName2.Text = CommonCtrl.IsNullToString(dr["cust_name2"]); txtAdvanceBalance.Caption = CommonCtrl.IsNullToString(dr["advance_balance"]); txtRemark.Caption = CommonCtrl.IsNullToString(dr["remark"]); cboOrderType.SelectedValue = Convert.ToInt32(dr["order_type"]); cboOrgId.SelectedValue = dr["org_id"]; cboHandle.SelectedValue = dr["handle"]; if (windowStatus == WindowStatus.Copy) { lblCreateBy.Text = GlobalStaticObj.UserName; lblCreateTime.Text = DateTime.Now.ToString(); lblUpdateBy.Text = string.Empty; lblUpdateTime.Text = string.Empty; } else if (windowStatus == WindowStatus.Edit || windowStatus == WindowStatus.View) { lblCreateBy.Text = CommonCtrl.IsNullToString(dr["create_by_name"]); string createTime = CommonCtrl.IsNullToString(dr["create_time"]); if (createTime.Length > 0) { lblCreateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(createTime)).ToString(); } lblUpdateBy.Text = CommonCtrl.IsNullToString(dr["update_by_name"]); string updateTime = CommonCtrl.IsNullToString(dr["update_time"]); if (updateTime.Length > 0) { lblUpdateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(updateTime)).ToString(); } else { lblUpdateTime.Text = string.Empty; } } string auditStatus = CommonCtrl.IsNullToString(dr["order_status"]); DataSources.EnumAuditStatus enumAuditStatus = DataSources.EnumAuditStatus.DRAFT; if (auditStatus != "") { enumAuditStatus = (DataSources.EnumAuditStatus)Convert.ToInt32(auditStatus); } switch (enumAuditStatus) { case DataSources.EnumAuditStatus.DRAFT: case DataSources.EnumAuditStatus.NOTAUDIT: btnVerify.Enabled = false; enumActivation = DataSources.EnumInvalidOrActivation.Invalid; break; case DataSources.EnumAuditStatus.SUBMIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; break; case DataSources.EnumAuditStatus.AUDIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; btnVerify.Enabled = false; break; case DataSources.EnumAuditStatus.Invalid: btnCopy.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Caption = "激活"; btnSubmit.Enabled = false; btnVerify.Enabled = false; btnExport.Enabled = false; btnSet.Enabled = false; btnView.Enabled = false; btnPrint.Enabled = false; break; } BindDetail(); }
/// <summary> /// 绑定数据 /// </summary> void BindData() { DataTable dt = DBHelper.GetTable("", "tb_account_verification", "*", string.Format("account_verification_id='{0}'", id), "", ""); if (dt == null || dt.Rows.Count == 0) { return; } DataRow dr = dt.Rows[0]; if (windowStatus != WindowStatus.Copy) { txtOrderNum.Caption = CommonCtrl.IsNullToString(dr["order_num"]); } if (dr["order_date"] != null && dr["order_date"] != DBNull.Value) { dtpOrderDate.Value = Common.UtcLongToLocalDateTime(Convert.ToInt64(dr["order_date"])); } txtOrderStatus.Caption = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), dr["order_status"]); txtcCustName1.Tag = dr["cust_id1"]; cust_code1 = CommonCtrl.IsNullToString(dr["cust_code1"]); txtcCustName1.Text = CommonCtrl.IsNullToString(dr["cust_name1"]); txtcCustName2.Tag = dr["cust_id2"]; cust_code2 = CommonCtrl.IsNullToString(dr["cust_code2"]); txtcCustName2.Text = CommonCtrl.IsNullToString(dr["cust_name2"]); txtAdvanceBalance.Caption = Common.CurrencyFormat(dr["advance_balance"]); txtRemark.Caption = CommonCtrl.IsNullToString(dr["remark"]); cboOrderType.SelectedValue = Convert.ToInt32(dr["order_type"]); cboOrgId.SelectedValue = dr["org_id"]; cboHandle.SelectedValue = dr["handle"]; if (windowStatus == WindowStatus.Copy) { lblCreateBy.Text = GlobalStaticObj.UserName; lblCreateTime.Text = DateTime.Now.ToString(); lblUpdateBy.Text = string.Empty; lblUpdateTime.Text = string.Empty; } else if (windowStatus == WindowStatus.Edit || windowStatus == WindowStatus.View) { lblCreateBy.Text = CommonCtrl.IsNullToString(dr["create_name"]); string createTime = CommonCtrl.IsNullToString(dr["create_time"]); if (createTime.Length > 0) { lblCreateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(createTime)).ToString(); } lblUpdateBy.Text = CommonCtrl.IsNullToString(dr["update_name"]); string updateTime = CommonCtrl.IsNullToString(dr["update_time"]); if (updateTime.Length > 0) { lblUpdateTime.Text = Common.UtcLongToLocalDateTime(Int64.Parse(updateTime)).ToString(); } else { lblUpdateTime.Text = string.Empty; } } //复制或编辑,计算往来余额 if (windowStatus == WindowStatus.Copy || windowStatus == WindowStatus.Edit) { string custID = CommonCtrl.IsNullToString(dr["cust_id1"]);//往来单位 DataSources.EnumAccountVerification enumAccount = (DataSources.EnumAccountVerification)Convert.ToInt32(dr["order_type"]); switch (enumAccount) { case DataSources.EnumAccountVerification.YuShouToYingShou://预收冲应收 case DataSources.EnumAccountVerification.YuShouToYuShou://预收转预收 if (txtAdvanceBalance.Visible) { txtAdvanceBalance.Caption = DBOperation.GetAdvance(custID, DataSources.EnumOrderType.RECEIVABLE).ToString("N2"); } break; case DataSources.EnumAccountVerification.YuFuToYingFu://预付冲应付 case DataSources.EnumAccountVerification.YuFuToYuFu://预付转预付 if (txtAdvanceBalance.Visible) { txtAdvanceBalance.Caption = DBOperation.GetAdvance(custID, DataSources.EnumOrderType.PAYMENT).ToString("N2"); } break; } } string auditStatus = CommonCtrl.IsNullToString(dr["order_status"]); DataSources.EnumAuditStatus enumAuditStatus = DataSources.EnumAuditStatus.DRAFT; if (auditStatus != "" && windowStatus != WindowStatus.Copy) { enumAuditStatus = (DataSources.EnumAuditStatus)Convert.ToInt32(auditStatus); } switch (enumAuditStatus) { case DataSources.EnumAuditStatus.DRAFT: case DataSources.EnumAuditStatus.NOTAUDIT: btnVerify.Enabled = false; enumActivation = DataSources.EnumInvalidOrActivation.Invalid; break; case DataSources.EnumAuditStatus.SUBMIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; break; case DataSources.EnumAuditStatus.AUDIT: btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Enabled = false; btnSubmit.Enabled = false; btnVerify.Enabled = false; break; case DataSources.EnumAuditStatus.Invalid: btnCopy.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; btnActivation.Caption = "激活"; btnSubmit.Enabled = false; btnVerify.Enabled = false; btnExport.Enabled = false; btnSet.Enabled = false; btnView.Enabled = false; btnPrint.Enabled = false; break; } dt.Columns.Add("print_name"); dt.Rows[0]["print_name"] = GlobalStaticObj.UserName; dt.DataTableToDate("order_date"); dt.DateTableToEnum("order_type", typeof(DataSources.EnumAccountVerification)); detailPrint.PrintTitle = CommonCtrl.IsNullToString(dr["order_type"]); dicDataTables.Add("tb_account_verification", dt); //不复制明细 if (windowStatus != WindowStatus.Copy) { BindDetail(enumAuditStatus); } }