public int Insert(OnlineListProductInfo oParam)
{
string sql = @"INSERT INTO OnlineListProduct
(
OnlineAreaType, OnlineRecommendType, CategorySysNo, ProductSysNo,
CreateUserSysNo, CreateTime, ListOrder
)
VALUES (
@OnlineAreaType, @OnlineRecommendType, @CategorySysNo, @ProductSysNo,
@CreateUserSysNo, @CreateTime, @ListOrder
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramOnlineAreaType = new SqlParameter("@OnlineAreaType", SqlDbType.Int, 4);
SqlParameter paramOnlineRecommendType = new SqlParameter("@OnlineRecommendType", SqlDbType.Int, 4);
SqlParameter paramCategorySysNo = new SqlParameter("@CategorySysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramListOrder = new SqlParameter("@ListOrder", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.OnlineAreaType != AppConst.IntNull)
{
paramOnlineAreaType.Value = oParam.OnlineAreaType;
}
else
{
paramOnlineAreaType.Value = System.DBNull.Value;
}
if (oParam.OnlineRecommendType != AppConst.IntNull)
{
paramOnlineRecommendType.Value = oParam.OnlineRecommendType;
}
else
{
paramOnlineRecommendType.Value = System.DBNull.Value;
}
if (oParam.CategorySysNo != AppConst.IntNull)
{
paramCategorySysNo.Value = oParam.CategorySysNo;
}
else
{
paramCategorySysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.ListOrder != AppConst.IntNull)
{
paramListOrder.Value = oParam.ListOrder;
}
else
{
paramListOrder.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramOnlineAreaType);
cmd.Parameters.Add(paramOnlineRecommendType);
cmd.Parameters.Add(paramCategorySysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramListOrder);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public int Update(OnlineListProductInfo oParam)
{
string sql = @"UPDATE OnlineListProduct SET
OnlineAreaType=@OnlineAreaType, OnlineRecommendType=@OnlineRecommendType,
CategorySysNo=@CategorySysNo, ProductSysNo=@ProductSysNo,
CreateUserSysNo=@CreateUserSysNo, CreateTime=@CreateTime,
ListOrder=@ListOrder
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramOnlineAreaType = new SqlParameter("@OnlineAreaType", SqlDbType.Int, 4);
SqlParameter paramOnlineRecommendType = new SqlParameter("@OnlineRecommendType", SqlDbType.Int, 4);
SqlParameter paramCategorySysNo = new SqlParameter("@CategorySysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramListOrder = new SqlParameter("@ListOrder", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.OnlineAreaType != AppConst.IntNull)
{
paramOnlineAreaType.Value = oParam.OnlineAreaType;
}
else
{
paramOnlineAreaType.Value = System.DBNull.Value;
}
if (oParam.OnlineRecommendType != AppConst.IntNull)
{
paramOnlineRecommendType.Value = oParam.OnlineRecommendType;
}
else
{
paramOnlineRecommendType.Value = System.DBNull.Value;
}
if (oParam.CategorySysNo != AppConst.IntNull)
{
paramCategorySysNo.Value = oParam.CategorySysNo;
}
else
{
paramCategorySysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.ListOrder != AppConst.IntNull)
{
paramListOrder.Value = oParam.ListOrder;
}
else
{
paramListOrder.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramOnlineAreaType);
cmd.Parameters.Add(paramOnlineRecommendType);
cmd.Parameters.Add(paramCategorySysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramListOrder);
return(SqlHelper.ExecuteNonQuery(cmd));
}