public bool Exists_Edit(FishEntity.WarnEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM t_warn where orderNum='{0}' and reviewUserNum='{1}' and examineUserNum='{2}' and id!={3} ", model.orderNum, model.reviewUserNum, model.examineUserNum, model.id);
return(MySqlHelper.Exists(strSql.ToString( )));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(FishEntity.WarnEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_warn(");
strSql.Append("orderName,orderNum,position,reviewUserName,reviewUserNum,examineUserName,examineUserNum,order1Name,order1Num,order2Name,order2Num,order3Name,order3Num,order4Name,order4Num,order5Name,order5Num)");
strSql.Append(" values (");
strSql.Append("@orderName,@orderNum,@position,@reviewUserName,@reviewUserNum,@examineUserName,@examineUserNum,@order1Name,@order1Num,@order2Name,@order2Num,@order3Name,@order3Num,@order4Name,@order4Num,@order5Name,@order5Num)");
strSql.Append(";select @@IDENTITY; ");
MySqlParameter [] parameters =
{
new MySqlParameter("@orderName", MySqlDbType.VarChar, 45),
new MySqlParameter("@orderNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@position", MySqlDbType.VarChar, 45),
new MySqlParameter("@reviewUserName", MySqlDbType.VarChar, 45),
new MySqlParameter("@reviewUserNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@examineUserName", MySqlDbType.VarChar, 45),
new MySqlParameter("@examineUserNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@order1Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order1Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order2Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order2Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order3Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order3Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order4Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order4Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order5Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order5Num", MySqlDbType.VarChar, 45)
};
parameters [0].Value = model.orderName;
parameters [1].Value = model.orderNum;
parameters [2].Value = model.position;
parameters [3].Value = model.reviewUserName;
parameters [4].Value = model.reviewUserNum;
parameters [5].Value = model.examineUserName;
parameters [6].Value = model.examineUserNum;
parameters [7].Value = model.order1Name;
parameters [8].Value = model.order1Num;
parameters [9].Value = model.order2Name;
parameters [10].Value = model.order2Num;
parameters [11].Value = model.order3Name;
parameters [12].Value = model.order3Num;
parameters [13].Value = model.order4Name;
parameters [14].Value = model.order4Num;
parameters [15].Value = model.order5Name;
parameters [16].Value = model.order5Num;
return(MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters));
}
public FormWarn( )
{
InitializeComponent( );
ReadColumnConfig(dataGridView1, "Set_148");
_bll = new FishBll.Bll.WarnBll( );
_model = new FishEntity.WarnEntity( );
proDic = ProgramManager.setDicItem( );
BindingSource bs = new BindingSource( );
bs.DataSource = proDic;
comboBox1.DataSource = bs;
comboBox1.DisplayMember = "Value";
comboBox1.ValueMember = "Key";
}
public FishEntity.WarnEntity getModel(DataRow row)
{
FishEntity.WarnEntity model = new FishEntity.WarnEntity( );
if (row != null)
{
if (row ["id"] != null && row ["id"].ToString( ) != "")
{
model.id = int.Parse(row ["id"].ToString( ));
}
if (row ["orderName"] != null)
{
model.orderName = row ["orderName"].ToString( );
}
if (row ["orderNum"] != null)
{
model.orderNum = row ["orderNum"].ToString( );
}
if (row ["position"] != null)
{
model.position = row ["position"].ToString( );
}
if (row ["reviewUserName"] != null)
{
model.reviewUserName = row ["reviewUserName"].ToString( );
}
if (row ["reviewUserNum"] != null)
{
model.reviewUserNum = row ["reviewUserNum"].ToString( );
}
if (row ["examineUserName"] != null)
{
model.examineUserName = row ["examineUserName"].ToString( );
}
if (row ["examineUserNum"] != null)
{
model.examineUserNum = row ["examineUserNum"].ToString( );
}
if (row ["order1Name"] != null)
{
model.order1Name = row ["order1Name"].ToString( );
}
if (row ["order1Num"] != null)
{
model.order1Num = row ["order1Num"].ToString( );
}
if (row ["order2Name"] != null)
{
model.order2Name = row ["order2Name"].ToString( );
}
if (row ["order2Num"] != null)
{
model.order2Num = row ["order2Num"].ToString( );
}
if (row ["order3Name"] != null)
{
model.order3Name = row ["order3Name"].ToString( );
}
if (row ["order3Num"] != null)
{
model.order3Num = row ["order3Num"].ToString( );
}
if (row ["order4Name"] != null)
{
model.order4Name = row ["order4Name"].ToString( );
}
if (row ["order4Num"] != null)
{
model.order4Num = row ["order4Num"].ToString( );
}
if (row ["order5Name"] != null)
{
model.order5Name = row ["order5Name"].ToString( );
}
if (row ["order5Num"] != null)
{
model.order5Num = row ["order5Num"].ToString( );
}
}
return(model);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(FishEntity.WarnEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update t_warn set ");
strSql.Append("orderName=@orderName,");
strSql.Append("orderNum=@orderNum,");
strSql.Append("position=@position,");
strSql.Append("reviewUserName=@reviewUserName,");
strSql.Append("reviewUserNum=@reviewUserNum,");
strSql.Append("examineUserName=@examineUserName,");
strSql.Append("examineUserNum=@examineUserNum,");
strSql.Append("order1Name=@order1Name,");
strSql.Append("order1Num=@order1Num,");
strSql.Append("order2Name=@order2Name,");
strSql.Append("order2Num=@order2Num,");
strSql.Append("order3Name=@order3Name,");
strSql.Append("order3Num=@order3Num,");
strSql.Append("order4Name=@order4Name,");
strSql.Append("order4Num=@order4Num,");
strSql.Append("order5Name=@order5Name,");
strSql.Append("order5Num=@order5Num");
strSql.Append(" where id=@id");
MySqlParameter [] parameters =
{
new MySqlParameter("@orderName", MySqlDbType.VarChar, 45),
new MySqlParameter("@orderNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@position", MySqlDbType.VarChar, 45),
new MySqlParameter("@reviewUserName", MySqlDbType.VarChar, 45),
new MySqlParameter("@reviewUserNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@examineUserName", MySqlDbType.VarChar, 45),
new MySqlParameter("@examineUserNum", MySqlDbType.VarChar, 45),
new MySqlParameter("@order1Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order1Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order2Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order2Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order3Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order3Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order4Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order4Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@order5Name", MySqlDbType.VarChar, 45),
new MySqlParameter("@order5Num", MySqlDbType.VarChar, 45),
new MySqlParameter("@id", MySqlDbType.Int32, 10)
};
parameters [0].Value = model.orderName;
parameters [1].Value = model.orderNum;
parameters [2].Value = model.position;
parameters [3].Value = model.reviewUserName;
parameters [4].Value = model.reviewUserNum;
parameters [5].Value = model.examineUserName;
parameters [6].Value = model.examineUserNum;
parameters [7].Value = model.order1Name;
parameters [8].Value = model.order1Num;
parameters [9].Value = model.order2Name;
parameters [10].Value = model.order2Num;
parameters [11].Value = model.order3Name;
parameters [12].Value = model.order3Num;
parameters [13].Value = model.order4Name;
parameters [14].Value = model.order4Num;
parameters [15].Value = model.order5Name;
parameters [16].Value = model.order5Num;
parameters [17].Value = model.id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString( ), parameters);
return(rows > 0 ? true : false);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(FishEntity.WarnEntity model)
{
return(dal.Edit(model));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(FishEntity.WarnEntity model)
{
return(dal.Save(model));
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(FishEntity.WarnEntity model)
{
return(dal.Exists(model));
}