/// <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)); } }