public int Insert(OnlineListQAInfo oParam)
{
if (LoadOnlineListQA(oParam.OnlineAreaType, oParam.CategorySysNo, oParam.QASysNo) != null)
{
throw new BizException("duplicated!");
}
return(new OnlineListQADac().Insert(oParam));
}
private void map(OnlineListQAInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.OnlineAreaType = Util.TrimIntNull(tempdr["OnlineAreaType"]);
oParam.CategorySysNo = Util.TrimIntNull(tempdr["CategorySysNo"]);
oParam.QAType = Util.TrimIntNull(tempdr["QAType"]);
oParam.QASysNo = Util.TrimIntNull(tempdr["QASysNo"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.ListOrder = Util.TrimIntNull(tempdr["ListOrder"]);
}
public OnlineListQAInfo LoadOnlineListQA(int OnlineAreaType, int CategorySysNo, int QASysNo)
{
string sql = "select * from onlinelistQA where onlineareatype=" + OnlineAreaType + " and categorysysno=" + CategorySysNo + " and QASysNo=" + QASysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
OnlineListQAInfo oInfo = new OnlineListQAInfo();
map(oInfo, ds.Tables[0].Rows[0]);
return(oInfo);
}
else
{
return(null);
}
}
public int Update(OnlineListQAInfo oParam)
{
return(new OnlineListQADac().Update(oParam));
}
public int Insert(OnlineListQAInfo oParam)
{
string sql = @"INSERT INTO OnlineListQA
(
OnlineAreaType, CategorySysNo, QAType, QASysNo, CreateUserSysNo,
CreateTime, ListOrder
)
VALUES (
@OnlineAreaType, @CategorySysNo, @QAType, @QASysNo, @CreateUserSysNo,
@CreateTime, @ListOrder
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramOnlineAreaType = new SqlParameter("@OnlineAreaType", SqlDbType.Int, 4);
SqlParameter paramCategorySysNo = new SqlParameter("@CategorySysNo", SqlDbType.Int, 4);
SqlParameter paramQAType = new SqlParameter("@QAType", SqlDbType.Int, 4);
SqlParameter paramQASysNo = new SqlParameter("@QASysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramListOrder = new SqlParameter("@ListOrder", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.OnlineAreaType != AppConst.IntNull)
{
paramOnlineAreaType.Value = oParam.OnlineAreaType;
}
else
{
paramOnlineAreaType.Value = System.DBNull.Value;
}
if (oParam.CategorySysNo != AppConst.IntNull)
{
paramCategorySysNo.Value = oParam.CategorySysNo;
}
else
{
paramCategorySysNo.Value = System.DBNull.Value;
}
if (oParam.QAType != AppConst.IntNull)
{
paramQAType.Value = oParam.QAType;
}
else
{
paramQAType.Value = System.DBNull.Value;
}
if (oParam.QASysNo != AppConst.IntNull)
{
paramQASysNo.Value = oParam.QASysNo;
}
else
{
paramQASysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.ListOrder != AppConst.IntNull)
{
paramListOrder.Value = oParam.ListOrder;
}
else
{
paramListOrder.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramOnlineAreaType);
cmd.Parameters.Add(paramCategorySysNo);
cmd.Parameters.Add(paramQAType);
cmd.Parameters.Add(paramQASysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramListOrder);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public int Update(OnlineListQAInfo oParam)
{
string sql = @"UPDATE OnlineListQA SET
OnlineAreaType=@OnlineAreaType, CategorySysNo=@CategorySysNo,
QAType=@QAType, QASysNo=@QASysNo, CreateUserSysNo=@CreateUserSysNo,
CreateTime=@CreateTime, ListOrder=@ListOrder
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramOnlineAreaType = new SqlParameter("@OnlineAreaType", SqlDbType.Int, 4);
SqlParameter paramCategorySysNo = new SqlParameter("@CategorySysNo", SqlDbType.Int, 4);
SqlParameter paramQAType = new SqlParameter("@QAType", SqlDbType.Int, 4);
SqlParameter paramQASysNo = new SqlParameter("@QASysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramListOrder = new SqlParameter("@ListOrder", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.OnlineAreaType != AppConst.IntNull)
{
paramOnlineAreaType.Value = oParam.OnlineAreaType;
}
else
{
paramOnlineAreaType.Value = System.DBNull.Value;
}
if (oParam.CategorySysNo != AppConst.IntNull)
{
paramCategorySysNo.Value = oParam.CategorySysNo;
}
else
{
paramCategorySysNo.Value = System.DBNull.Value;
}
if (oParam.QAType != AppConst.IntNull)
{
paramQAType.Value = oParam.QAType;
}
else
{
paramQAType.Value = System.DBNull.Value;
}
if (oParam.QASysNo != AppConst.IntNull)
{
paramQASysNo.Value = oParam.QASysNo;
}
else
{
paramQASysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.ListOrder != AppConst.IntNull)
{
paramListOrder.Value = oParam.ListOrder;
}
else
{
paramListOrder.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramOnlineAreaType);
cmd.Parameters.Add(paramCategorySysNo);
cmd.Parameters.Add(paramQAType);
cmd.Parameters.Add(paramQASysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramListOrder);
return(SqlHelper.ExecuteNonQuery(cmd));
}
