/// <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);
}
}
