/// <summary>
/// 导入行数据插入到数据库
/// </summary>
/// <param name="model"></param>
/// <param name="transaction"></param>
private void EmportRowInsert(ModProhibited model, SqlTransaction transaction)
{
//insert语句
string sql = @"insert into prohibitedgood(type, pname, premark, created, created_time)
values(@type, @pname, @premark, @created, getdate())";
//参数数组
SqlParameter[] _params = new SqlParameter[] {
new SqlParameter("@type", model.Type),
new SqlParameter("@pname", model.PName),
new SqlParameter("@premark", model.PRemark),
new SqlParameter("@created", model.Created)
};
//执行插入操作
SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, sql, _params);
}
/// <summary>
/// 导入行数据更新到数据库
/// </summary>
/// <param name="model"></param>
/// <param name="transaction"></param>
private void EmportRowUpdate(ModProhibited model, SqlTransaction transaction)
{
//update语句
string sql = @"update prohibitedgood set type = @type, pname = @pname, premark = @premark,
updated = @updated, updated_time = getdate() where pid = @pid";
//参数数组
SqlParameter[] _params = new SqlParameter[] {
new SqlParameter("@type", model.Type),
new SqlParameter("@pname", model.PName),
new SqlParameter("@premark", model.PRemark),
new SqlParameter("@updated", model.Updated),
new SqlParameter("@pid", model.Pid)
};
//执行更新操作
SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, sql, _params);
}
/// <summary>
/// 判断数据库中禁运物品名称是否已存在
/// </summary>
/// <param name="model"></param>
/// <param name="transaction"></param>
/// <returns></returns>
private int EmportRowIsRepeat(ModProhibited model, SqlTransaction transaction)
{
//不为空时, 禁运物品名称 数据库是否已存在
string strSql = string.Format("select top 1 pid from prohibitedgood where type = {0} and pname = '{1}'",
model.Type, model.PName.Trim());
object result = SQLHelper.ExecuteScalar(transaction, CommandType.Text, strSql, null);
//返回对应记录ID
if (null == result)
{
return(0);
}
else
{
return(Convert.ToInt32(result));
}
}
