/// <summary>
/// 插入JSKLBB数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertTranLbb(JiuGongEntity.FormEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO JSKLBB (LBB001,LBB002,LBB003,LBB005,LBB006,LBB007,LBB010,LBB019,LBB905)");
strSql.Append(" VALUES(");
strSql.Append("@LBB001,@LBB002,@LBB003,@LBB005,@LBB006,@LBB007,@LBB010,@LBB019,@LBB905)");
SqlParameter[] parameter =
{
new SqlParameter("@LBB001", SqlDbType.NVarChar),
new SqlParameter("@LBB002", SqlDbType.NVarChar),
new SqlParameter("@LBB003", SqlDbType.NVarChar),
new SqlParameter("@LBB005", SqlDbType.NVarChar),
new SqlParameter("@LBB007", SqlDbType.Int),
new SqlParameter("@LBB010", SqlDbType.NVarChar),
new SqlParameter("@LBB019", SqlDbType.NVarChar),
new SqlParameter("@LBB905", SqlDbType.Int),
new SqlParameter("@LBB006", SqlDbType.NVarChar)
};
parameter[0].Value = model.LBA001;
parameter[1].Value = model.LBB002;
parameter[2].Value = model.LBB003;
parameter[3].Value = model.LBB005;
parameter[4].Value = model.LBB007;
parameter[5].Value = model.LBB010;
parameter[6].Value = model.LBB019;
parameter[7].Value = model.LBB905;
parameter[8].Value = model.LBB006;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 插入JSKLBB数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertTranLbb(JiuGongEntity.FormEntity model)
{
return(dao.InsertTranLbb(model));
}
