public int UpdateAttribute2(CategoryAttribute2Info oParam) { string sql = @"UPDATE Category_Attribute2 SET A1SysNo=@A1SysNo, Attribute2ID=@Attribute2ID, Attribute2Name=@Attribute2Name, OrderNum=@OrderNum, Status=@Status,Attribute2Type=@Attribute2Type WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int, 4); SqlParameter paramAttribute2ID = new SqlParameter("@Attribute2ID", SqlDbType.NVarChar, 20); SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar, 50); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramAttribute2Type = new SqlParameter("@Attribute2Type", SqlDbType.Int, 4); paramSysNo.Value = oParam.SysNo; paramA1SysNo.Value = oParam.A1SysNo; paramAttribute2ID.Value = oParam.Attribute2ID; paramAttribute2Name.Value = oParam.Attribute2Name; paramOrderNum.Value = oParam.OrderNum; paramStatus.Value = oParam.Status; paramAttribute2Type.Value = oParam.Attribute2Type; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramA1SysNo); cmd.Parameters.Add(paramAttribute2ID); cmd.Parameters.Add(paramAttribute2Name); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramAttribute2Type); return(SqlHelper.ExecuteNonQuery(cmd)); }
public bool IsExistAttribute2(CategoryAttribute2Info oParam) { string sql = "select top 1 sysno from category_attribute2 where a1sysno=@a1sysno and Attribute2Name=@Attribute2Name and SysNo!=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int, 4); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar, 50); paramA1SysNo.Value = oParam.A1SysNo; paramAttribute2Name.Value = oParam.Attribute2Name; paramSysNo.Value = oParam.SysNo; cmd.Parameters.Add(paramA1SysNo); cmd.Parameters.Add(paramAttribute2Name); cmd.Parameters.Add(paramSysNo); DataSet ds = SqlHelper.ExecuteDataSet(cmd);; if (Util.HasMoreRow(ds)) { return(true); } else { return(false); } }
public int SetOrderNum(CategoryAttribute2Info oParam) { string sql = "update category_attribute2 set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo; SqlCommand cmd = new SqlCommand(sql); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int GetCatetoryAttribute2NewOrderNum(CategoryAttribute2Info oParam) { string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from Category_Attribute2 where A1SysNo=" + oParam.A1SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { return(Int32.Parse(ds.Tables[0].Rows[0][0].ToString())); } else { return(1); } }
public int InsertAttribute2(CategoryAttribute2Info oParam) { string sql = @"INSERT INTO Category_Attribute2 ( A1SysNo, Attribute2ID, Attribute2Name, OrderNum, Status, Attribute2Type ) VALUES ( @A1SysNo, @Attribute2ID, @Attribute2Name, @OrderNum, @Status, @Attribute2Type )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int, 4); SqlParameter paramAttribute2ID = new SqlParameter("@Attribute2ID", SqlDbType.NVarChar, 20); SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar, 50); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramAttribute2Type = new SqlParameter("@Attribute2Type", SqlDbType.Int, 4); paramA1SysNo.Value = oParam.A1SysNo; paramAttribute2ID.Value = oParam.Attribute2ID; paramAttribute2Name.Value = oParam.Attribute2Name; paramOrderNum.Value = oParam.OrderNum; paramStatus.Value = oParam.Status; paramAttribute2Type.Value = oParam.Attribute2Type; cmd.Parameters.Add(paramA1SysNo); cmd.Parameters.Add(paramAttribute2ID); cmd.Parameters.Add(paramAttribute2Name); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramAttribute2Type); return(SqlHelper.ExecuteNonQuery(cmd)); }