private void map(SearchKeyTrackInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.CustomerID = Util.TrimNull(tempdr["CustomerID"]);
oParam.Keyword = Util.TrimNull(tempdr["Keyword"]);
oParam.SearchTime = Util.TrimDateNull(tempdr["SearchTime"]);
}
public int Update(SearchKeyTrackInfo oParam)
{
string sql = @"UPDATE SearchKeyTrack SET
CustomerID=@CustomerID, Keyword=@Keyword,
SearchTime=@SearchTime
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerID = new SqlParameter("@CustomerID", SqlDbType.NVarChar, 50);
SqlParameter paramKeyword = new SqlParameter("@Keyword", SqlDbType.NVarChar, 200);
SqlParameter paramSearchTime = new SqlParameter("@SearchTime", SqlDbType.DateTime);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.CustomerID != AppConst.StringNull)
{
paramCustomerID.Value = oParam.CustomerID;
}
else
{
paramCustomerID.Value = System.DBNull.Value;
}
if (oParam.Keyword != AppConst.StringNull)
{
paramKeyword.Value = oParam.Keyword;
}
else
{
paramKeyword.Value = System.DBNull.Value;
}
if (oParam.SearchTime != AppConst.DateTimeNull)
{
paramSearchTime.Value = oParam.SearchTime;
}
else
{
paramSearchTime.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerID);
cmd.Parameters.Add(paramKeyword);
cmd.Parameters.Add(paramSearchTime);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(SearchKeyTrackInfo oParam)
{
string sql = @"INSERT INTO SearchKeyTrack
(
CustomerID, Keyword, SearchTime
)
VALUES (
@CustomerID, @Keyword, @SearchTime
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerID = new SqlParameter("@CustomerID", SqlDbType.NVarChar, 50);
SqlParameter paramKeyword = new SqlParameter("@Keyword", SqlDbType.NVarChar, 200);
SqlParameter paramSearchTime = new SqlParameter("@SearchTime", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.CustomerID != AppConst.StringNull)
{
paramCustomerID.Value = oParam.CustomerID;
}
else
{
paramCustomerID.Value = System.DBNull.Value;
}
if (oParam.Keyword != AppConst.StringNull)
{
paramKeyword.Value = oParam.Keyword;
}
else
{
paramKeyword.Value = System.DBNull.Value;
}
if (oParam.SearchTime != AppConst.DateTimeNull)
{
paramSearchTime.Value = oParam.SearchTime;
}
else
{
paramSearchTime.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerID);
cmd.Parameters.Add(paramKeyword);
cmd.Parameters.Add(paramSearchTime);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public int Update(SearchKeyTrackInfo oParam)
{
return(new SearchKeyTrackDac().Update(oParam));
}
public int Insert(SearchKeyTrackInfo oParam)
{
return(new SearchKeyTrackDac().Insert(oParam));
}
