private void modify_Click(object sender, EventArgs e)
{
userInterfaceValue uiValue = new userInterfaceValue();
uiValue.winText = this.Text + "编辑";
uiValue.isAccountReceivable = m_isAccountReceivable;
uiValue.isEditDate = true;
uiValue.textBoxText = m_currentDataGridViedRecordName;
uiValue.pkey = m_currentDataGridViedRecordPkey;
InitAccountReceivableTable data = new InitAccountReceivableTable();
if (m_isAccountReceivable)
{
data = InitAccountReceivable.getInctance().getAccountReceivableInfoFromPkey(m_currentDataGridViedRecordPkey);
}
else
{
data = InitAccountPayable.getInctance().getAccountPayableInfoFromPkey(m_currentDataGridViedRecordPkey);
}
uiValue.textBoxBalance = Convert.ToString(data.balance);
uiValue.dateTimePickerDateText = data.tradingDate;
uiValue.customerOrSupplierID = data.customerOrSupplierID;
FormAccountReceivablerEdit fare = new FormAccountReceivablerEdit(uiValue);
fare.ShowDialog();
updateDataGridView();
}
private void updateDataGridView()
{
SortedDictionary <int, InitAccountReceivableTable> dateList = new SortedDictionary <int, InitAccountReceivableTable>();
if (m_isAccountReceivable)
{
dateList = InitAccountReceivable.getInctance().getAllInitAccountReceivableInfo();
}
else
{
dateList = InitAccountPayable.getInctance().getAllInitAccountPayableInfo();
}
m_dataGridRecordCount = dateList.Count;
SortedDictionary <int, ArrayList> settlmentWayLArrary = new SortedDictionary <int, ArrayList>();
double balanceSum = 0.0, creditSum = 0.0;
int recordCount = 0;
for (recordCount = 0; recordCount < dateList.Count; recordCount++)
{
InitAccountReceivableTable record = new InitAccountReceivableTable();
record = (InitAccountReceivableTable)dateList[recordCount];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.customerOrSupplierID);
temp.Add(record.name);
temp.Add(record.balance);
temp.Add(record.tradingDate);
temp.Add(record.credit);
settlmentWayLArrary.Add(recordCount, temp);
// 应收或应付账款金额合计
balanceSum += record.balance;
creditSum += record.credit;
}
m_dateGridViewExtend.initDataGridViewData(settlmentWayLArrary);
}
private void updateDataGridView()
{
SortedDictionary <int, InitAccountReceivableTable> dateList = new SortedDictionary <int, InitAccountReceivableTable>();
if (m_isAccountReceivable)
{
dateList = InitAccountReceivable.getInctance().getAllInitAccountReceivableInfo();
}
else
{
dateList = InitAccountPayable.getInctance().getAllInitAccountPayableInfo();
}
m_dataGridRecordCount = dateList.Count;
SortedDictionary <int, ArrayList> settlmentWayLArrary = new SortedDictionary <int, ArrayList>();
double balanceSum = 0.0, creditSum = 0.0;
int recordCount = 0;
for (recordCount = 0; recordCount < dateList.Count; recordCount++)
{
InitAccountReceivableTable record = new InitAccountReceivableTable();
record = (InitAccountReceivableTable)dateList[recordCount];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.name);
temp.Add(record.balance);
temp.Add(record.tradingDate);
temp.Add(record.credit);
settlmentWayLArrary.Add(recordCount, temp);
// 应收或应付账款金额合计
balanceSum += record.balance;
creditSum += record.credit;
}
// 需要再DataGridView的最后一行添加合计欠款金额一行
InitAccountReceivableTable sumBalanceRecord = new InitAccountReceivableTable();
sumBalanceRecord.pkey = 0;
sumBalanceRecord.name = "合计";
sumBalanceRecord.balance = balanceSum;
sumBalanceRecord.tradingDate = "";
sumBalanceRecord.credit = creditSum;
ArrayList sumRecord = new ArrayList();
sumRecord.Add(sumBalanceRecord.pkey);
sumRecord.Add(sumBalanceRecord.name);
sumRecord.Add(sumBalanceRecord.balance);
sumRecord.Add(sumBalanceRecord.tradingDate);
sumRecord.Add(sumBalanceRecord.credit);
settlmentWayLArrary.Add(recordCount, sumRecord);
m_dateGridViewExtend.initDataGridViewData(settlmentWayLArrary);
// 设置DataGridView 合计行背景颜色
dataGridViewList.Rows[dateList.Count].DefaultCellStyle.BackColor = System.Drawing.Color.LightBlue;
}
private void buttonEnter_Click(object sender, EventArgs e)
{
if (textBoxBalance.Text.Length == 0)
{
MessageBoxExtend.messageWarning("欠款金额不能为空");
return;
}
if (textBoxBalance.Text.Length > 20)
{
MessageBoxExtend.messageWarning("单价最大长度不能超过10");
textBoxBalance.Text = "";
return;
}
if (dateTimePickerDate.Text.Length == 0)
{
MessageBoxExtend.messageWarning("日期不能");
return;
}
InitAccountReceivableTable record = new InitAccountReceivableTable();
if (m_userInterfaceValue.isEditDate)
{
record.customerOrSupplierID = m_userInterfaceValue.customerOrSupplierID;
}
else
{
record.customerOrSupplierID = m_selectRecordPkey;
}
record.balance = Convert.ToDouble(this.textBoxBalance.Text.ToString());
record.tradingDate = this.dateTimePickerDate.Value.ToString("yyyyMMdd");
if (m_userInterfaceValue.isEditDate)
{
if (m_userInterfaceValue.isAccountReceivable)
{
InitAccountReceivable.getInctance().update(m_userInterfaceValue.pkey, record);
}
else
{
InitAccountPayable.getInctance().update(m_userInterfaceValue.pkey, record);
}
}
else
{
if (m_userInterfaceValue.isAccountReceivable)
{
InitAccountReceivable.getInctance().insert(record);
}
else
{
InitAccountPayable.getInctance().insert(record);
}
}
m_isAddToInitList = true;
this.Close();
}
