public FormBatchSheetQuery(string text)
{
InitializeComponent( );
this.Text = text;
_bll = new FishBll.Bll.BatchSheetBll( );
}
public FormBatchSheet( )
{
InitializeComponent( );
ReadColumnConfig(dataGridView1, "Set_101");
ReadColumnConfig(dataGridView2, "Set_102");
MenuCode = "M459"; ControlButtomRoles();
_bll = new FishBll.Bll.BatchSheetBll( );
_model = new FishEntity.BatchSheetEntity( );
_models = new FishEntity.BatchSheetsEntity( );
//readonlyCol ( );
}
public override int Query()
{
_bll = new FishBll.Bll.BatchSheetBll();
if (name != "" && name != null)
{
strWhere += " 1= 1 and codeNum='" + name + "' ";
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["id"].Value = table.Rows[i]["id"].ToString();
row.Cells["id1"].Value = table.Rows[i]["id1"].ToString();
row.Cells["CODE"].Value = table.Rows[i]["CODE"].ToString();
row.Cells["productionDate"].Value = table.Rows[i]["productionDate"].ToString();
row.Cells["fishId"].Value = table.Rows[i]["fishId"].ToString();
row.Cells["codeNum"].Value = table.Rows[i]["codeNum"].ToString();
row.Cells["codeNumContract"].Value = table.Rows[i]["codeNumContract"].ToString();
row.Cells["qualitySpe"].Value = table.Rows[i]["qualitySpe"].ToString();
row.Cells["country"].Value = table.Rows[i]["country"].ToString();
row.Cells["brand"].Value = table.Rows[i]["brand"].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["das"].Value = table.Rows[i]["das"].ToString();
row.Cells["price"].Value = table.Rows[i]["price"].ToString();
row.Cells["cost"].Value = table.Rows[i]["cost"].ToString();
row.Cells["rkCode"].Value = table.Rows[i]["rkCode"].ToString();
}
}
else
{
MessageBox.Show("查无数据！");
}
}
else
{
MessageBox.Show("采购编号没有带入！");
}
return(base.Query());
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (dataGridView1.CurrentRow == null)
{
return;
}
if (dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString() != "" && dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString() != null)
{
getcode = " isSum = 0 and a.code=" + dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString();
_bll = new FishBll.Bll.BatchSheetBll();
DataTable table = _bll.getTable(getcode);
strWhere = string.Empty;
if (table != null && table.Rows.Count > 0)
{
dataGridView2.Rows.Clear();
for (int i = 0; i < table.Rows.Count; i++)
{
int idx = dataGridView2.Rows.Add();
DataGridViewRow row = dataGridView2.Rows[idx];
row.Cells["id2"].Value = table.Rows[i]["id"].ToString();
row.Cells["id12"].Value = table.Rows[i]["id1"].ToString();
row.Cells["CODE2"].Value = table.Rows[i]["CODE"].ToString();
row.Cells["productionDate2"].Value = table.Rows[i]["productionDate"].ToString();
row.Cells["fishId2"].Value = table.Rows[i]["fishId"].ToString();
row.Cells["codeNum2"].Value = table.Rows[i]["codeNum"].ToString();
row.Cells["codeNumContract2"].Value = table.Rows[i]["codeNumContract"].ToString();
row.Cells["qualitySpe2"].Value = table.Rows[i]["qualitySpe"].ToString();
row.Cells["country2"].Value = table.Rows[i]["country"].ToString();
row.Cells["brand2"].Value = table.Rows[i]["brand"].ToString();
row.Cells["goods2"].Value = table.Rows[i]["goods"].ToString();
row.Cells["tons2"].Value = table.Rows[i]["tons"].ToString();
row.Cells["protein2"].Value = table.Rows[i]["protein"].ToString();
row.Cells["tvn2"].Value = table.Rows[i]["tvn"].ToString();
row.Cells["salt2"].Value = table.Rows[i]["salt"].ToString();
row.Cells["acid2"].Value = table.Rows[i]["acid"].ToString();
row.Cells["ash2"].Value = table.Rows[i]["ash"].ToString();
row.Cells["histamine2"].Value = table.Rows[i]["histamine"].ToString();
row.Cells["das2"].Value = table.Rows[i]["das"].ToString();
row.Cells["price2"].Value = table.Rows[i]["price"].ToString();
row.Cells["cost2"].Value = table.Rows[i]["cost"].ToString();
row.Cells["rkCode2"].Value = table.Rows[i]["rkCode"].ToString();
}
}
}
}
//fishid
public string fishid()
{
_models = new FishEntity.BatchSheetsEntity();
FishBll.Bll.BatchSheetBll bll = new FishBll.Bll.BatchSheetBll();
_models.fishId = bll.fishid();
string str = string.Empty;
int sum = 0;
if (_models.fishId == string.Empty)
{
str = "CP" + "10000001";
}
else
{
sum = int.Parse(_models.fishId) + 1;
str = "CP" + sum;
}
return(str);
}
public FormBatchSheet(string code)
{
InitializeComponent();
ReadColumnConfig(dataGridView1, "Set_101");
ReadColumnConfig(dataGridView2, "Set_102");
MenuCode = "M459"; ControlButtomRoles();
_bll = new FishBll.Bll.BatchSheetBll();
_model = new FishEntity.BatchSheetEntity();
_models = new FishEntity.BatchSheetsEntity();
readonlyCol();
if (code != null && code != "")
{
_model = _bll.getModel(" code='" + code + "' ");
code = string.Empty;
if (_model != null)
{
txtCode.Text = _model.code;
if (_model.productionDate < DateTime.MaxValue && _model.productionDate > DateTime.MinValue)
{
datePro.Value = Convert.ToDateTime(_model.productionDate);
}
if (string.IsNullOrEmpty(_model.code))
{
return;
}
List <FishEntity.BatchSheetsEntity> modelList = _bll.modelList(_model.code);
if (modelList == null || modelList.Count < 0)
{
return;
}
setValue(modelList);
}
else
{
_model = new FishEntity.BatchSheetEntity();
}
}
}
public string Numbering()
{
_models = new FishEntity.BatchSheetsEntity();
FishBll.Bll.BatchSheetBll bll = new FishBll.Bll.BatchSheetBll();
_models.codeNum = bll.Numbering();
string str = string.Empty;
int sum = 0;
if (_models.codeNum == string.Empty)
{
str = DateTime.Now.Year.ToString() + "P" + "0001001";
}
else
{
sum = int.Parse(_models.codeNum) + 1000;
_models.codeNum = sum.ToString();
while (_models.codeNum.Length != 7)
{
_models.codeNum = "0" + _models.codeNum;
}
str = DateTime.Now.Year.ToString() + "P" + _models.codeNum;
}
return(str);
}
