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 map(PollItemInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.PollSysNo = Util.TrimIntNull(tempdr["PollSysNo"]);
oParam.ItemName = Util.TrimNull(tempdr["ItemName"]);
oParam.ItemCount = Util.TrimIntNull(tempdr["ItemCount"]);
}
public int InsertItem(PollItemInfo oParam)
{
string sql = @"INSERT INTO Poll_Item
(
PollSysNo, ItemName, ItemCount
)
VALUES (
@PollSysNo, @ItemName, @ItemCount
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPollSysNo = new SqlParameter("@PollSysNo", SqlDbType.Int, 4);
SqlParameter paramItemName = new SqlParameter("@ItemName", SqlDbType.NVarChar, 200);
SqlParameter paramItemCount = new SqlParameter("@ItemCount", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PollSysNo != AppConst.IntNull)
{
paramPollSysNo.Value = oParam.PollSysNo;
}
else
{
paramPollSysNo.Value = System.DBNull.Value;
}
if (oParam.ItemName != AppConst.StringNull)
{
paramItemName.Value = oParam.ItemName;
}
else
{
paramItemName.Value = System.DBNull.Value;
}
if (oParam.ItemCount != AppConst.IntNull)
{
paramItemCount.Value = oParam.ItemCount;
}
else
{
paramItemCount.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPollSysNo);
cmd.Parameters.Add(paramItemName);
cmd.Parameters.Add(paramItemCount);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public void InsertItem(PollItemInfo oParam)
{
new PollDac().InsertItem(oParam);
}
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();
}
}
