public FormFinishedProList()
{
InitializeComponent();
InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true);
InitDataUtil.BindComboBoxData(brand, FishEntity.Constant.Brand, true);
country.SelectedValueChanged -= country_SelectedValueChanged;
InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true);
country.SelectedValueChanged += country_SelectedValueChanged;
MenuCode = "M460"; ControlButtomRoles();
_model = new FishEntity.FinishedProListEntity();
_bll = new FishBll.Bll.FinishedProListBll();
InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true);
InitDataUtil.BindComboBoxData(brand, FishEntity.Constant.Brand, true);
}
public override int Query()
{
_bll = new FishBll.Bll.FinishedProListBll();
strWhere = " 1=1 ";
DataTable table = _bll.getTable(strWhere);
strWhere = string.Empty;
if (table != null && table.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
for (int i = 0; i < table.Rows.Count; i++)
{
int idx = dataGridView1.Rows.Add();
DataGridViewRow row = dataGridView1.Rows[idx];
row.Cells["CODE"].Value = table.Rows[i]["CODE"].ToString();
row.Cells["plCode"].Value = table.Rows[i]["plCode"].ToString();
row.Cells["date"].Value = table.Rows[i]["date"].ToString();
row.Cells["country"].Value = table.Rows[i]["country"].ToString();
row.Cells["brand"].Value = table.Rows[i]["brand"].ToString();
row.Cells["fishId"].Value = table.Rows[i]["fishId"].ToString();
row.Cells["price"].Value = table.Rows[i]["price"].ToString();
row.Cells["qualitySpe"].Value = table.Rows[i]["qualitySpe"].ToString();
row.Cells["goods"].Value = table.Rows[i]["goods"].ToString();
row.Cells["tons"].Value = table.Rows[i]["tons"].ToString();
row.Cells["protein"].Value = table.Rows[i]["protein"].ToString();
row.Cells["tvn"].Value = table.Rows[i]["tvn"].ToString();
row.Cells["salt"].Value = table.Rows[i]["salt"].ToString();
row.Cells["acid"].Value = table.Rows[i]["acid"].ToString();
row.Cells["ash"].Value = table.Rows[i]["ash"].ToString();
row.Cells["histamine"].Value = table.Rows[i]["histamine"].ToString();
row.Cells["las"].Value = table.Rows[i]["las"].ToString();
row.Cells["das"].Value = table.Rows[i]["das"].ToString();
row.Cells["remark"].Value = table.Rows[i]["remark"].ToString();
row.Cells["zf"].Value = table.Rows[i]["zf"].ToString();
row.Cells["billName"].Value = table.Rows[i]["billName"].ToString();
row.Cells["zjh"].Value = table.Rows[i]["zjh"].ToString();
row.Cells["shipname"].Value = table.Rows[i]["shipname"].ToString();
row.Cells["id"].Value = table.Rows[i]["id"].ToString();
row.Cells["CkCode"].Value = table.Rows[i]["CkCode"].ToString();
row.Cells["ffa"].Value = table.Rows[i]["ffa"].ToString();
}
}
else
{
MessageBox.Show("查无数据！");
} return(base.Query());
}
public FormFinishedProductAssociation(string fishId)
{
InitializeComponent();
ReadColumnConfig(dataGridView1, "Set_cpgl");
tmiQuery.Visible = false;
tmiSave.Visible = false;
tmiReview.Visible = false;
tmiprint.Visible = false;
tmiPrevious.Visible = false;
tmiNext.Visible = false;
tmiModify.Visible = false;
tmiExport.Visible = false;
tmiDelete.Visible = false;
tmiClose.Visible = false;
tmiCancel.Visible = false;
tmiAdd.Visible = true;
_bll = new FishBll.Bll.FinishedProListBll();
name = name1 = fishId; Query();
}
private void FormFinishedProList_Load(object sender, EventArgs e)
{
MenuCode = "M460"; ControlButtomRoles();
InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true);
InitDataUtil.BindComboBoxData(brand, FishEntity.Constant.Brand, true);
_model = new FishEntity.FinishedProListEntity();
_bll = new FishBll.Bll.FinishedProListBll();
if (Megres.oddNum != null && Megres.oddNum != "")
{
_model = _bll.getModel(" code= '" + Megres.oddNum + "' ");
if (_model == null)
{
MessageBox.Show("没有记录了");
}
else
{
setValue();
}
}
}
public FormFinishedProList(string name)
{
InitializeComponent();
MenuCode = "M460"; ControlButtomRoles();
_model = new FishEntity.FinishedProListEntity();
_bll = new FishBll.Bll.FinishedProListBll();
getname1 = name;
InitDataUtil.BindComboBoxData(country, FishEntity.Constant.CountryType, true);
InitDataUtil.BindComboBoxData(brand, FishEntity.Constant.Brand, true);
if (getname1 != "" && getname1 != null)
{
_model = new FishEntity.FinishedProListEntity();
_bll = new FishBll.Bll.FinishedProListBll();
_model = _bll.getModel(" plCode= '" + getname1 + "' ");
if (_model == null)
{
// MessageBox.Show("没有记录了");
}
else
{
setValue();
}
}
}
private void FormFinishedProListQuery_Load(object sender, EventArgs e)
{
FishBll.Bll.FinishedProListBll _bll = new FishBll.Bll.FinishedProListBll( );
comboBox1.DataSource = _bll.getCodeT( );
comboBox1.DisplayMember = "code";
}
