private void TuikuanDan_Load(object sender, EventArgs e)
{
ZijinDao p = new ZijinDao();
int P_Int_newBillCode = p.selectMaxtuikuan_moneyid() + 1;//记录收款表中的数字码
textBox3.Text = DateTime.Now.ToString("yyyyMMdd") + P_Int_newBillCode + "HappyLemon";
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable("table");
dt.Columns.Add("收款日期", typeof(string));
dt.Columns.Add("单据号", typeof(string));
dt.Columns.Add("收款金额", typeof(string));
dt.Columns.Add("结算方式", typeof(string));
dt.Columns.Add("备注", typeof(string));
dt.Columns.Add("客户", typeof(string));
ZijinDao p = new ZijinDao();
List <Shoukuan> ps = new List <Shoukuan>();
if (comboBox1.Text == "")
{
ps = p.selectGet_date(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text));
Console.Write("寇肖萌");
}
if (comboBox1.Text != "")
{
string[] suppliername = comboBox1.Text.Split(' ');
ps = p.selectGet_dateandkehuname(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), suppliername[0]);
}
foreach (Shoukuan shou in ps)
{
customer c1 = new customer();
customerdao cdao = new customerdao();
Console.WriteLine(shou.Get_suppliernumber);
c1 = cdao.selectnumber(shou.Get_suppliernumber);
Console.WriteLine(shou.Get_money);
Console.WriteLine(shou.Get_way);
Console.WriteLine(shou.Mark);
Console.WriteLine(c1.Customer_name);
Console.WriteLine(shou.Date);
Console.WriteLine(shou.Get_danjuid);
dt.Rows.Add(shou.Date, shou.Get_danjuid, shou.Get_money, shou.Get_way, shou.Mark, c1.Customer_name);
}
dataGridView1.DataSource = dt;
}
catch (SystemException)
{
MessageBox.Show("操作不当");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable("table");
dt.Columns.Add("退款日期", typeof(string));
dt.Columns.Add("单据号", typeof(string));
dt.Columns.Add("退款金额", typeof(string));
dt.Columns.Add("结算方式", typeof(string));
dt.Columns.Add("备注", typeof(string));
dt.Columns.Add("供应商", typeof(string));
ZijinDao p = new ZijinDao();
List <Tuikuan> ps = new List <Tuikuan>();
if (comboBox1.Text == "")
{
ps = p.selectTuikuan_date(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text));
Console.Write("寇肖萌");
}
if (comboBox1.Text != "")
{
string[] suppliername = comboBox1.Text.Split(' ');
ps = p.selectTuikuan_dateandkehuname(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), suppliername[0]);
}
foreach (Tuikuan tui in ps)
{
supplier s1 = new supplier();
supplierdao sdao = new supplierdao();
Console.WriteLine(tui.Tuikuan_suppliernumber);
s1 = sdao.selectNumber(tui.Tuikuan_suppliernumber);
Console.WriteLine(tui.Tuikuan_money);
Console.WriteLine(tui.Tuikuan_way);
Console.WriteLine(tui.Mark);
Console.WriteLine(s1.Supplier_name);
Console.WriteLine(tui.Date);
Console.WriteLine(tui.Tuikuan_danjuid);
dt.Rows.Add(tui.Date, tui.Tuikuan_danjuid, tui.Tuikuan_money, tui.Tuikuan_way, tui.Mark, s1.Supplier_name);
}
dataGridView1.DataSource = dt;
}
catch (SystemException)
{
MessageBox.Show("操作不当");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable("table");
dt.Columns.Add("收款金额", typeof(string));
dt.Columns.Add("退款金额", typeof(string));
dt.Columns.Add("成本", typeof(string));
dt.Columns.Add("利润总额", typeof(string));
ZijinDao p = new ZijinDao();
double ps;
double fs;
double ts;
double profitmoney;
ps = p.selectGet_date1(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text));
fs = p.selectPayfor_date1(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text));
ts = p.selectTuikuan_date1(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text));
profitmoney = ps + ts - fs;
dt.Rows.Add(ps, ts, fs, profitmoney);
dataGridView1.DataSource = dt;
}
catch (SystemException)
{
MessageBox.Show("操作不当");
}
}
private void button4_Click(object sender, EventArgs e)
{
bool b = true;
if (dataGridView1.Rows.Count == 1)
{
MessageBox.Show("请填写信息");
b = false;
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value == null)
{
MessageBox.Show("结算账户不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("退款金额不能为空");
b = false;
}
else if (dataGridView1.Rows[i].Cells[2].Value == null)
{
MessageBox.Show("结算方式不能为空");
b = false;
}
else if (textBox1.Text == null)
{
MessageBox.Show("供应商不能为空");
b = false;
}
else if (textBox2.Text == null)
{
MessageBox.Show("操作人不能为空");
b = false;
}
}
}
if (b == false)
{
}
else
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("是否确认保存？", "提交", messButton);
if (dr == DialogResult.OK)
{
string[] supplier1 = textBox1.Text.Split(' ');
string[] employer = textBox2.Text.Split(' ');
try
{
ZijinDao dao = new ZijinDao();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
Tuikuan p = new Tuikuan();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.Tuikuan_zhanghu = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Tuikuan_money = dataGridView1.Rows[i].Cells[1].Value.ToString();
p.Tuikuan_way = dataGridView1.Rows[i].Cells[2].Value.ToString();
if (dataGridView1.Rows[i].Cells[3].Value == null)
{
p.Mark = "";
}
else
{
p.Mark = dataGridView1.Rows[i].Cells[3].Value.ToString();
}
p.Tuikuan_suppliernumber = supplier1[0];
p.Employee_number = employer[0];
p.Date = Convert.ToDateTime(dateTimePicker1.Text);
p.Tuikuan_danjuid = textBox3.Text;
dao.addTuikuandan(p);
}
MessageBox.Show("保存成功");
dataGridView1.Rows.Clear();
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
else
{
}
}
}
