public DeliveryResutl Statistic(string customer, DateTime sStart, DateTime sEnd, string specifications, string goodname) { DeliveryResutl result = new DeliveryResutl(); string strSql1 = "SELECT SUM(b.lenght*b.discnum), SUM(b.discnum),SUM(b.totalprice),SUM(b.weight) FROM ct_deliverynote a,ct_deliveryitem b where a.noteid=b.noteid and a.deliverdate>='" + sStart.ToString() + "' and a.deliverdate<='" + sEnd.ToString() + "'"; if (customer.Length > 0) { strSql1 += " and a.customer = '" + customer + "'"; } if (goodname.Length > 0) { strSql1 += " and a.goodname = '" + goodname + "'"; } if (specifications.Length > 0) { strSql1 += " and b.specifications = '" + specifications + "'"; } DataTable dtSum = DMContext.TSqlCommand(strSql1).ToDataTable(); if (dtSum != null) { if (dtSum.Rows.Count > 0) { result.TotalLength = ControlHelper.Object2Int(dtSum.Rows[0][0]); result.TotalDisc = ControlHelper.Object2Int(dtSum.Rows[0][1]); result.TotalPrice = ControlHelper.Object2Double(dtSum.Rows[0][2]); result.TotalWeight = ControlHelper.Object2Double(dtSum.Rows[0][3]); } } return(result); }
private void RefreshData() { InitHeader(); try { DeliveryDAC dac = new DeliveryDAC(); DeliveryResutl objResult = dac.SelectList(customer.Text.Trim(), dtpStart.Value, dtpEnd.Value, goodname.Text.Trim(), specifications.Text.Trim()); DataTable dt = ControlHelper.ConvertList2DataTable(objResult.Notes); dataGridResult.DataSource = dt; StatusLabelDisco.Text = objResult.TotalDisc.ToString(); StatusLabelLength.Text = objResult.TotalLength.ToString(); StatusLabelWeight.Text = objResult.TotalWeight.ToString(); StatusLabelPrice.Text = objResult.TotalPrice.ToString(); } catch (Exception ex) { MessageBox.Show("读取数据库出错,请检查网络;\r\n原因:" + ex.Message); } }
private void btnStat_Click(object sender, EventArgs e) { DeliveryResutl objResult = null; try { DeliveryDAC dac = new DeliveryDAC(); objResult = dac.Statistic(customer.Text.Trim(), dtpStart.Value, dtpEnd.Value, specifications.Text.Trim(), goodname.Text.Trim()); } catch (Exception ex) { MessageBox.Show("读取数据库出错,请检查网络;\r\n原因:" + ex.Message); return; } if (objResult != null) { MessageBox.Show("统计结果如下:\r\n总盘数:" + objResult.TotalDisc.ToString() + "\r\n总长度:" + objResult.TotalLength.ToString() + "\r\n总重量:" + objResult.TotalWeight.ToString() + "\r\n总金额:" + objResult.TotalPrice.ToString()); } }