public int UpdateAttribute1(CategoryAttribute1Info oParam)
{
string sql = @"UPDATE Category_Attribute1 SET
C3SysNo=@C3SysNo,
Attribute1ID=@Attribute1ID, Attribute1Name=@Attribute1Name,
OrderNum=@OrderNum, Status=@Status,Attribute1Type=@Attribute1Type
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute1ID = new SqlParameter("@Attribute1ID", SqlDbType.NVarChar, 20);
SqlParameter paramAttribute1Name = new SqlParameter("@Attribute1Name", SqlDbType.NVarChar, 50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramAttribute1Type = new SqlParameter("@Attribute1Type", SqlDbType.Int, 4);
paramSysNo.Value = oParam.SysNo;
paramC3SysNo.Value = oParam.C3SysNo;
paramAttribute1ID.Value = oParam.Attribute1ID;
paramAttribute1Name.Value = oParam.Attribute1Name;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttribute1Type.Value = oParam.Attribute1Type;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramC3SysNo);
cmd.Parameters.Add(paramAttribute1ID);
cmd.Parameters.Add(paramAttribute1Name);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttribute1Type);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public bool IsExistAttribute1(CategoryAttribute1Info oParam)
{
string sql = "select top 1 sysno from category_attribute1 where c3sysno=@c3sysno and Attribute1Name=@Attribute1Name and SysNo!=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute1Name = new SqlParameter("@Attribute1Name", SqlDbType.NVarChar, 50);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
paramC3SysNo.Value = oParam.C3SysNo;
paramAttribute1Name.Value = oParam.Attribute1Name;
paramSysNo.Value = oParam.SysNo;
cmd.Parameters.Add(paramC3SysNo);
cmd.Parameters.Add(paramAttribute1Name);
cmd.Parameters.Add(paramSysNo);
DataSet ds = SqlHelper.ExecuteDataSet(cmd);;
if (Util.HasMoreRow(ds))
{
return(true);
}
else
{
return(false);
}
}
public int SetOrderNum(CategoryAttribute1Info oParam)
{
string sql = "update category_attribute1 set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
SqlCommand cmd = new SqlCommand(sql);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int GetCatetoryAttribute1NewOrderNum(CategoryAttribute1Info oParam)
{
string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from Category_Attribute1 where C3SysNo=" + oParam.C3SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
return(Int32.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
else
{
return(1);
}
}
public int InsertAttribute1(CategoryAttribute1Info oParam)
{
string sql = @"INSERT INTO Category_Attribute1
(
C3SysNo, Attribute1ID, Attribute1Name,
OrderNum, Status, Attribute1Type
)
VALUES (
@C3SysNo, @Attribute1ID, @Attribute1Name,
@OrderNum, @Status, @Attribute1Type
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute1ID = new SqlParameter("@Attribute1ID", SqlDbType.NVarChar, 20);
SqlParameter paramAttribute1Name = new SqlParameter("@Attribute1Name", SqlDbType.NVarChar, 50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramAttribute1Type = new SqlParameter("@Attribute1Type", SqlDbType.Int, 4);
paramC3SysNo.Value = oParam.C3SysNo;
paramAttribute1ID.Value = oParam.Attribute1ID;
paramAttribute1Name.Value = oParam.Attribute1Name;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttribute1Type.Value = oParam.Attribute1Type;
cmd.Parameters.Add(paramC3SysNo);
cmd.Parameters.Add(paramAttribute1ID);
cmd.Parameters.Add(paramAttribute1Name);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttribute1Type);
return(SqlHelper.ExecuteNonQuery(cmd));
}
