public int CompareTo(object obj) { PrjTypeInfo b = obj as PrjTypeInfo; if (this.OrderNum > b.OrderNum) { return(1); } else { return(-1); } }
public int GetPrjTypeNewOrderNum(PrjTypeInfo oParam) { string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from prj_type where slnsysno=" + oParam.SlnSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { return Int32.Parse(ds.Tables[0].Rows[0][0].ToString()); } else { return 1; } }
public int Insert(PrjTypeInfo oParam) { string sql = @"INSERT INTO prj_type ( SlnSysNo, ID, Name, Title, Description, OrderNum, Status ) VALUES ( @SlnSysNo, @ID, @Name, @Title, @Description, @OrderNum, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSlnSysNo = new SqlParameter("@SlnSysNo", SqlDbType.Int, 4); SqlParameter paramID = new SqlParameter("@ID", SqlDbType.NVarChar, 50); SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 500); SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 500); SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.Text, 0); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SlnSysNo != AppConst.IntNull) paramSlnSysNo.Value = oParam.SlnSysNo; else paramSlnSysNo.Value = System.DBNull.Value; if (oParam.ID != AppConst.StringNull) paramID.Value = oParam.ID; else paramID.Value = System.DBNull.Value; if (oParam.Name != AppConst.StringNull) paramName.Value = oParam.Name; else paramName.Value = System.DBNull.Value; if (oParam.Title != AppConst.StringNull) paramTitle.Value = oParam.Title; else paramTitle.Value = System.DBNull.Value; if (oParam.Description != AppConst.StringNull) paramDescription.Value = oParam.Description; else paramDescription.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(paramSlnSysNo); cmd.Parameters.Add(paramID); cmd.Parameters.Add(paramName); cmd.Parameters.Add(paramTitle); cmd.Parameters.Add(paramDescription); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public int Update(PrjTypeInfo oParam) { string sql = @"UPDATE prj_type SET SlnSysNo=@SlnSysNo, ID=@ID, Name=@Name, Title=@Title, Description=@Description, OrderNum=@OrderNum, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSlnSysNo = new SqlParameter("@SlnSysNo", SqlDbType.Int, 4); SqlParameter paramID = new SqlParameter("@ID", SqlDbType.NVarChar, 50); SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 500); SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar, 500); SqlParameter paramDescription = new SqlParameter("@Description", SqlDbType.Text, 0); 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.SlnSysNo != AppConst.IntNull) paramSlnSysNo.Value = oParam.SlnSysNo; else paramSlnSysNo.Value = System.DBNull.Value; if (oParam.ID != AppConst.StringNull) paramID.Value = oParam.ID; else paramID.Value = System.DBNull.Value; if (oParam.Name != AppConst.StringNull) paramName.Value = oParam.Name; else paramName.Value = System.DBNull.Value; if (oParam.Title != AppConst.StringNull) paramTitle.Value = oParam.Title; else paramTitle.Value = System.DBNull.Value; if (oParam.Description != AppConst.StringNull) paramDescription.Value = oParam.Description; else paramDescription.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(paramSlnSysNo); cmd.Parameters.Add(paramID); cmd.Parameters.Add(paramName); cmd.Parameters.Add(paramTitle); cmd.Parameters.Add(paramDescription); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int SetOrderNum(PrjTypeInfo oParam) { string sql = "update prj_type set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo; SqlCommand cmd = new SqlCommand(sql); return SqlHelper.ExecuteNonQuery(cmd); }
public void MoveTop(PrjTypeInfo oParam) { if (oParam.OrderNum == 1) { throw new BizException("it's the top one already"); } SortedList sl = GetPrjTypeList(oParam.SlnSysNo); if (sl == null) { throw new BizException("no item for this solution"); } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { PrjDac o = new PrjDac(); foreach (PrjTypeInfo item in sl.Keys) { if (item.OrderNum < oParam.OrderNum) { item.OrderNum = item.OrderNum + 1; o.SetOrderNum(item); } } oParam.OrderNum = 1; o.SetOrderNum(oParam); scope.Complete(); } }
public void MoveDown(PrjTypeInfo oParam) { SortedList sl = GetPrjTypeList(oParam.SlnSysNo); if (sl == null) { throw new BizException("no items"); } if (oParam.OrderNum == sl.Count) { throw new BizException("it's the last one, can't be moved down"); } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { PrjDac o = new PrjDac(); foreach (PrjTypeInfo 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 PrjTypeInfo LoadPrjType(int SlnSysNo, int OrderNum) { string sql = @"select * from prj_type where slnsysno=@slnsysno and ordernum=@ordernum"; sql = sql.Replace("@slnsysno", SlnSysNo.ToString()).Replace("@ordernum", OrderNum.ToString()); DataSet ds = SqlHelper.ExecuteDataSet(sql); PrjTypeInfo oParam = new PrjTypeInfo(); if (Util.HasMoreRow(ds)) mapPrjType(oParam, ds.Tables[0].Rows[0]); else oParam = null; return oParam; }
public PrjTypeInfo LoadPrjType(int SysNo) { string sql = "select * from prj_type where sysno=" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); PrjTypeInfo oParam = new PrjTypeInfo(); if (Util.HasMoreRow(ds)) mapPrjType(oParam, ds.Tables[0].Rows[0]); else oParam = null; return oParam; }
public int InsertPrjType(PrjTypeInfo oParam) { string sql = "select * from prj_type where slnsysno = " + oParam.SlnSysNo + " and ID=" + Util.ToSqlString(oParam.ID); DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("the same ID exists already"); return new PrjDac().Insert(oParam); }
public int GetPrjTypeNewOrderNum(PrjTypeInfo oParam) { return new PrjDac().GetPrjTypeNewOrderNum(oParam); }
public SortedList GetPrjTypeList(int SlnSysNo) { string sql = @"select * from prj_type where slnsysno = @slnsysno order by ordernum"; sql = sql.Replace("@slnsysno", SlnSysNo.ToString()); 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) { PrjTypeInfo item = new PrjTypeInfo(); mapPrjType(item, dr); sl.Add(item, null); } return sl; }
private void mapPrjType(PrjTypeInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.SlnSysNo = Util.TrimIntNull(tempdr["SlnSysNo"]); oParam.ID = Util.TrimNull(tempdr["ID"]); oParam.Name = Util.TrimNull(tempdr["Name"]); oParam.Title = Util.TrimNull(tempdr["Title"]); oParam.Description = Util.TrimNull(tempdr["Description"]); oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public void UpdatePrjType(PrjTypeInfo oParam) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { new PrjDac().Update(oParam); scope.Complete(); } }