public int CompareTo(object obj) { WebBulletinInfo b = obj as WebBulletinInfo; if (this.OrderNum > b.OrderNum) { return(1); } else { return(-1); } }
public int Update(WebBulletinInfo oParam) { string sql = @"UPDATE WebBulletin SET Title=@Title, Content=@Content, CreateDate=@CreateDate, OrderNum=@OrderNum, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 500); SqlParameter paramContent = new SqlParameter("@Content", SqlDbType.Text, 0); SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.Title != AppConst.StringNull) paramTitle.Value = oParam.Title; else paramTitle.Value = System.DBNull.Value; if (oParam.Content != AppConst.StringNull) paramContent.Value = oParam.Content; else paramContent.Value = System.DBNull.Value; if (oParam.CreateDate != AppConst.DateTimeNull) paramCreateDate.Value = oParam.CreateDate; else paramCreateDate.Value = System.DBNull.Value; if (oParam.OrderNum != AppConst.IntNull) paramOrderNum.Value = oParam.OrderNum; else paramOrderNum.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramTitle); cmd.Parameters.Add(paramContent); cmd.Parameters.Add(paramCreateDate); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(WebBulletinInfo oParam) { string sql = @"INSERT INTO WebBulletin ( Title, Content, CreateDate, OrderNum, Status ) VALUES ( @Title, @Content, @CreateDate, @OrderNum, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 500); SqlParameter paramContent = new SqlParameter("@Content", SqlDbType.Text, 0); SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.Title != AppConst.StringNull) paramTitle.Value = oParam.Title; else paramTitle.Value = System.DBNull.Value; if (oParam.Content != AppConst.StringNull) paramContent.Value = oParam.Content; else paramContent.Value = System.DBNull.Value; if (oParam.CreateDate != AppConst.DateTimeNull) paramCreateDate.Value = oParam.CreateDate; else paramCreateDate.Value = System.DBNull.Value; if (oParam.OrderNum != AppConst.IntNull) paramOrderNum.Value = oParam.OrderNum; else paramOrderNum.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramTitle); cmd.Parameters.Add(paramContent); cmd.Parameters.Add(paramCreateDate); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
private void map(WebBulletinInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.Title = Util.TrimNull(tempdr["Title"]); oParam.Content = Util.TrimNull(tempdr["Content"]); oParam.CreateDate = Util.TrimDateNull(tempdr["CreateDate"]); oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public void Update(WebBulletinInfo oParam) { new WebBulletinDac().Update(oParam); }
public void MoveUp(WebBulletinInfo oParam) { SortedList sl = GetWebBulletinList(); if (sl == null) { throw new BizException("no items"); } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { WebBulletinDac o = new WebBulletinDac(); foreach (WebBulletinInfo item in sl.Keys) { if (item.OrderNum == oParam.OrderNum - 1) { item.OrderNum += 1; o.SetOrderNum(item); } } oParam.OrderNum -= 1; o.SetOrderNum(oParam); scope.Complete(); } }
public WebBulletinInfo LoadWebBulletin(int SysNo) { string sql = @"select * from WebBulletin where sysno=" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; WebBulletinInfo o = new WebBulletinInfo(); map(o, ds.Tables[0].Rows[0]); return o; }
public void Insert(WebBulletinInfo oParam) { new WebBulletinDac().Insert(oParam); }
public SortedList GetWebBulletinList(int Top) { string sql = @"select top " + Top + " * from WebBulletin order by ordernum"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; SortedList sl = new SortedList(ds.Tables[0].Rows.Count); foreach (DataRow dr in ds.Tables[0].Rows) { WebBulletinInfo item = new WebBulletinInfo(); map(item, dr); sl.Add(item, null); } return sl; }
public int SetOrderNum(WebBulletinInfo oParam) { string sql = "update WebBulletin set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo; SqlCommand cmd = new SqlCommand(sql); return SqlHelper.ExecuteNonQuery(cmd); }