private void InitDict()
{
try
{
CustomerDAC dacCustomer = new CustomerDAC();
customer.Items.Clear();
List <CustomerEntity> lstCustomer = dacCustomer.SelectAll();
foreach (CustomerEntity entity in lstCustomer)
{
customer.Items.Add(entity.customer);
}
SysDictDAC dacSys = new SysDictDAC();
model.Items.Clear();
List <SysDictEntity> lstDict = dacSys.SelectList("model");
foreach (SysDictEntity entity in lstDict)
{
model.Items.Add(entity.dictvalue);
}
goodname.Items.Clear();
lstDict = dacSys.SelectList("goodname");
foreach (SysDictEntity entity in lstDict)
{
goodname.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("提取字典出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
}
private void InitCombo()
{
dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
dtpEnd.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59);
try
{
CustomerDAC dacCustomer = new CustomerDAC();
customer.Items.Clear();
List <CustomerEntity> lstCustomer = dacCustomer.SelectAll();
foreach (CustomerEntity entity in lstCustomer)
{
customer.Items.Add(entity.customer);
}
SysDictDAC dacSys = new SysDictDAC();
specifications.Items.Clear();
List <SysDictEntity> lstDict = dacSys.SelectList("deliveryspec");
foreach (SysDictEntity entity in lstDict)
{
specifications.Items.Add(entity.dictvalue);
}
goodname.Items.Clear();
lstDict = dacSys.SelectList("goodname");
foreach (SysDictEntity entity in lstDict)
{
goodname.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("读取数据库出错，请检查网络;\r\n原因:" + ex.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
dtpEnd.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59);
SysDictDAC dacSys = new SysDictDAC();
target.Items.Clear();
try
{
List <SysDictEntity> lstDict = dacSys.SelectList("target");
foreach (SysDictEntity entity in lstDict)
{
target.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("数据库错误，请联系管理员");
}
Refresh();
}
private void InitGrid()
{
GridPanel panel = superGrid.PrimaryGrid;
try
{
SysDictDAC dacSys = new SysDictDAC();
List <SysDictEntity> lstDict = dacSys.SelectList("deliveryspec");
if (lstDict.Count > 0)
{
string[] specArray = new string[lstDict.Count];
int i = 0;
foreach (SysDictEntity entity in lstDict)
{
specArray[i] = entity.dictvalue;
i++;
}
panel.Columns["specifications"].EditorType = typeof(FragrantComboBox);
panel.Columns["specifications"].EditorParams = new object[] { specArray };
}
}
catch (Exception ex)
{
MessageBox.Show("提取字典出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
if (objNote != null & EditMode > 0)
{
if (EditMode == 2)
{
noteid.Text = objNote.noteid.ToString();
deliverid.Text = objNote.deliverid.ToString().PadLeft(3, '0');
customer.Enabled = false;
}
customer.Text = objNote.customer;
model.Text = objNote.model;
deliverdate.Value = objNote.deliverdate;
goodname.Text = objNote.goodname;
batch.Text = objNote.batch;
description.Text = objNote.description;
description1.Text = objNote.description1;
if (objNote.items != null)
{
foreach (DeliveryItem item in objNote.items)
{
GridRow newRow = new GridRow(
item.jiannum,
item.specifications,
item.lenght,
item.discnum,
item.weight,
Math.Round(item.price, 5),
Math.Round(item.totalprice, 5),
item.contractno,
item.netweight,
item.coreweight
);
panel.Rows.Add(newRow);
}
}
}
}
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();
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!ControlHelper.isNumeric(length.Text))
{
MessageBox.Show("规格必须为数字!");
length.Focus();
return;
}
if (batch.Text.Trim().Length == 0)
{
MessageBox.Show("必须输入批号");
batch.Focus();
return;
}
try
{
SysDictDAC dacSys = new SysDictDAC();
SysDictEntity objEntity = dacSys.Select("qtspec", specifications.Text.Trim());
if (objEntity == null)
{
SysDictEntity newSysEntity = new SysDictEntity();
newSysEntity.dictype = "qtspec";
newSysEntity.dictvalue = specifications.Text.Trim();
dacSys.Add(newSysEntity);
}
objEntity = dacSys.Select("qtcategory", category.Text.Trim());
if (objEntity == null)
{
SysDictEntity newSysEntity = new SysDictEntity();
newSysEntity.dictype = "qtcategory";
newSysEntity.dictvalue = category.Text.Trim();
dacSys.Add(newSysEntity);
}
objEntity = dacSys.Select("target", target.Text.Trim());
if (objEntity == null)
{
SysDictEntity newSysEntity = new SysDictEntity();
newSysEntity.dictype = "target";
newSysEntity.dictvalue = target.Text.Trim();
dacSys.Add(newSysEntity);
}
}
catch (Exception ex)
{
MessageBox.Show("保存字典出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
QualityTrackingDAC dac = new QualityTrackingDAC();
if (EditMode == 0 || EditMode == 1)
{
QualityTrackingEntity entity = new QualityTrackingEntity();
entity.qtdate = qtdate.Value;
entity.category = category.Text;
entity.batch = batch.Text;
entity.specifications = specifications.Text;
if (length.Text.Trim().Length == 0)
{
entity.length = 0;
}
else
{
entity.length = int.Parse(length.Text);
}
entity.volume = volume.Text;
entity.stripping1 = stripping1.Text;
entity.stripping2 = stripping2.Text;
entity.sample11 = sample11.Text;
entity.sample12 = sample12.Text;
entity.sample13 = sample13.Text;
entity.sample21 = sample21.Text;
entity.sample22 = sample22.Text;
entity.sample23 = sample23.Text;
entity.baseheight = baseheight.Text;
entity.measuredheight = measuredheight.Text;
entity.compositeheight = compositeheight.Text;
entity.cutheight = cutheight.Text;
entity.bubblewater1 = bubblewater1.Text;
entity.bubblewater2 = bubblewater2.Text;
entity.bubbleoil = bubbleoil.Text;
entity.descrtiption = descrtiption.Text;
entity.loginid = Global.LoginUser.loginid;
entity.target = target.Text;
entity.elongation = elongation.Text.Trim();
entity.elongation1 = elongation1.Text.Trim();
entity.type = type.Text;
entity.decision = decision.Text;
int id = 0;
try
{
id = dac.Insert(entity);
}
catch (Exception ex)
{
MessageBox.Show("新增出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
if (id > 0)
{
if (MessageBox.Show("保存成功,是否继续添加?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
batch.Text = "";
qtdate.Focus();
}
else
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
MessageBox.Show("保存失败!");
}
}
else
{
if (objTracking == null)
{
MessageBox.Show("系统错误");
return;
}
objTracking.qtdate = qtdate.Value;
objTracking.category = category.Text;
objTracking.batch = batch.Text;
objTracking.specifications = specifications.Text;
if (length.Text.Trim().Length == 0)
{
objTracking.length = 0;
}
else
{
objTracking.length = int.Parse(length.Text);
}
objTracking.volume = volume.Text;
objTracking.stripping1 = stripping1.Text;
objTracking.stripping2 = stripping2.Text;
objTracking.sample11 = sample11.Text;
objTracking.sample12 = sample12.Text;
objTracking.sample13 = sample13.Text;
objTracking.sample21 = sample21.Text;
objTracking.sample22 = sample22.Text;
objTracking.sample23 = sample23.Text;
objTracking.baseheight = baseheight.Text;
objTracking.measuredheight = measuredheight.Text;
objTracking.compositeheight = compositeheight.Text;
objTracking.cutheight = cutheight.Text;
objTracking.bubblewater1 = bubblewater1.Text;
objTracking.bubblewater2 = bubblewater2.Text;
objTracking.bubbleoil = bubbleoil.Text;
objTracking.descrtiption = descrtiption.Text;
objTracking.loginid = Global.LoginUser.loginid;
objTracking.target = target.Text;
objTracking.elongation = elongation.Text;
objTracking.elongation1 = elongation1.Text;
objTracking.type = type.Text;
objTracking.decision = decision.Text;
int id = 0;
try
{
id = dac.Update(objTracking);
}
catch (Exception ex)
{
MessageBox.Show("保存出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
if (id > 0)
{
MessageBox.Show("保存成功");
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("保存失败!");
}
}
}
private void frmQualityTracking_Load(object sender, EventArgs e)
{
try
{
SysDictDAC dacSys = new SysDictDAC();
specifications.Items.Clear();
List <SysDictEntity> lstDict = dacSys.SelectList("qtspec");
foreach (SysDictEntity entity in lstDict)
{
specifications.Items.Add(entity.dictvalue);
}
category.Items.Clear();
lstDict = dacSys.SelectList("qtcategory");
foreach (SysDictEntity entity in lstDict)
{
category.Items.Add(entity.dictvalue);
}
target.Items.Clear();
lstDict = dacSys.SelectList("target");
foreach (SysDictEntity entity in lstDict)
{
target.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("提取字典出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
if (objTracking != null & EditMode > 0)
{
qtdate.Value = objTracking.qtdate;
category.Text = objTracking.category;
if (EditMode == 1)
{
batch.Text = "";
}
else
{
batch.Text = objTracking.batch;
}
specifications.Text = objTracking.specifications;
length.Text = objTracking.length.ToString();
volume.Text = objTracking.volume;
stripping1.Text = objTracking.stripping1;
stripping2.Text = objTracking.stripping2;
sample11.Text = objTracking.sample11;
sample12.Text = objTracking.sample12;
sample13.Text = objTracking.sample13;
sample21.Text = objTracking.sample21;
sample22.Text = objTracking.sample22;
sample23.Text = objTracking.sample23;
baseheight.Text = objTracking.baseheight;
measuredheight.Text = objTracking.measuredheight;
compositeheight.Text = objTracking.compositeheight;
cutheight.Text = objTracking.cutheight;
bubblewater1.Text = objTracking.bubblewater1;
bubblewater2.Text = objTracking.bubblewater2;
bubbleoil.Text = objTracking.bubbleoil;
descrtiption.Text = objTracking.descrtiption;
target.Text = objTracking.target;
elongation.Text = objTracking.elongation;
elongation1.Text = objTracking.elongation1;
if (objTracking.type != null)
{
type.Text = objTracking.type;
}
if (objTracking.decision != null)
{
decision.Text = objTracking.decision;
}
}
}
