public int CompareTo(object obj) { PrjItemInfo b = obj as PrjItemInfo; if (this.SysNo > b.SysNo) { return(1); } else { return(-1); } }
public int Update(PrjItemInfo oParam) { string sql = @"UPDATE Prj_Item SET PrjSysNo=@PrjSysNo, SlnItemSysNo=@SlnItemSysNo, DefaultProductSysNo=@DefaultProductSysNo, DefaultQty=@DefaultQty, IsShowPic=@IsShowPic, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty",SqlDbType.Int,4); SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic",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.PrjSysNo != AppConst.IntNull) paramPrjSysNo.Value = oParam.PrjSysNo; else paramPrjSysNo.Value = System.DBNull.Value; if (oParam.SlnItemSysNo != AppConst.IntNull) paramSlnItemSysNo.Value = oParam.SlnItemSysNo; else paramSlnItemSysNo.Value = System.DBNull.Value; if (oParam.DefaultProductSysNo != AppConst.IntNull) paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo; else paramDefaultProductSysNo.Value = System.DBNull.Value; if (oParam.DefaultQty != AppConst.IntNull) paramDefaultQty.Value = oParam.DefaultQty; else paramDefaultQty.Value = System.DBNull.Value; if (oParam.IsShowPic != AppConst.IntNull) paramIsShowPic.Value = oParam.IsShowPic; else paramIsShowPic.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(paramPrjSysNo); cmd.Parameters.Add(paramSlnItemSysNo); cmd.Parameters.Add(paramDefaultProductSysNo); cmd.Parameters.Add(paramDefaultQty); cmd.Parameters.Add(paramIsShowPic); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(PrjItemInfo oParam) { string sql = @"INSERT INTO Prj_Item ( PrjSysNo, SlnItemSysNo, DefaultProductSysNo, DefaultQty, IsShowPic, Status ) VALUES ( @PrjSysNo, @SlnItemSysNo, @DefaultProductSysNo, @DefaultQty, @IsShowPic, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4); SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic",SqlDbType.Int,4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.PrjSysNo != AppConst.IntNull) paramPrjSysNo.Value = oParam.PrjSysNo; else paramPrjSysNo.Value = System.DBNull.Value; if (oParam.SlnItemSysNo != AppConst.IntNull) paramSlnItemSysNo.Value = oParam.SlnItemSysNo; else paramSlnItemSysNo.Value = System.DBNull.Value; if (oParam.DefaultProductSysNo != AppConst.IntNull) paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo; else paramDefaultProductSysNo.Value = System.DBNull.Value; if (oParam.DefaultQty != AppConst.IntNull) paramDefaultQty.Value = oParam.DefaultQty; else paramDefaultQty.Value = System.DBNull.Value; if (oParam.IsShowPic != AppConst.IntNull) paramIsShowPic.Value = oParam.IsShowPic; else paramIsShowPic.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(paramPrjSysNo); cmd.Parameters.Add(paramSlnItemSysNo); cmd.Parameters.Add(paramDefaultProductSysNo); cmd.Parameters.Add(paramDefaultQty); cmd.Parameters.Add(paramIsShowPic); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public PrjItemInfo LoadPrjItem(int SysNo) { string sql = "select * from prj_item where sysno=" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); PrjItemInfo oParam = new PrjItemInfo(); if (Util.HasMoreRow(ds)) mapPrjItem(oParam, ds.Tables[0].Rows[0]); else oParam = null; return oParam; }
public int InsertUpdatePrjItem(PrjItemInfo oParam) { string sql = "select * from prj_item where prjsysno = " + oParam.PrjSysNo + " and SlnItemSysNo=" + oParam.SlnItemSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { oParam.SysNo = Util.TrimIntNull(ds.Tables[0].Rows[0]["sysno"]); return new PrjDac().Update(oParam); } else { return new PrjDac().Insert(oParam); } }
public int InsertPrjItem(PrjItemInfo oParam) { string sql = "select * from prj_item where prjsysno = " + oParam.PrjSysNo + " and SlnItemSysNo=" + oParam.SlnItemSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("the same exists already"); return new PrjDac().Insert(oParam); }
public SortedList GetPrjItemList(int PrjSysNo) { string sql = @"select * from prj_item where prjsysno = @prjysno"; sql = sql.Replace("@prjysno", PrjSysNo.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) { PrjItemInfo item = new PrjItemInfo(); mapPrjItem(item, dr); sl.Add(item, null); } return sl; }
private void mapPrjItem(PrjItemInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.PrjSysNo = Util.TrimIntNull(tempdr["PrjSysNo"]); oParam.SlnItemSysNo = Util.TrimIntNull(tempdr["SlnItemSysNo"]); oParam.DefaultProductSysNo = Util.TrimIntNull(tempdr["DefaultProductSysNo"]); oParam.DefaultQty = Util.TrimIntNull(tempdr["DefaultQty"]); oParam.IsShowPic = Util.TrimIntNull(tempdr["IsShowPic"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public void UpdatePrjItem(PrjItemInfo 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(); } }