/// <summary>
/// 保存一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save(FishEntity.CustomStandardTableEntity model, string name)
{
Hashtable SQLString = new Hashtable( );
SQLString = ReviewInfo.getSQLString(name, model.code, string.Empty, SQLString);
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_customstandardtable(");
strSql.Append("code,ash,protein,xd,fat,ffa,water,histamine,shy,level,fishId,xsCode,TVN)");
strSql.Append(" values (");
strSql.Append("@code,@ash,@protein,@xd,@fat,@ffa,@water,@histamine,@shy,@level,@fishId,@xsCode,@TVN)");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@ash", MySqlDbType.VarChar, 45),
new MySqlParameter("@protein", MySqlDbType.VarChar, 45),
new MySqlParameter("@xd", MySqlDbType.VarChar, 45),
new MySqlParameter("@fat", MySqlDbType.VarChar, 45),
new MySqlParameter("@ffa", MySqlDbType.VarChar, 45),
new MySqlParameter("@water", MySqlDbType.VarChar, 45),
new MySqlParameter("@histamine", MySqlDbType.VarChar, 45),
new MySqlParameter("@shy", MySqlDbType.VarChar, 45),
new MySqlParameter("@level", MySqlDbType.VarChar, 45),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@xsCode", MySqlDbType.VarChar, 45),
new MySqlParameter("@TVN", MySqlDbType.VarChar, 45)
};
parameters [0].Value = model.code;
parameters [1].Value = model.ash;
parameters [2].Value = model.protein;
parameters [3].Value = model.xd;
parameters [4].Value = model.fat;
parameters [5].Value = model.ffa;
parameters [6].Value = model.water;
parameters [7].Value = model.histamine;
parameters [8].Value = model.shy;
parameters [9].Value = model.level;
parameters [10].Value = model.fishId;
parameters [11].Value = model.xsCode;
parameters[12].Value = model.TVN;
SQLString.Add(strSql, parameters);
return(MySqlHelper.ExecuteSqlTran(SQLString));
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex < 0 && e.RowIndex < 0)
{
this.DialogResult = DialogResult.Cancel;
}
_model = new FishEntity.CustomStandardTableEntity();
_model.code = dataGridView1.Rows[e.RowIndex].Cells["code"].Value.ToString();
_model.level = dataGridView1.Rows[e.RowIndex].Cells["level"].Value.ToString();
_model.ash = dataGridView1.Rows[e.RowIndex].Cells["ash"].Value.ToString();
_model.protein = dataGridView1.Rows[e.RowIndex].Cells["protein"].Value.ToString();
_model.xd = dataGridView1.Rows[e.RowIndex].Cells["xd"].Value.ToString();;
_model.TVN = dataGridView1.Rows[e.RowIndex].Cells["TVN"].Value.ToString();
_model.fat = dataGridView1.Rows[e.RowIndex].Cells["fat"].Value.ToString();
_model.ffa = dataGridView1.Rows[e.RowIndex].Cells["ffa"].Value.ToString();
_model.water = dataGridView1.Rows[e.RowIndex].Cells["water"].Value.ToString();
_model.histamine = dataGridView1.Rows[e.RowIndex].Cells["histamine"].Value.ToString();
_model.shy = dataGridView1.Rows[e.RowIndex].Cells["shy"].Value.ToString();
_model.fishId = dataGridView1.Rows[e.RowIndex].Cells["fishId"].Value.ToString();
this.DialogResult = DialogResult.OK;
}
/// <summary>
/// 保存一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save ( FishEntity . CustomStandardTableEntity model ,string name)
{
return dal . Save ( model ,name );
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit ( FishEntity . CustomStandardTableEntity model )
{
return dal . Edit ( model );
}
public FishEntity.CustomStandardTableEntity getModel(DataRow row)
{
FishEntity.CustomStandardTableEntity model = new FishEntity.CustomStandardTableEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row ["code"] != null)
{
model.code = row ["code"].ToString( );
}
if (row["TVN"] != null)
{
model.TVN = row["tvn"].ToString();
}
if (row ["ash"] != null)
{
model.ash = row ["ash"].ToString( );
}
if (row ["protein"] != null)
{
model.protein = row ["protein"].ToString( );
}
if (row ["xd"] != null)
{
model.xd = row ["xd"].ToString( );
}
if (row ["fat"] != null)
{
model.fat = row ["fat"].ToString( );
}
if (row ["ffa"] != null)
{
model.ffa = row ["ffa"].ToString( );
}
if (row ["water"] != null)
{
model.water = row ["water"].ToString( );
}
if (row ["histamine"] != null)
{
model.histamine = row ["histamine"].ToString( );
}
if (row ["shy"] != null)
{
model.shy = row ["shy"].ToString( );
}
if (row ["level"] != null)
{
model.level = row ["level"].ToString( );
}
if (row ["fishId"] != null)
{
model.fishId = row ["fishId"].ToString( );
}
if (row ["xsCode"] != null)
{
model.xsCode = row ["xsCode"].ToString( );
}
}
return(model);
}