private void CopyAdd(int id)
{
DeliveryNote objNote = null;
try
{
DeliveryDAC dac = new DeliveryDAC();
objNote = dac.Select(id);
}
catch (Exception ex)
{
MessageBox.Show("操作数据库出错，请检查网络;\r\n原因:" + ex.Message);
return;
}
if (objNote == null)
{
MessageBox.Show("查询出错");
return;
}
frmEditDelivery frm = new frmEditDelivery();
frm.EditMode = 1;
frm.objNote = objNote;
if (frm.ShowDialog() == DialogResult.OK)
{
RefreshData();
}
}
private void Remove(int id)
{
if (MessageBox.Show("确认是否删除当前记录?", "提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
DeliveryDAC dac = new DeliveryDAC();
String bErr = dac.Delete(id, true);
if (bErr.Length > 0)
{
MessageBox.Show("删除失败!\r\n原因：" + bErr);
return;
}
}
catch (Exception ex)
{
MessageBox.Show("操作数据库出错，请检查网络;\r\n原因:" + ex.Message);
return;
}
RefreshData();
MessageBox.Show("删除成功");
}
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());
}
}
private void btnExport_Click(object sender, EventArgs e)
{
if (dataGridResult.SelectedRows.Count == 0)
{
MessageBox.Show("请先选中要导出的单据");
return;
}
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel文件|*.xls";
//设置默认文件类型显示顺序
sfd.FilterIndex = 1;
sfd.RestoreDirectory = true;
if (sfd.ShowDialog() == DialogResult.OK)
{
DeliveryNote note;
try
{
int id = int.Parse(dataGridResult.SelectedRows[0].Cells[0].Value.ToString());
DeliveryDAC dac = new DeliveryDAC();
note = dac.Select(id);
}
catch (Exception ex)
{
MessageBox.Show("查询单据出错,请检查网络;\r\n原因:" + ex.Message);
return;
}
try
{
NPOIHelper.ExportDelivery(sfd.FileName.ToString(), note);
}
catch (Exception ex)
{
MessageBox.Show("导出Excel出错;\r\n原因:" + ex.Message);
return;
}
MessageBox.Show("导出成功");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool saveInsert;
string sRet = CheckForm(out saveInsert);
if (sRet.Length > 0)
{
MessageBox.Show(sRet);
return;
}
DeliveryNote EditNote = new DeliveryNote();
if (EditMode == 2)
{
EditNote.noteid = int.Parse(noteid.Text);
EditNote.deliverid = int.Parse(deliverid.Text);
if (objNote == null)
{
EditNote.sdate = DateTime.Now;
}
else
{
EditNote.sdate = objNote.sdate;
}
}
else
{
EditNote.sdate = DateTime.Now;
}
EditNote.customer = customer.Text.Trim();
EditNote.model = model.Text.Trim();
EditNote.deliverdate = deliverdate.Value;
EditNote.goodname = goodname.Text.Trim();
EditNote.batch = batch.Text;
EditNote.description = description.Text;
EditNote.description1 = description1.Text;
EditNote.loginid = Global.LoginUser.loginid;
SysDictDAC dac = new SysDictDAC();
SysDictEntity dictEntity = dac.Select("model", EditNote.model);
if (dictEntity == null)
{
dictEntity = new SysDictEntity();
dictEntity.dictype = "model";
dictEntity.dictvalue = EditNote.model;
dac.Add(dictEntity);
}
dictEntity = null;
dictEntity = dac.Select("goodname", EditNote.goodname);
if (dictEntity == null)
{
dictEntity = new SysDictEntity();
dictEntity.dictype = "goodname";
dictEntity.dictvalue = EditNote.goodname;
dac.Add(dictEntity);
}
dictEntity = null;
GridPanel panel = superGrid.PrimaryGrid;
if (panel.Rows.Count > 0)
{
List <DeliveryItem> DeliveryItems = new List <DeliveryItem>();
for (int i = 0; i < panel.Rows.Count; i++)
{
DeliveryItem item = new DeliveryItem();
GridRow curRow = panel.Rows[i] as GridRow;
bool bSave = false;
if (!curRow.IsInsertRow)
{
bSave = true;
}
else
{
bSave = saveInsert;
}
if (bSave)
{
item.noteid = EditNote.noteid;
item.jiannum = ControlHelper.Object2String(curRow["jiannum"].Value);
string spec = ControlHelper.Object2String(curRow["specifications"].Value);
dictEntity = dac.Select("deliveryspec", spec);
if (dictEntity == null)
{
dictEntity = new SysDictEntity();
dictEntity.dictype = "deliveryspec";
dictEntity.dictvalue = spec;
dac.Add(dictEntity);
}
dictEntity = null;
item.specifications = spec;
item.lenght = ControlHelper.Object2Int(curRow["lenght"].Value);
item.discnum = ControlHelper.Object2Int(curRow["discnum"].Value);
item.weight = ControlHelper.Object2Double(curRow["weight"].Value);
item.price = ControlHelper.Object2Double(curRow["price"].Value.ToString());
item.totalprice = ControlHelper.Object2Double(curRow["totalprice"].Value);
item.contractno = ControlHelper.Object2String(curRow["contractno"].Value);
item.netweight = ControlHelper.Object2Double(curRow["netweight"].Value);
item.coreweight = ControlHelper.Object2Double(curRow["coreweight"].Value.ToString());
DeliveryItems.Add(item);
}
}
EditNote.items = DeliveryItems;
}
DeliveryDAC dacDelivery = new DeliveryDAC();
if (EditMode == 0 || EditMode == 1)
{
bool bRet = false;
try
{
bRet = dacDelivery.Add(EditNote);
}
catch (Exception ex)
{
MessageBox.Show("操作数据库出错，请检查网络;\r\n原因:" + ex.Message);
return;
}
if (bRet)
{
if (MessageBox.Show("保存成功，是否继续新建送货单?", "提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
EditMode = 1;
InitVar();
}
}
else
{
MessageBox.Show("保存失败");
}
}
else
{
try
{
dacDelivery.Update(EditNote);
}
catch (Exception ex)
{
MessageBox.Show("操作数据库出错，请检查网络;\r\n原因:" + ex.Message);
return;
}
MessageBox.Show("保存成功");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
