private void import_Click(object sender, EventArgs e)
{
string msg;
if (m_isAccountReceivable)
{
msg = "批量导入数据会清空数据库所有已存在应收账款记录，是否继续？";
}
else
{
msg = "批量导入数据会清空数据库所有已存在应付账款记录，是否继续？";
}
if (MessageBoxExtend.messageQuestion(msg))
{
// 指定OpenFileDialog控件打开的文件格式
openFileDialog1.Filter = "导入文件(*.xls)|*.xls";
openFileDialog1.FileName = "";
if (openFileDialog1.ShowDialog(this) == DialogResult.OK)
{
if (m_isAccountReceivable)
{
InitAccountReceivable.getInctance().fileImport(openFileDialog1.FileName);
}
else
{
InitAccountPayable.getInctance().fileImport(openFileDialog1.FileName);
}
updateDataGridView();
}
}
}
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 checkAccountBillDetaile()
{
// checkAccountBillDetaile函数需要完成弹出一个新的窗口，用来显示公司跟该企业的详细的往来账
if (m_currentDataGridViedRecordPkey != 0)
{
// 根据m_currentDataGridViedRecordPkey得到对应往来单位的pkey值
int exchangesUnitPkey;
string winText = "";;
if (m_isAccountReceivable)
{
exchangesUnitPkey = InitAccountReceivable.getInctance().getCustomerOrSupplierIDFromPkey(m_currentDataGridViedRecordPkey);
winText = "应收账款 - [" + m_currentDataGridViedRecordName + "]";
}
else
{
exchangesUnitPkey = InitAccountPayable.getInctance().getCustomerOrSupplierIDFromPkey(m_currentDataGridViedRecordPkey);
winText = "应付账款 - [" + m_currentDataGridViedRecordName + "]";
}
if (exchangesUnitPkey != -1)
{
FormAccountReceivablerDetail fard = new FormAccountReceivablerDetail(winText, m_isAccountReceivable, exchangesUnitPkey);
fard.ShowDialog();
}
else
{
MessageBoxExtend.messageWarning("该企业不存在.");
}
}
}
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 delete_Click(object sender, EventArgs e)
{
if (m_currentDataGridViedRecordPkey != 0)
{
if (MessageBoxExtend.messageQuestion("确定删除[" + m_currentDataGridViedRecordName + "]欠款信息吗?"))
{
if (m_isAccountReceivable)
{
InitAccountReceivable.getInctance().delete(m_currentDataGridViedRecordPkey);
}
else
{
InitAccountPayable.getInctance().delete(m_currentDataGridViedRecordPkey);
}
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.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();
}