public void map(ProductRemarkInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.Title = Util.TrimNull(tempdr["Title"]);
oParam.Remark = Util.TrimNull(tempdr["Remark"]);;
oParam.Score = Util.TrimIntNull(tempdr["Score"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.OptIP = Util.TrimNull(tempdr["OptIP"]);
}
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 product_remark ";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( Util.HasMoreRow(ds) )
throw new BizException("the table product_remark 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
1 as sysno, WebUserSysNo as CustomerSysNo,
convert_1.newsysno as ProductSysNo,
createtime, title, isnull(remark, '') as remark, score, status
from
ipp2003..product_remark as pr, ippconvert..productbasic convert_1
where
pr.productsysno = convert_1.oldsysno";
DataSet ds1 = SqlHelper.ExecuteDataSet(sql1);
foreach(DataRow dr1 in ds1.Tables[0].Rows)
{
ProductRemarkInfo oRemark = new ProductRemarkInfo();
map(oRemark,dr1);
if ( oRemark.Remark == "")
oRemark.Remark = "нч";
if ( oRemark.Title == "")
oRemark.Title = "нч";
new ProductRemarkDac().Insert(oRemark);
}
scope.Complete();
}
}
public void Insert(ProductRemarkInfo oParam)
{
new ProductRemarkDac().Insert(oParam);
}
public int Insert(ProductRemarkInfo oParam)
{
string sql = @"INSERT INTO Product_Remark
(
CustomerSysNo, ProductSysNo, CreateTime,
Title, Remark, Score, Status,OptIP
)
VALUES (
@CustomerSysNo, @ProductSysNo, @CreateTime,
@Title, @Remark, @Score, @Status,@OptIP
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int,4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int,4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramTitle = new SqlParameter("@Title", SqlDbType.NVarChar,200);
SqlParameter paramRemark = new SqlParameter("@Remark", SqlDbType.NText);
SqlParameter paramScore = new SqlParameter("@Score", SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
SqlParameter paramOptIP = new SqlParameter("@OptIP",SqlDbType.NVarChar,50);
paramSysNo.Direction = ParameterDirection.Output;
if ( oParam.CustomerSysNo != AppConst.IntNull)
paramCustomerSysNo.Value = oParam.CustomerSysNo;
else
paramCustomerSysNo.Value = System.DBNull.Value;
if ( oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if ( oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if ( oParam.Title != AppConst.StringNull)
paramTitle.Value = oParam.Title;
else
paramTitle.Value = System.DBNull.Value;
if ( oParam.Remark != AppConst.StringNull)
paramRemark.Value = oParam.Remark;
else
paramRemark.Value = System.DBNull.Value;
if ( oParam.Score != AppConst.IntNull)
paramScore.Value = oParam.Score;
else
paramScore.Value = System.DBNull.Value;
if ( oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
if (oParam.OptIP != AppConst.StringNull)
paramOptIP.Value = oParam.OptIP;
else
paramOptIP.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramTitle);
cmd.Parameters.Add(paramRemark);
cmd.Parameters.Add(paramScore);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramOptIP);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
