/// <summary>
/// 导入行数据插入到数据库
/// </summary>
/// <param name="model"></param>
/// <param name="transaction"></param>
private void EmportRowInsert(ModTaxnNumber model, SqlTransaction transaction)
{
//insert语句
string sql = @"insert into goodtaxnumber(ptaxnumber, ptaxprice, ptaxrate) values(@ptaxnumber, @ptaxprice, @ptaxrate)";
//参数数组
SqlParameter[] _params = new SqlParameter[] {
new SqlParameter("@ptaxnumber", model.PTaxNumber),
new SqlParameter("@ptaxprice", model.PTaxPrice),
new SqlParameter("@ptaxrate", model.PTaxRate)
};
//执行插入操作
SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, sql, _params);
}
/// <summary>
/// 导入行数据更新到数据库
/// </summary>
/// <param name="model"></param>
/// <param name="transaction"></param>
private void EmportRowUpdate(ModTaxnNumber model, SqlTransaction transaction)
{
//update语句
string sql = @"update goodtaxnumber set ptaxnumber = @ptaxnumber, ptaxprice = @ptaxprice, ptaxrate = @ptaxrate
where pid = @pid";
//参数数组
SqlParameter[] _params = new SqlParameter[] {
new SqlParameter("@ptaxnumber", model.PTaxNumber),
new SqlParameter("@ptaxprice", model.PTaxPrice),
new SqlParameter("@ptaxrate", model.PTaxRate),
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(ModTaxnNumber model, SqlTransaction transaction)
{
//不为空时, 商品税号 数据库是否已存在
string strSql = string.Format("select top 1 pid from goodtaxnumber where ptaxnumber = '{0}'", model.PTaxNumber.Trim());
object result = SQLHelper.ExecuteScalar(transaction, CommandType.Text, strSql, null);
//返回对应记录ID
if (null == result)
{
return(0);
}
else
{
return(Convert.ToInt32(result));
}
}
