public int Insert(PollInfo oParam) { string sql = @"INSERT INTO Poll ( PollName, PollCount, Status ) VALUES ( @PollName, @PollCount, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4); SqlParameter paramPollName = new SqlParameter("@PollName", SqlDbType.NVarChar,200); SqlParameter paramPollCount = new SqlParameter("@PollCount", SqlDbType.Int,4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4); paramSysNo.Direction = ParameterDirection.Output; if ( oParam.PollName != AppConst.StringNull) paramPollName.Value = oParam.PollName; else paramPollName.Value = System.DBNull.Value; if ( oParam.PollCount != AppConst.IntNull) paramPollCount.Value = oParam.PollCount; else paramPollCount.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(paramPollName); cmd.Parameters.Add(paramPollCount); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public void Import() { if ( !AppConfig.IsImportable) throw new BizException("Is Importable is false"); /* do not use the following code after Data Pour in */ string sql = " select top 1 * from poll "; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( Util.HasMoreRow(ds) ) throw new BizException("the table poll is not empty"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sql1 = "select * from ipp2003..poll"; DataSet ds1 = SqlHelper.ExecuteDataSet(sql1); foreach(DataRow dr1 in ds1.Tables[0].Rows) { PollInfo oPoll = new PollInfo(); map(oPoll,dr1); switch( oPoll.Status) { case -1: case 0: oPoll.Status = (int)AppEnum.BiStatus.InValid; break; case 1: oPoll.Status = (int)AppEnum.BiStatus.Valid; break; default: throw new BizException("no such status"); } //��sysnono��û�иı���ǰ����һ��item���ַ���:�� string sql2 = "select * from ipp2003..poll_item where pollsysno=" + oPoll.SysNo; new PollDac().Insert(oPoll); DataSet ds2 = SqlHelper.ExecuteDataSet(sql2); foreach(DataRow dr2 in ds2.Tables[0].Rows) { PollItemInfo oPollItem = new PollItemInfo(); map(oPollItem, dr2); oPollItem.PollSysNo = oPoll.SysNo; new PollDac().InsertItem(oPollItem); } } scope.Complete(); } }
public void map(PollInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.PollName = Util.TrimNull(tempdr["PollName"]); oParam.PollCount = Util.TrimIntNull(tempdr["PollCount"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public PollInfo Load(int sysno) { string sql = "select * from poll where sysno = " + sysno; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( !Util.HasMoreRow(ds)) return null; PollInfo oPoll = new PollInfo(); map(oPoll, ds.Tables[0].Rows[0]); string sqlItem = "select * from poll_item where pollsysno = " + sysno +" order by ItemName" ; DataSet dsItem = SqlHelper.ExecuteDataSet(sqlItem); if ( Util.HasMoreRow(dsItem)) { foreach(DataRow dr in dsItem.Tables[0].Rows) { PollItemInfo oPollItem = new PollItemInfo(); map(oPollItem, dr); oPoll.itemHash.Add(oPollItem.SysNo, oPollItem); } } return oPoll; }
public void Insert(PollInfo oParam) { new PollDac().Insert(oParam); }