public int SetOrderNum(CategoryAttribute2OptionInfo oParam)
{
string sql = "update category_attribute2_option set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
SqlCommand cmd = new SqlCommand(sql);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public bool IsExistAttribute2Option(CategoryAttribute2OptionInfo oParam)
{
string sql = "select top 1 sysno from category_attribute2_option where Attribute2SysNo=@Attribute2SysNo and Attribute2OptionName=@Attribute2OptionName and SysNo!=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int, 4);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar, 500);
paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
paramSysNo.Value = oParam.SysNo;
cmd.Parameters.Add(paramAttribute2SysNo);
cmd.Parameters.Add(paramAttribute2OptionName);
cmd.Parameters.Add(paramSysNo);
DataSet ds = SqlHelper.ExecuteDataSet(cmd);
if (Util.HasMoreRow(ds))
{
return(true);
}
else
{
return(false);
}
}
/*
* public int InsertAttributeOption(CategoryAttributeOptionInfo oParam)
* {
* string sql = @"INSERT INTO Category_Attribute_Option
* (
* AttributeSysNo, AttributeOptionName,
* OrderNum, IsRecommend, Status
* )
* VALUES (
* @AttributeSysNo, @AttributeOptionName,
* @OrderNum, @IsRecommend, @Status
* )";
* SqlCommand cmd = new SqlCommand(sql);
*
* SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
* SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);
* SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
* SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
* SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
*
* paramAttributeSysNo.Value = oParam.AttributeSysNo;
* paramAttributeOptionName.Value = oParam.AttributeOptionName;
* paramOrderNum.Value = oParam.OrderNum;
* paramIsRecommend.Value = oParam.IsRecommend;
* paramStatus.Value = oParam.Status;
*
* cmd.Parameters.Add(paramAttributeSysNo);
* cmd.Parameters.Add(paramAttributeOptionName);
* cmd.Parameters.Add(paramOrderNum);
* cmd.Parameters.Add(paramIsRecommend);
* cmd.Parameters.Add(paramStatus);
*
* return SqlHelper.ExecuteNonQuery(cmd);
* }
* public int UpdateAttributeOption(CategoryAttributeOptionInfo oParam)
* {
* string sql = @"UPDATE Category_Attribute_Option SET
* AttributeSysNo=@AttributeSysNo, AttributeOptionName=@AttributeOptionName,
* OrderNum=@OrderNum, IsRecommend=@IsRecommend, Status=@Status
* WHERE SysNo=@SysNo";
* SqlCommand cmd = new SqlCommand(sql);
*
* SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
* SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
* SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);
* SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
* SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
* SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
*
* paramSysNo.Value = oParam.SysNo;
* paramAttributeSysNo.Value = oParam.AttributeSysNo;
* paramAttributeOptionName.Value = oParam.AttributeOptionName;
* paramOrderNum.Value = oParam.OrderNum;
* paramIsRecommend.Value = oParam.IsRecommend;
* paramStatus.Value = oParam.Status;
*
* cmd.Parameters.Add(paramSysNo);
* cmd.Parameters.Add(paramAttributeSysNo);
* cmd.Parameters.Add(paramAttributeOptionName);
* cmd.Parameters.Add(paramOrderNum);
* cmd.Parameters.Add(paramIsRecommend);
* cmd.Parameters.Add(paramStatus);
*
* return SqlHelper.ExecuteNonQuery(cmd);
* }
*
* public bool IsExistAttributeOption(CategoryAttributeOptionInfo oParam)
* {
* string sql = "select top 1 sysno from category_attribute_option where AttributeSysNo=@AttributeSysNo and AttributeOptionName=@AttributeOptionName";
* SqlCommand cmd = new SqlCommand(sql);
* SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
* SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);
*
* paramAttributeSysNo.Value = oParam.AttributeSysNo;
* paramAttributeOptionName.Value = oParam.AttributeOptionName;
*
* cmd.Parameters.Add(paramAttributeSysNo);
* cmd.Parameters.Add(paramAttributeOptionName);
*
* DataSet ds = SqlHelper.ExecuteDataSet(cmd);;
* if ( Util.HasMoreRow(ds))
* return true;
* else
* return false;
* }
*
* public int SetOrderNum(CategoryAttributeOptionInfo oParam)
* {
* string sql = "update category_attribute_option set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
* SqlCommand cmd = new SqlCommand(sql);
* return SqlHelper.ExecuteNonQuery(cmd);
* }
*/
public int InsertAttribute2Option(CategoryAttribute2OptionInfo oParam)
{
string sql = @"INSERT INTO Category_Attribute2_Option
(
Attribute2SysNo, Attribute2OptionName,
OrderNum, IsRecommend, Status
)
VALUES (
@Attribute2SysNo, @Attribute2OptionName,
@OrderNum, @IsRecommend, @Status
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar, 500);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
paramOrderNum.Value = oParam.OrderNum;
paramIsRecommend.Value = oParam.IsRecommend;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramAttribute2SysNo);
cmd.Parameters.Add(paramAttribute2OptionName);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramIsRecommend);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int UpdateAttribute2Option(CategoryAttribute2OptionInfo oParam)
{
string sql = @"UPDATE Category_Attribute2_Option SET
Attribute2SysNo=@Attribute2SysNo, Attribute2OptionName=@Attribute2OptionName,
OrderNum=@OrderNum, IsRecommend=@IsRecommend, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar, 500);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Value = oParam.SysNo;
paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
paramOrderNum.Value = oParam.OrderNum;
paramIsRecommend.Value = oParam.IsRecommend;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramAttribute2SysNo);
cmd.Parameters.Add(paramAttribute2OptionName);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramIsRecommend);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int GetCatetoryAttribute2OptionNewOrderNum(CategoryAttribute2OptionInfo oParam)
{
string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from Category_Attribute2_Option where Attribute2SysNo=" + oParam.Attribute2SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
return(Int32.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
else
{
return(1);
}
}
