//添加下单 private void addBT_Click(object sender, EventArgs e) { if ( s_khmc.Text.Trim() == "" || s_ghgs.Text.Trim() == "" || //s_ddbh.Text == "" || s_cgry.Text.Trim() == "" || s_xdri.Text.Trim() == "" || s_xqsj.Text.Trim() == "" || s_xqsj.Text.Trim() == "" || s_cplx.Text.Trim() == "" || s_cpmc.Text.Trim() == "" || s_ggxh.Text.Trim() == "" || s_suil.Text.Trim() == "" || s_cplh.Text.Trim() == "" || s_cwlx.Text.Trim() == "" || s_danw.Text.Trim() == "" || s_heth.Text.Trim() == "" || s_shul.Text.Trim() == "" || s_danj.Text.Trim() == "" || s_zongj.Text.Trim() == "" ) { MessageBox.Show("请先输入参数!"); return; } string time = DateTime.Now.ToString("yyMMdd"); DataList list = new DataList(); DataTable dt = crud.czddbh(time); if (dt == null) { list.s_ddbh = time + "0001"; } else { list.s_ddbh = (Convert.ToInt32(dt.Rows[0]["lotid"].ToString()) + 1).ToString(); } list.s_cpmc = s_cpmc.Text; list.s_khmc = s_khmc.Text; list.s_ghgs = s_ghgs.Text; list.s_cgry = s_cgry.Text; list.s_xdri = s_xdri.Text; list.s_xqsj = s_xqsj.Text; list.s_cplx = s_cplx.Text; list.s_ggxh = s_ggxh.Text; list.s_cwlx = s_cwlx.Text; list.s_suil = s_suil.Text; list.s_cplh = s_cplh.Text; list.s_cwlx = s_cwlx.Text; list.s_danw = s_danw.Text; list.s_heth = s_heth.Text; list.s_shul = s_shul.Text; list.s_danj = s_danj.Text; list.s_zongj = s_zongj.Text; list.s_cpmc = s_cpmc.Text; list.s_cpms = s_cpms.Text; list.s_beiz = s_bz.Text; list.s_user = MainFrom.USERID; if (crud.Addsale(list) == "success") { MessageBox.Show("订单" + list.s_ddbh + "下单成功!"); databind(); } }
//添加下单 private void addBT_Click(object sender, EventArgs e) { if ( s_khmc.Text.Trim() == "" || s_ghgs.Text.Trim() == "" || //s_ddbh.Text == "" || s_cgry.Text.Trim() == "" || s_xdri.Text.Trim() == "" || s_xqsj.Text.Trim() == "" || s_xqsj.Text.Trim() == "" || s_cplx.Text.Trim() == "" || s_cpmc.Text.Trim() == "" || s_ggxh.Text.Trim() == "" || s_suil.Text.Trim() == "" || s_cplh.Text.Trim() == "" || s_cwlx.Text.Trim() == "" || s_danw.Text.Trim() == "" || s_heth.Text.Trim() == "" || s_shul.Text.Trim() == "" || s_danj.Text.Trim() == "" || s_zongj.Text.Trim() == "" ) { MessageBox.Show("请先输入参数!"); return; } TimeSpan ts1 = new TimeSpan(s_xqsj.Value.Ticks); TimeSpan ts2 = new TimeSpan(s_xdri.Value.Ticks); if (ts1.TotalDays <= ts2.TotalDays) { MessageBox.Show("收款时间不可以比" + "下单时间早"); return; } string time = DateTime.Now.ToString("yyMMdd"); DataList list = new DataList(); DataTable dt = crud.czddbh(time); if (dt == null) { list.s_ddbh = time + "0051"; } else { list.s_ddbh = (Convert.ToInt32(dt.Rows[0]["lotid"].ToString()) + 1).ToString(); } list.s_cpmc = s_cpmc.Text; list.s_khmc = s_khmc.Text; list.s_ghgs = s_ghgs.Text; list.s_cgry = s_cgry.Text; list.s_xdri = s_xdri.Text; list.s_xqsj = s_xqsj.Text; list.s_cplx = s_cplx.Text; list.s_ggxh = s_ggxh.Text; list.s_cwlx = s_cwlx.Text; list.s_suil = s_suil.Text; list.s_cplh = s_cplh.Text; list.s_cwlx = s_cwlx.Text; list.s_danw = s_danw.Text; list.s_heth = s_heth.Text; list.s_shul = s_shul.Text; list.s_danj = s_danj.Text; list.s_zongj = s_zongj.Text; list.s_cpmc = s_cpmc.Text; list.s_cpms = s_cpms.Text; list.s_beiz = s_bz.Text; list.s_user = MainFrom.USERID; if (crud.Addsale(list) == "success") { MessageBox.Show("订单" + list.s_ddbh + "下单成功!"); databind(); for (int i = 0; i < grd.Rows.Count; i++) { if (grd.Rows[i].Cells["订单编号"].Value.ToString() == list.s_ddbh) { grd.Rows[i].Selected = true; //第一行显示为*****的 grd.FirstDisplayedScrollingRowIndex = i; } } } }