public void JisuanInfoTest()
{
DingdanCreateInfo createInfo = new DingdanCreateInfo();
createInfo.XiadanRiqi = new DateTime(2014, 8, 15);
createInfo.JiekuanFangshi = "1个月月结";
createInfo.Kehu = new Kehu();
Dingdan dingdan = new Dingdan(createInfo);
DingdanChangeInfo changeInfo = new DingdanChangeInfo(dingdan);
DingdanMingxiCreateInfo mingxiCreateInfo = new DingdanMingxiCreateInfo {
Dingdan = dingdan, XiaoshouDijia = 9, XiaoshouDanjia = 10, Shuliang = 1000, Yewulv = 0.03, YewulvFangshi = "按金额"
};
DingdanMingxi mingxi = new DingdanMingxi(mingxiCreateInfo);
changeInfo.MingxiList.Add(mingxi);
ShoukuanCreateInfo shoukuanCreateInfo = new ShoukuanCreateInfo {
Dingdan = dingdan, ShoukuanJine = 300, ShoukuanRiqi = dingdan.XiadanRiqi
};
Shoukuan shoukuan = new Shoukuan(shoukuanCreateInfo);
changeInfo.ShoukuanList.Add(shoukuan);
dingdan.Change(changeInfo);
Assert.AreEqual(10000, mingxi.Zongjine);
Assert.AreEqual(300, mingxi.Yewufei);
Assert.AreEqual(9.7, Math.Round(mingxi.ShijiDanjia, 2));
Assert.AreEqual(97, Math.Round(mingxi.Butie, 2));
Assert.AreEqual(51, Math.Round(mingxi.Ticheng, 2));
}
public int selectGet_date1(DateTime date1, DateTime date2)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
Shoukuan shou = null;
Int16 sumget_money = 0;
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT sum(get_money) FROM get_money where date>='" + date1 + "'and date<='" + date2 + "'";
dataReader = command.ExecuteReader();
Console.WriteLine(command.CommandText);
while (dataReader.Read())
{
sumget_money = dataReader.GetInt16(0);
}
}
catch (Exception)
{
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(sumget_money);
}
public void JisuanInfoTest()
{
DingdanCreateInfo createInfo = new DingdanCreateInfo();
createInfo.XiadanRiqi = new DateTime(2014, 8, 15);
createInfo.JiekuanFangshi = "1个月月结";
createInfo.Kehu = new Kehu();
Dingdan dingdan = new Dingdan(createInfo);
DingdanChangeInfo changeInfo = new DingdanChangeInfo(dingdan);
DingdanMingxiCreateInfo mingxiCreateInfo = new DingdanMingxiCreateInfo {
Dingdan = dingdan, XiaoshouDijia = 11, XiaoshouDanjia = 10, Shuliang = 100, Yewulv = 0.2, YewulvFangshi = "按金额"
};
DingdanMingxi mingxi = new DingdanMingxi(mingxiCreateInfo);
changeInfo.MingxiList.Add(mingxi);
ShoukuanCreateInfo shoukuanCreateInfo = new ShoukuanCreateInfo {
Dingdan = dingdan, ShoukuanJine = 300, ShoukuanRiqi = dingdan.XiadanRiqi
};
Shoukuan shoukuan = new Shoukuan(shoukuanCreateInfo);
changeInfo.ShoukuanList.Add(shoukuan);
dingdan.Change(changeInfo);
Assert.AreEqual(dingdan.JiekuanRiqi, new DateTime(2014, 9, 30));
Assert.AreEqual(dingdan.WeishoukuanJine, 700);
Assert.AreEqual(dingdan.YingshoukuanJine, 1000);
Assert.AreEqual(dingdan.YishoukuanJine, 300);
Assert.AreEqual(dingdan.Ticheng, mingxi.JisuanTicheng(shoukuan.ShoukuanJine, shoukuan.ShoukuanRiqi));
}
public void addShoukuandan(Shoukuan p)
{
MySqlConnection conn = Util.Util.getConn();
MySqlCommand command;
try
{
command = conn.CreateCommand();
command.CommandText = "INSERT INTO get_money(get_zhanghu,get_money,get_way,mark,get_suppliernumber,employee_number,date,get_danjuid) VALUES(@get_zhanghu,@get_money,@get_way,@mark,@get_suppliernumber,@employee_number,@date,@get_danjuid)";
command.Parameters.AddWithValue("@get_zhanghu", p.Get_zhanghu);
command.Parameters.AddWithValue("@get_money", p.Get_money);
command.Parameters.AddWithValue("@get_way", p.Get_way);
command.Parameters.AddWithValue("@mark", p.Mark);
command.Parameters.AddWithValue("@get_suppliernumber", p.Get_suppliernumber);
command.Parameters.AddWithValue("@employee_number", p.Employee_number);
command.Parameters.AddWithValue("@date", p.Date);
command.Parameters.AddWithValue("@get_danjuid", p.Get_danjuid);
command.ExecuteNonQuery();
//MessageBox.Show("插入成功");
}
catch (Exception)
{
MessageBox.Show("插入失败");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public double JisuanTicheng(DingdanDetailsModel dingdanModel, ShoukuanDetailsModel model)
{
Dingdan dingdan = this.CreateDingdan(dingdanModel);
Shoukuan shoukuan = this.CreateShoukuan(dingdan, model);
shoukuan.Jisuan();
return(shoukuan.Ticheng);
}
public ShoukuanGridModel(Shoukuan shoukuan)
{
ClassPropertyHelper.ChangeProperty(this, shoukuan);
this.dingdanhao = shoukuan.Dingdan.Danhao;
this.yewuyuan = shoukuan.Dingdan.Yewuyuan.Name;
this.jiekuanRiqi = shoukuan.Dingdan.JiekuanRiqi;
this.xiadanRiqi = shoukuan.Dingdan.XiadanRiqi;
this.kehu = shoukuan.Dingdan.Kehu.Name;
}
private Shoukuan CreateShoukuan(Dingdan dingdan, ShoukuanDetailsModel detailsModel)
{
ShoukuanCreateInfo shoukuanCreateInfo = new ShoukuanCreateInfo();
shoukuanCreateInfo.Dingdan = dingdan;
ClassPropertyHelper.ChangeProperty(shoukuanCreateInfo, detailsModel);
Shoukuan shoukuan = new Shoukuan(shoukuanCreateInfo);
return(shoukuan);
}
private List <Shoukuan> CreateShoukuanList(Dingdan dingdan, List <ShoukuanDataModel> models)
{
List <Shoukuan> mingxiList = new List <Shoukuan>();
if (models != null)
{
foreach (ShoukuanDataModel model in models)
{
ShoukuanCreateInfo createInfo = new ShoukuanCreateInfo();
ClassPropertyHelper.ChangeProperty(createInfo, model);
createInfo.Dingdan = dingdan;
Shoukuan shoukuan = new Shoukuan(createInfo);
mingxiList.Add(shoukuan);
}
}
return(mingxiList);
}
//按照单据日期和客户查询
public List <Shoukuan> selectGet_dateandkehuname(DateTime date1, DateTime date2, string customer_name)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
Shoukuan shou = null;
List <Shoukuan> rs = new List <model.Shoukuan>();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM get_money where date>='" + date1 + "'and date<='" + date2 + "'and get_suppliernumber='" + customer_name + "'";
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
shou = new Shoukuan();
shou.Id = dataReader.GetInt16(0);
shou.Get_zhanghu = dataReader.GetString(1);
shou.Get_money = dataReader.GetString(2);
shou.Get_way = dataReader.GetString(3);
shou.Mark = dataReader.GetString(4);
shou.Get_suppliernumber = dataReader.GetString(5);
shou.Employee_number = dataReader.GetString(6);
shou.Date = dataReader.GetDateTime(7);
shou.Get_danjuid = dataReader.GetString(8);
rs.Add(shou);
}
}
catch (Exception)
{
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(rs);
}
public ShoukuanDetailsModel(Shoukuan shoukuan)
{
ClassPropertyHelper.ChangeProperty(this, shoukuan);
}
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++)
{
Shoukuan p = new Shoukuan();
Console.Write(dataGridView1.Rows[i].Cells[0].Value + "lallalalaalalalalalalla");
p.Get_zhanghu = dataGridView1.Rows[i].Cells[0].Value.ToString();
p.Get_money = dataGridView1.Rows[i].Cells[1].Value.ToString();
p.Get_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.Get_suppliernumber = supplier1[0];
p.Employee_number = employer[0];
p.Date = Convert.ToDateTime(dateTimePicker1.Text);
p.Get_danjuid = textBox3.Text;
dao.addShoukuandan(p);
}
MessageBox.Show("保存成功");
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
else
{
}
}
}
public ShoukuanDataModel(Shoukuan shoukuan)
{
this.Beizhu = shoukuan.Beizhu;
this.ShoukuanJine = shoukuan.ShoukuanJine;
this.ShoukuanRiqi = shoukuan.ShoukuanRiqi;
}
