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 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;
}
}
}